Viewing 15 posts - 35,761 through 35,775 (of 49,552 total)
Please post entire query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
November 18, 2009 at 7:26 am
Did you look here: https://partner.microsoft.com/global/program and more specifically here: https://partner.microsoft.com/global/40013031
Fees apparently vary by country, so contact them and ask (provided your company meets all the other requirements)
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
November 18, 2009 at 7:23 am
jcrawf02 (11/18/2009)
Adding a clustered index that covers multiple columns within a table is not necessarily advantageous, because it will expand all of the non-clustered indexes as well. (from part II)
Yes
Therefore,...
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
November 18, 2009 at 7:18 am
DBTeam (11/18/2009)
So it won't create any problem right,even though if we insert million of records into that in the future.
Maybe. You need to test.
Unique constraint will not delay the insertion...
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
November 18, 2009 at 7:15 am
Please post full query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
November 18, 2009 at 5:37 am
An nvarchar(255) is a rather bad choice for a clustered index. Clustered indexes should be narrow (among other things). 512 bytes is not narrow.
If there an existing primary key 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
November 18, 2009 at 5:36 am
It's a clustered SQL Server. The only drives that will be visible to it are the drives which are set up as cluster resources and dependencies for the SQL service....
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
November 18, 2009 at 5:31 am
gr8.jain (11/18/2009)
now i attached the execution plan
Where?
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
November 18, 2009 at 5:25 am
Look in Books Online for the page titled "System Views" (Also available on msdn)
As for counts...
http://sqlinthewild.co.za/index.php/2009/04/14/on-counts/
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
November 18, 2009 at 12:34 am
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
November 18, 2009 at 12:26 am
DBTeam (11/17/2009)
how long it will take to drop it..
How long is a piece of string?
There's no simple answer. Depends on the size of the table (in MB), the other activity,...
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
November 18, 2009 at 12:26 am
On 2008 Enterprise you can look at Change Tracking, Change Data Capture and SQL Audit. Haven't actually worked with any of them, so can't really give you an opinion. Play...
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
November 18, 2009 at 12:23 am
1b. Probably, but why would you want to use MAX? Jason posted showing a couple of queries for getting the row counts from sys.partitions.
2. Don't understand the question. Order of...
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
November 18, 2009 at 12:18 am
cos_ta393 (11/17/2009)
My hope is that sql server has it in system table / views that I can just query.
It doesn't. If you want to know how many rows have...
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
November 17, 2009 at 12:49 pm
Very strange. Not sure what's happening there.
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
November 17, 2009 at 12:38 pm
Viewing 15 posts - 35,761 through 35,775 (of 49,552 total)