Topics
Started by
Posts
Last post
select v.health_care_plan_id, v.health_care_plan_name, v.formulary_id, v.drug_label_a…
4 replies
I have the following query that returns blocking and blocked SPID info, when blocking persists for …
3 replies
I've actually solved this but thought I would post up my findings as I couldnt find anything search…
3 replies
By: GSquared
Dear All, The PC anywhere services on our live server are getting hung quite often.I spoke to our s…
1 replies
What does the Pages field mean on the Fragmentation Page under Index Properties. Is that the numbe…
1 replies
Is there a way to free the buffer cache without stop starting the SQL Server service? I am testing …
1 replies
By: Ray Mond
Our database currently uses SELECT FOR XML to return xml-formatted data to the busines tier. I am p…
3 replies
I have a large table that is partitioned by yearmonth. When I query on this table by the partition…
21 replies
I am working on optimizing a query and I believe I have done as much as I can on the query itself..…
9 replies
Dear All, One of my tale gives problem in live server. It hangs when I fire a simple select quer…
7 replies
Is there any way, a trigger mail/task could be generated when a particular databse gets deadlocked …
7 replies
I have a procedure that inserts and then updates roughly 2 million rows with roughly 8 million rows…
1 replies
Dear All, I wrote below procedure and it's working fine. But it throws error when I change data…
4 replies
Hi, Can any body tell me that how can we remove fragementation on a table without an Index? Thanks
11 replies
Hello Guys, We set up an environment which has principal server, mirror server and witness server f…
4 replies
Viewing 15 topics - 2,521 through 2,535 (of 3,249 total)
You must be logged in to create new topics.