Topics
Started by
Posts
Last post
Hi, I am trying to loop thru a current dataset of 10million+ records. I receive XML data in a text …
8 replies
AS in below query if we use "option(recompile)" then it execute in a one second but if we remove th…
9 replies
Hi There, I need an SQL that could get the current CPU usage in SQL 2005, in 2008 it's easy but i c…
5 replies
Logical Reads count can be get by using follwoing ways Below are the ways to check logical Reads: 1…
3 replies
I have a table with 100 columns. I want to sort on each column. My Front-end decides which column i…
16 replies
Hi all, This may not be the correct place for this, but it seems to fit. Here's the situation, I've…
5 replies
I have a really wired issue doing on. One of the Stored Procedure takes about 5 mins to execute the…
11 replies
Hi All Recently had a serious issue on a production data SAN and thus had to move our DB's off the …
10 replies
Hello, At a customer we are experiencing severe performance issues. The performance issues seem to …
5 replies
I am getting deadlock but I am not able to understand the below deadlock graph. I am not able to un…
8 replies
We're running SQL Server 2005 Standard x64 on a dedicated Windows 2003 x64 box. It has quad 6-core …
11 replies
Hi, I have a common table expression that returns the below Num 1 2 3 I also have a select stateme…
2 replies
guyz i wanna add total in my sql query i want to show in cross tab DECLARE @query1 NVARCHAR(max) SE…
2 replies
Hi, My sql server database is down, so my application performance is also down due to the database …
5 replies
Hi I am sure this question has been asked before but still .... I am running a procedure that load…
7 replies
Viewing 15 topics - 376 through 390 (of 3,249 total)
You must be logged in to create new topics.