Topics
Started by
Posts
Last post
Hi Please suggest on the following : How can we know that any particular SQL database running in a…
1 replies
Can someone help to how to remove the cursor. when i look at the stored proc most of the stored pr…
13 replies
Hi, Will faster disks improve query performance? Thanks.
5 replies
I have 2 insert statements inserting records into 2 temp tables. When the 2 statements are placed i…
36 replies
Hi all, I have a stored procedure that works fine in the Test/Development environment. I get the re…
4 replies
I need to optimize the below script. The tblTransactionHistoryC has over 210 million rows and tblTr…
2 replies
select v.health_care_plan_id, v.health_care_plan_name, v.formulary_id, v.drug_label_a…
3 replies
Hello, I am using nested stored procedures. Created a temp table in the outer procedure. Inserting …
1 replies
Hello, I have a query the runs very fast and is ordered by order_id. As soon as I add the order_da…
19 replies
Here is the query select email_address from mailing_list This is the table script. USE [SUN_HERALD…
6 replies
Hi, been looking at profiler over the last few weeks and want to know the difference between CPU an…
7 replies
Hi, My production sql server cpu is at 100% and i am trying to trobuleshoot the issue but not sure …
16 replies
Scenario.... the following query took ages to execute SELECT Getdate(),'01 Aug 2008 00:00:00', '01…
4 replies
Hi, I am looking into the possiblity of prioritizing one database over another. The reason for thi…
2 replies
I have a table with about 100 columns and several million rows. About 200,000 records need to be r…
3 replies
Viewing 15 topics - 436 through 450 (of 2,581 total)
You must be logged in to create new topics.