Viewing 15 posts - 19,006 through 19,020 (of 49,552 total)
Because IN does not work the way you think it does.
Column IN (@Var1) is the same as Column = @Var1, and the value that you have for your variable...
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
April 18, 2012 at 4:51 am
ALZDBA (4/18/2012)
Thank you for bringing this up, Gail !
I did indeed failed to mention to take the sqlinstance down before the snapshot creation 🙁
Even with the instance stopped, it's...
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
April 18, 2012 at 4:47 am
When an index is rebuilt, the statistics on that index are updated as part of the rebuild. Hence there is not need to update that index's statistics, though there may...
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
April 18, 2012 at 4:44 am
Then your problem is with the network latency. Speak to a network admin, the database is not the problem here.
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
April 18, 2012 at 3:25 am
Ells (4/16/2012)
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
April 18, 2012 at 3:23 am
ALZDBA (4/18/2012)
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
April 18, 2012 at 3:20 am
ALZDBA (4/18/2012)
and if it is being hosted on a virtual machine .... ask your VM/Hyper-V sysadmins to take a snapshot before you start your upgarde ! ( easy revert )
However...
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
April 18, 2012 at 3:18 am
That query is as optimal as it is going to get (though the index is horrid and should likely never have been created)
If it's slow check whether the problem 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
April 18, 2012 at 1:55 am
If the DB was in full recovery model, first try to take a tail-log backup. Once that's done restore from your last good backups. Restore all log backups in sequence,...
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
April 18, 2012 at 1:52 am
http://ola.hallengren.com/versions.html
http://sqlfool.com/2011/06/index-defrag-script-v4-1/
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
April 18, 2012 at 1:51 am
Log shipping works up-version, the only thing is that the DB and logs on the secondary have to be restored WITH NORECOVERY. STANDBY is not an option when the primary...
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
April 18, 2012 at 1:49 am
Yeah, apply in a dev/test environment and test the hell out of them.
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
April 18, 2012 at 1:44 am
In what context and related to what product?
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
April 18, 2012 at 1:36 am
Hard to tell without the tools that CSS has. If it's important, open a case with them. They have tools to read these and access to the private symbols.
It looks...
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
April 18, 2012 at 1:35 am
Edit: one check constraint is enough...
CHECK ((C = 150 AND A IS NOT NULL) OR (C = 151 AND B IS NOT NULL))
Not syntax checked, but should get you 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
April 17, 2012 at 3:15 pm
Viewing 15 posts - 19,006 through 19,020 (of 49,552 total)