Viewing 15 posts - 2,596 through 2,610 (of 49,571 total)
Try restarting the SQL Server instance.
At the time it started, the drive was probably inaccessbile and SQL won't retry.
If that works, you need to investigate why the drive was...
August 22, 2016 at 5:24 am
navtec (8/22/2016)
But that would give me all of the indexes for all tables in that database?
Yes.
You'll still have to run it in each database, the schema-views are per-database, not per-server.
August 22, 2016 at 5:22 am
EXECUTE (@ExecSQL)
Without the brackets, the string is assumed to be a stored procedure name.
August 22, 2016 at 5:21 am
Is drive X accessible? Can you see the files on it?
August 22, 2016 at 5:06 am
Got a backup of MSDB from before the jobs 'disappeared'?
August 22, 2016 at 3:48 am
The first thing I'd recommend is not using 2008 R2.
August 20, 2016 at 11:36 pm
In relational theory, something isn't a table until it has a key. In SQL Server, tables without keys are perfectly valid, and you can partition a heap with no indexes...
August 20, 2016 at 3:15 pm
patrickmcginnis59 10839 (8/20/2016)
edit: lol that's your article. So isn't "HOLDLOCK" sort of implying an on the fly "elevation to serializable?" Just edicating myself not trying to argue!
Hehe. Yes, it's my...
August 20, 2016 at 3:12 pm
August 20, 2016 at 11:00 am
bcrockett (8/19/2016)
bcrockett (8/19/2016)
CASE WHEN [TotalStaffedTime] = 0 THEN 0 else ((do this calculation))And I tried this, and its not working, is my syntax wrong?
Probably. What't the exact syntax you...
August 20, 2016 at 4:23 am
Welsh Corgi (8/20/2016)
What do you mean play with the schema?
It's a spam-type post (pushing DB recovery tools), talking about filtered index problems, hence not relevant to your errors (spatial indexes)
August 20, 2016 at 3:21 am
It's far more likely that the time difference is due to data caching than the plan being cached. The QO doesn't take seconds to generate query plans in most cases,...
August 20, 2016 at 3:14 am
Not with EXEC, but you can use sp_executesql to execute strings with parameters.
That said, there's absolutely no need for dynamic SQL in the code you posted. This is equivalent and...
August 20, 2016 at 3:11 am
SQLRNNR (8/19/2016)
GilaMonster (8/19/2016)
!!!!https://www.pluralsight.com/courses/identifying-fixing-performance-issues-caused-parameter-sniffing
And massive amount of work it was too. Recording's the easy part. Scripting is the most time consuming, editing probably the most difficult.
Congrats!
You ready to do some on...
August 19, 2016 at 2:29 pm
Viewing 15 posts - 2,596 through 2,610 (of 49,571 total)