I'd be constantly worried about torn pages. Dang teenagers.

WHILE 1 = 1
     BEGIN
          SELECT * FROM msdb..suspect_pages
 ...

Thanks Steve the below are results of

database_namedatabase_sizeunallocated space

Skynet 632264.44 MB1069.05 MB

reserveddataindex_sizeunused

625659272 KB614870648 KB7833128 KB2955496 KB

I will try the script out of increasing database size and look...

I have a 14 million record table that gets frequent updates, inserts, and reads from reports. I'm trying to find a way to improve the performance and reduce blocking\locking. Ideally...

Thanks Gail. For those benefits do you...

My guess is the credit card authorization guy would go first. Thanks for explaining the logic though!

have you updated statistics and or see any differences in execution plans compared to prod. Like compare the tasks in the execution plans with prod's.

also maybe prod has buffer cache...

GilaMonster (1/19/2014)

---

Depends. If you create the index on the partition scheme, it will be partitioned like the table and stored across the three filegroups. If you create the index on...

No two vms sorry.

For training (curiosity) reasons on my VM.

you're right. i couldn't test this because i'm on a iphone right now but if he added WHERE filetype = 'log' in his subquery on the join then it should...

Ah man I forgot we can replace subqueries with joins which is faster than subqueries

Evil Kraig F (8/14/2012)

---

I personally usually just do them in a single build, like so:

SELECT

s.[databaseid]

,s.[databasename]

,s.[filename]

,s.[filetype]

FROM

#stuff AS...

Beautiful! I have no experience with partition. Does it have a better execution plan too? I could find out myself but I'm on an iPhone right now.

smallmoney (8/14/2012)

---

For example I...

Windows Event Log (Application):

SQL Server Scheduled Job 'SystemDB MaintenancePlan.Full Backup' (0x6CB778EBF25F664B91FA765B1513846E) - Status: Failed - Invoked on: 2012-07-23 00:00:00 - Message: The job failed. The Job was invoked by...

Vikrant S Patil (7/24/2012)

---

Further can you try backing any database manually to the same storage location preferably logged in as LOBSTERVC1\sqlagtacct_vc ?

like say:

Backup database master to disk =...