Viewing 15 posts - 4,321 through 4,335 (of 49,571 total)
SQL-DBA-01 (11/10/2015)
You can think to run extended events. Much lighter compared to Profiler.
SQL 2008 had a limited set of extended events. It wasn't until 2012 that they could entirely replace...
November 11, 2015 at 12:47 am
No simple answer to that. You need to consider why you're partitioning the table, where the files are, what the purpose of the multiple filegroups is and a whole lot...
November 10, 2015 at 1:17 pm
Steve Jones - SSC Editor (11/10/2015)
GilaMonster (11/10/2015)
November 10, 2015 at 10:30 am
An uncontrolled shutdown should not have caused errors. It feels like an update to the system tables was lost.
Maybe check with the storage admins that any write caches are properly...
November 10, 2015 at 6:38 am
I've recently seen a system with many user-defined functions, each with thousands of lines of code, often calling each other. Tests or no tests, I'm not touching that.
November 10, 2015 at 6:30 am
Depends on whether there's a witness. Is there?
November 10, 2015 at 6:27 am
No. It means that of the current plans in cache, only a few used parallelism. Depending how stable the plan cache is and when you looked at it, the plans...
November 10, 2015 at 4:42 am
When was the last clean checkDB on that database?
Usually this kind of error is a leftover from SQL 2000, someone deleted rows from the system tables on SQL 2000 (where...
November 10, 2015 at 4:39 am
andrew.leef (11/9/2015)
But we use it mostly for reporting, so generally it doesn't matter if a transaction is in process at the time.
So your users are perfectly happy getting reports that...
November 9, 2015 at 2:18 pm
Yes, the hint will override the isolation level.
Since read committed snapshot already takes no read locks, using nolock gets you all of the disadvantages of that isolation level (dirty reads,...
November 9, 2015 at 2:14 pm
Repeated corruption is almost always an IO subsystem problem. Not necessarily the disks, could be anything in the IO path, controllers, cache, switches, fiber cable, disks, etc, etc.
You may also...
November 9, 2015 at 12:32 pm
Or you could upgrade to SQL 2016 and use a TEMPORAL table. No triggers necessary. 🙂
November 9, 2015 at 11:43 am
http://connect.microsoft.com and file a bug. It's a preview, bugs are expected.
That said, I saw CTP 3 in use by a lot of people over the last 2 weeks, so maybe...
November 9, 2015 at 11:25 am
You can look at currently running queries as much as you like, but queries are not what use memory, and so you'll be wasting time looking at that.
SQL's memory usage...
November 9, 2015 at 11:19 am
Viewing 15 posts - 4,321 through 4,335 (of 49,571 total)