Viewing 15 posts - 28,396 through 28,410 (of 49,552 total)
Spam. Reported. No replies please
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
January 18, 2011 at 1:27 am
JayK (1/17/2011)
Using COALESCE certainly looks a lot neater.....
Neater maybe. Well performing? Definitely not.
http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/
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
January 17, 2011 at 11:05 pm
Absolutely no way to tell.
The dirty page count is just the number of pages which have been modified in cache. It's not something where there's numbers for good and bad....
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
January 17, 2011 at 11:05 pm
The clustered index is been updated. While you may not be updating the clustered index key, as I mentioned in the article "A clustered index is an index where 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
January 17, 2011 at 10:56 pm
pdanes2 (1/17/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
January 17, 2011 at 10:51 pm
SanDroid (1/17/2011)
Not certain who is learning.Restoring a group of pages can restore an extent.
There is no RESTORE DATABASE ... EXTENT command. There is a RESTORE DATABASE ... FILEGROUP, a RESTORE...
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
January 17, 2011 at 10:49 pm
There's no command to do that. Script out the pk and the other stuff using management studio, then use CREATE TABLE and INSERT INTO rather than SELECT INTO.
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
January 17, 2011 at 10:45 pm
SELECT ... INTO just creates the table. Nothing more. If you want constraints, indexes, defaults or anything like that you'll have to add them afterwards, or explicitly create the table...
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
January 17, 2011 at 3:09 pm
pdanes2 (1/17/2011)
You've lost me here. Do you mean when the query contains a WHERE clause, it would hunt through the index more efficiently?
No, I'm saying that since there's no...
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
January 17, 2011 at 1:39 pm
A stored procedure can only have one plan cached at a time (baring different set options), so if you have a case like Grant describes, where different parameters can result...
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
January 17, 2011 at 1:34 pm
Anyone want to handle Desperately Seeking Page Split Solution here? http://www.sqlservercentral.com/Forums/Topic1048687-391-1.aspx. Looks to me like premature optimisation, but I'm too tired to have another look
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
January 17, 2011 at 1:28 pm
Koen (da-zero) (1/17/2011)
GilaMonster (1/17/2011)
Was one of the things that contributed to me leaving the bank. The over-paid consultants from Big Named Consulting Company were considered (by upper management) to know...
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
January 17, 2011 at 10:52 am
pdanes2 (1/17/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
January 17, 2011 at 10:49 am
pdanes2 (1/17/2011)
"It doesn't work" gets little sympathy in these forums
No, because it's near-impossible to offer useful advice for that. When we have some indication what's not working, that's a whole...
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
January 17, 2011 at 8:01 am
A: No
B: Maybe, test and see. Doubt it will be a major difference.
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
January 17, 2011 at 7:59 am
Viewing 15 posts - 28,396 through 28,410 (of 49,552 total)