Hi guys, I want to have a synthetic workload for testing various "performance features" of SQL Server. Here are the requirements of the workload off...
Short answer - Depending on the isolation level and plan used to execute the query, database objects will be locked. I would suggest looking at BEGIN...
Primary key is added to all the secondary indexes because when a record is accessed using NC index, there should be a way to go back to the original...
There is a major problem with this approach. You have not considered the time taken for compilation of the plan. In my exeriments, I have observed...
Have you checked out these liks? http://aspnet.4guysfromrolla.com/articles/031506-1.aspx -- SQL Server 2005...
This is blog entry by SQL Server Customer Advisory Team which is one of the main interface to external customers of SQL Server. I would think that...
http://blogs.msdn.com/sqlcat/archive/2006/05/19/602142.aspx Excerpt from the article- BEST PRACTICES and LESSIONS LEARNED Here is a list of...
Nope, both the indexes should have the same number of rows. Gaurav The views expressed here are those of the author and no one else. There are no...
Joe, Yes it does show plan in management studio. Table Scan on [ICEA].[dbo].[flowfile_au] is taking 91% of time and spitting out 431 million rows....
I would recommend dividing the problem and working on the most expensive pieces. Look for the stored procedures which take most of the time. Just a...
This should be useful ... http://www.sqlskills.com/blogs/kimberly/PermaLink.aspx?guid=8be9d388-b354-429f-8c98-e45989a4bebe Gaurav The views...
I need a script which takes in a text file containing SQL statement and spits out formatted SQL with nice tabs and indentation. Has somebody done...
I have a doubt that the stats may have got updated during the first query execution. Try running the queriies after updating stats manually. For...
quote:Originally posted by FrankKalis quote:Originally posted by raja_rksb1 hi , i am planning to have a sql server which could have 3 tables and...
Question ... Is hyperthreading enabled on the server? Gaurav Moderator Man thrives, oddly enough, only in the presence of a challenging environment-...
Try limiting the maximum memory SQL can use. The value of the same will depend on how much memory application server needs. Gaurav Moderator Man...
http://support.microsoft.com/default.aspx?scid=kb;en-us;271509 should help u .... partciluarly DBCC SQLPERF(WAITSTATS) Gaurav Moderator Man...
I am sure all of us agree with Derrick on that!!! Gaurav Moderator Man thrives, oddly enough, only in the presence of a challenging environment- L....
Hey guys! Give me a break!!! I joined when half the month was over! BTW, I really appreciate the fact that you guys are so highly motivated to keep...
MSDE setup is pretty silent and the user doesn't have to know about it. See the information file in the package for MSDE for the command for...
Separate names with a comma.
