Viewing 15 posts - 34,591 through 34,605 (of 49,552 total)
Henrico Bekker (1/19/2010)
As far as I know, it's 1 temp datafile per CPU Core....
Depending who you ask it's anything from 0.25 files/core to 1 file/core. But that's just the optimum...
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 19, 2010 at 5:45 am
Bhuvnesh (1/19/2010)
amar , try to run the script i pasted in my previous past and u will find reply
The Row_Number function is not the same as the RowID that Oracle...
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 19, 2010 at 5:42 am
Bhuvnesh (1/19/2010)
if you see above example , Primary key is made with non clustered key forcibly on "secondaryindex " filegroupWHILE
Clustered index on other filegroup "secondarydata" filegroup
Yes?...
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 19, 2010 at 5:41 am
Can you repost that deadlock graph so that it's readable please. Either attach the xml file that profiler produces or use traceflag 1222 and post the output of that.
The one...
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 19, 2010 at 5:38 am
amitsingh308 (1/19/2010)
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 19, 2010 at 5:15 am
I don't understand what you're asking. Adding another column to an index to make it wider/covering has absolutely nothing to do with where in the files the indexes are stored....
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 19, 2010 at 5:14 am
Bhuvnesh (1/19/2010)
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 19, 2010 at 4:53 am
Don't play with the CPU affinity unless you have a really good reason. In most cases it should be left at default.
The number of data files is not linked 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
January 19, 2010 at 4:50 am
SQL Server does not have a 'row ID' assigned to each row by the DB engine. Oracle may (I think), but SQL doesn't.
What problem are you trying to solve...
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 19, 2010 at 4:45 am
Is there a question here, or is this an observation?
You can always reference a column from an outer table within a subquery. It may look odd, but it is valid...
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 19, 2010 at 4:10 am
From what I recall from SQL 2000, you cannot assign the results of a FOR XML query to a 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
January 19, 2010 at 2:41 am
select session_id, blocking_session_id from sys.dm_exec_requests
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 19, 2010 at 2:39 am
That's good to know. Can you change the isolation level in the linq? If you do, does it fix the deadlocks?
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 19, 2010 at 2:27 am
Your first index is covering. That means that all SQL has to do to completely satisfy the query is to do an index seek.
The second index is not covering. 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
January 19, 2010 at 2:26 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 19, 2010 at 2:14 am
Viewing 15 posts - 34,591 through 34,605 (of 49,552 total)