Topics
Started by
Posts
Last post
Hi folks I am tuning few stored procedures and when i analyze the execution plan for them one commo…
8 replies
I'm aware that profiler can show duration in microseconds. I'm running a trace for a specific DB w…
4 replies
is there any way to find out the user name who dropped the particular table in data base ?
8 replies
Hi Guys, Iam New To SQL Server DBA. My Question is IF we use excessive triggers . the performance o…
4 replies
I wanted to Test my Database performance by increasing load to n number of users. Is there any such…
1 replies
Hi, Does anyone know if the default sampling ratio for statistics is stored in a system table somew…
1 replies
Hello every Body, I have given a task to optimize a view, which is taking too long 30 to 35 …
6 replies
Today I stumbled on an really great feature while reading "INSIDE MICROSOFT SQL SERVER 2005 - QUERY…
8 replies
Hi, I have a table with appr 10 million records.(history data) While trying to retrieve records wit…
2 replies
With all of the databases that I have managed over many years the premise has been that optimal dat…
2 replies
I have this update SQL : UPDATE Table SET [Status]=1 WHERE CCID=@CCID where CCID is the primary ke…
23 replies
I have a stored proc that returns a result set. Several of the columns in that result set a coming…
6 replies
Hello, I am looking for a good SQL Server 2000/2005/2008 white paper on a methodology for monitorin…
3 replies
hi I need to tune a stored procedure. for that iam seeing the execution plan after the whole proced…
25 replies
hi, how to check the statistics are upto date or not?
4 replies
Viewing 15 topics - 2,716 through 2,730 (of 3,249 total)
You must be logged in to create new topics.