Topics
Started by
Posts
Last post
We have recently upgraded to SQL Server 2005 and now we are facing a very High Context Switches/sec…
6 replies
Hey all, I have a scenario where I have a table containing lots of data which needs to be processed…
4 replies
I have a Multi line TVF (Takes 6 parameters ) which executes much slower then if i pull out the th…
16 replies
SQLserver flags UDF that executes some selects as non-deterministic. Some other servers let develop…
6 replies
I have a query which creates two temp tables and selects data from them. This takes 7 seconds when …
12 replies
Hi, I have one table having more than 3 millions rows with following columns: [SITE_ID] [USER_NAME]…
7 replies
Is there any harm giving permissions to a developer to run tuning advisor. How do i do it?
1 replies
This table has millions of record. so when i am using a case statement in the update statement it t…
5 replies
I see lot of difference performance wise when running the same query in QA and same from view. Quer…
6 replies
I am trying to find the best way to speed up certain counts from a table. Is there a good way to i…
10 replies
We have MSSQL2000 installed on 4processor 16gb DEV box. On the same box we have MSSQL2005 instance …
7 replies
i used TSQL_SPs template to trace the sps of two databases..i made some changes in the template as …
7 replies
I am somewhat new to SQL 2005. I am attempting to find the Index tuning wizard like in SQL 2000 Qu…
2 replies
I have a production server that replicates data to another server. The production server has 28gb …
11 replies
I have a few staging tables. They are highly active tables with a lot of inserts and deletes. Sho…
4 replies
Viewing 15 topics - 2,251 through 2,265 (of 3,249 total)
You must be logged in to create new topics.