Viewing 15 posts - 26,161 through 26,175 (of 49,552 total)
An insert ... select will insert every single row that the select returns, or it will insert 0 (in the case of an error). SQL doesn't selectively insert rows, 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
May 12, 2011 at 10:01 am
They're not both waiting for resources.
A sleeping process is one that is doing nothing. It's finished running any queries and is just sitting idle. If you connect from management studio,...
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
May 12, 2011 at 9:59 am
Define duplicate data.
What's it not doing that you want it to do?
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
May 12, 2011 at 9:57 am
steve.anderson 7639 (5/12/2011)
Dan's posted code produces:Msg 102, Level 15, State 1, Line 5
Incorrect syntax near '0'.
The code you posted would cause that exact error because of the 2 extra...
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
May 12, 2011 at 9:47 am
Nope. SQL's data type is bit, not boolean. 0, 1 or null.
Your code is not the same as what Dan posted. Use the code Dan posted, the modifications you made...
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
May 12, 2011 at 9:41 am
Did you try looking in Books Online before asking? Because the page on Update Statistics clearly states which option is default.
http://msdn.microsoft.com/en-us/library/ms187348.aspx
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
May 12, 2011 at 8:15 am
Clustered and nonclustered indexes? (as opposed to clustered instances)
If so
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/
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
May 12, 2011 at 8:13 am
harsha.bhagat1 (5/12/2011)
Is there any way to apply the differential backup to my database if its not in Loading state?
Nope. Recovering the database means that no more backups can be restored.
If...
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
May 12, 2011 at 8:08 am
Did you get any errors when you restored the second one?
Check the restore history (msdb) and make sure that you did restore the backups that you think you restored, not...
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
May 12, 2011 at 5:30 am
That's pretty much never going to perform well.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
An index rebuild invalidates all plans that used those indexes, necessitating a recompile next time the queries run. An Update Statistics on that...
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
May 12, 2011 at 4:27 am
What exactly did you do (all the steps)?
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
May 12, 2011 at 4:24 am
addisionphilip (5/11/2011)
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
May 12, 2011 at 2:31 am
terrykzncs (5/11/2011)
Sorry for taking so long to reply; I'm replying while at work.Please see below links:
http://www.sql.co.il/books/insidetsql2008/Logical%20Query%20Processing%20Poster.pdf
Emphasis Logical processing order. That's not the actual, physical operators that SQL uses, it's the...
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
May 11, 2011 at 12:36 pm
Specify the precision and scale when you declare your decimals. I don't offhand know the defaults, but it may not be what you intended.
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
May 11, 2011 at 10:11 am
No. It's info got from configuration manager and Active Directory.
Brian's asking to try and ascertain just how much risk there is, whether this security setup just risks the database 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
May 11, 2011 at 10:00 am
Viewing 15 posts - 26,161 through 26,175 (of 49,552 total)