Topics
Started by
Posts
Last post
hi there, i need to generate results from two pivot query for that i use the global temporary table…
3 replies
Hi, Background... SQL Server 2005 sp2. Mirrored with witness Problem Every few days queries start g…
8 replies
[font="Verdana"]Hi All, I have one Stored Procedure which frequently gets executed. Though it is a …
5 replies
Hello, We are having an issue with our financial application client where users are being kicked ou…
2 replies
Hi, I have enabled trace on my server running sql server 2005 with template "Tunning" with all defa…
3 replies
Hi All, I have a table named "Tbl_Inv" in my database that contains 4.7 Lacs records with six non c…
19 replies
Hi all, I have one job which takes some time to execute, about 2 hours. During the job, CPU usage …
9 replies
Hi All, I have 2 sql sevr 2005 instances with same build no,same edition. I restored the database…
6 replies
A basic question, i was analyzing an execution plan and found a keylookup using most of the CPU...S…
2 replies
if i am selecting the some distince records from the large data sets, which is better to use for pe…
3 replies
Hi, Which DMV can be used or is there any query which can give me an exact data about the CPU Usage…
1 replies
Hi, We are using the table variables inside the sp. It is working fine at QA and staging server. Wh…
13 replies
Hi Guru, How to configure this -g switch? Do I need need to configure with integer value or just -g…
1 replies
Hi All, I had a table (Size = 10GB) with Millions of records that was storing ShowXML plan through …
3 replies
Can someone explain WHY adding the self referring join condition on acct.BillingType decreases the …
6 replies
Viewing 15 topics - 226 through 240 (of 3,249 total)
You must be logged in to create new topics.