Topics
Started by
Posts
Last post
Hi everyone, I have inherited a dataware house database which contains 10 fact tables ( 50-60 milli…
2 replies
I'm thinking there's a better way to write this query. Any ideas? IF OBJECT_ID('TempDB..#persons'…
3 replies
I'm looking to help tune a query from a developer that is using left outer joins with a "AND column…
10 replies
I have a field called data_date that has the date. I have a table with 54 million rows and would li…
2 replies
Hi I need some help on the best setup with the following: We have a Microsoft Windows Server 2003 E…
6 replies
Hi Experts, I have a SQL Table. And I have written againest of it lot of math Calculations and for…
6 replies
Hi Guys, I'm trying to optimize some of our queries. One of the thing I'll do is to create an index…
9 replies
I've a very complex query on which I'm working from past 2-3 weeks. Had already done lots of experi…
17 replies
I have an SP that runs in the neighborhood of 200ms on both our dev and staging servers but runs be…
4 replies
I wrote a piece of code that performed well on my laptop, extracting data from an XML into a temp t…
5 replies
Hi All, I have a bit of a newbie question for you I have a database upon which someone has run the …
12 replies
I am trying to improve the performance of this stored procedure. Any suggestions on how to improve …
6 replies
Can someone familiar with TableSpools take a look at the attached query plan? I'm beyond confused,…
3 replies
Have a production server with a 1.2tb db drive. Got down to only about 10% free space available. …
18 replies
I have table tbl_US with uptshipmentid as primary key column and also a clustered index on it. The …
1 replies
Viewing 15 topics - 676 through 690 (of 3,249 total)
You must be logged in to create new topics.