Viewing 15 posts - 27,691 through 27,705 (of 49,552 total)
Wildcat (2/17/2011)
(if the clustered index is not unique, it must have the RID attached for the uniqueness).
Nope. The only time the RID is used in a nonclustered index 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
February 17, 2011 at 10:44 am
The total size of a database.
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
February 17, 2011 at 10:42 am
parthi-1705 (2/17/2011)
Denali is SQL Server 2011 version which was released last November 2010.MS has advice not to use Denali for Production,but we can use it in local development.
Denali (aka SQL...
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
February 17, 2011 at 10:42 am
mister.magoo (2/17/2011)
I have noticed in the past that COUNT(*) does not always force a full count of all rows
It does. It reads the leaf level of the smallest index to...
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
February 17, 2011 at 10:32 am
Brandie Tarvin (2/17/2011)
Raunak Jhawar (2/15/2011)
joydeep.das.mail (2/15/2011)
I need 70-445 brain dumpsJoydeep, dumps will only help you get a certificate on paper.Period.What next??
That's assuming the dumps are even close to accurate. Most...
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
February 17, 2011 at 10:28 am
mister.magoo (2/17/2011)
select count_big(all column_name)
Odd syntax. Why not count(*)?
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
February 17, 2011 at 4:14 am
Gianluca Sartori (2/17/2011)
Interesting avatar, Gail. But... what is it exactly?
It's a Gila Monster. 😀
What happened to Qui-Gon Jinn?
Taking a vacation. He'll be back soon (probably after I get back from...
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
February 17, 2011 at 2:47 am
Did you 'check the SQL error log for details'? If so, what does it say?
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
February 17, 2011 at 2:43 am
Duplicate post. No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1065489-391-1.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
February 17, 2011 at 2:42 am
Network? Streaming 6 million rows across the network won't be quick. Were you running local on the test server and remote on production perhaps?
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
February 17, 2011 at 2:41 am
Koen Verbeeck (2/17/2011)
Gianluca Sartori (2/17/2011)
Code brings more (pseudo)code, it seems...Definitely kill the one who started this on THE THREAD!
:-D:-D
I'll go fetch the angry mob! 🙂
There's a few of them roaming...
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
February 17, 2011 at 2:36 am
Just bear in mind that if you do convert a database to SQL 2008 R2 (which is the one with the 10GB limit), you will not be able to go...
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
February 17, 2011 at 2:26 am
Bungholio (2/16/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
February 17, 2011 at 2:22 am
LutzM (2/16/2011)
As a side note: you decided to use the "real Gila Monster" as your avatar?
Temporarily. Qui-gon will be back.
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
February 16, 2011 at 1:45 pm
Vertigo44 (2/16/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
February 16, 2011 at 1:43 pm
Viewing 15 posts - 27,691 through 27,705 (of 49,552 total)