Topics
Started by
Posts
Last post
We have a vendor application+database, and noticed that a search took 1 minute on PROD server, but …
10 replies
I have started noticing tempdb contention on system tables(sysallocunits,sysschobjs, sysidxstats) t…
2 replies
Hi, For a sp which is causing dead lock,I replaced cursors ,so now it is causing time out some time…
6 replies
Hi all I have an upcoming task of trying to improve overall performance of a database. Our setup i…
11 replies
Hello, deadlock trace in sqlserver log by turning on T1222 flag. I see that the lock is happening o…
2 replies
Hi, when retrieving data from our DMS, the users often get a sql-timeout. It seems, that the SQL-St…
13 replies
Has anyone out there ever analyzed the Idera Alerts table. Tyring to work with SAN guy so when doi…
2 replies
Although this is currently occurring in SQL 2012, I have also seen it in 2008 R2, so I am posting h…
7 replies
I have a 3rd party database which means no control over design, I can control indexes (create, alte…
4 replies
Hi All, can you please help on this below task ? How to grab the dependent objects and check if we …
1 replies
Hi Guys, As we know the sys.dm_os_performance_counters is limited to SQL Server counters, so if you…
1 replies
I have a 3rd party app which has a separate file group called Index_1, the file group has individua…
4 replies
I have a production server which is having some just 4 million records. The client always need the …
4 replies
Suppose I have an index on columnA and columnB with columnX, columnY, and columnZ as included colum…
4 replies
Hi Everyone, Please see below query Select ID, ID1,Name, Cname from Customer where ID =(@IDSear…
19 replies
Viewing 15 topics - 211 through 225 (of 636 total)
You must be logged in to create new topics.