Viewing 15 posts - 2,596 through 2,610 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2016 at 5:22 am
EXECUTE (@ExecSQL)
Without the brackets, the string is assumed to be a stored procedure name.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2016 at 5:21 am
Is drive X accessible? Can you see the files on it?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2016 at 5:06 am
Got a backup of MSDB from before the jobs 'disappeared'?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2016 at 3:48 am
The first thing I'd recommend is not using 2008 R2.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 20, 2016 at 3:12 pm
http://source.entelect.co.za/why-is-this-upsert-code-broken
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 20, 2016 at 4:23 am
And your question is?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 20, 2016 at 4:18 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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 19, 2016 at 2:29 pm
Viewing 15 posts - 2,596 through 2,610 (of 49,552 total)