Topics
Started by
Posts
Last post
Hello all, I am running Windows Server 2003 R2 standard Edition with SP1, using IIS, and SQL Server…
5 replies
Hi All, Queries response in our application is taking some time on first request only (usually 3 se…
10 replies
Hi, can someone offer me some guidance please? My tempdb has grown to 27GB, something I haven't bee…
5 replies
Hi, I have created 1 stored procedure for down loading the products into excel file from the data…
3 replies
How can I turn off logging during load and updating records in a datawarehouse? I have a few proced…
29 replies
Hi all, 🙂 In my application,when i try to query data from two tables giving the joining con…
4 replies
Hi, I have a partitioned view (uv_rules) to link tables organised by date (ut_rules_2008_02_29, ut_…
25 replies
We are changing domain level from mixed mode to native and have sql 2000 on server 2003, what is t…
1 replies
I was wondering which is the fastest method of creating a dynamic SQL statement which references th…
20 replies
I have a general question is it better to join several tables when trying to get a result set i.e. …
1 replies
Hi, A server has 2 databases A and B (700GB each). B is the copy of A. A query makes use of paralle…
11 replies
I've been reading several articles and there appears to be a conflict of opinions. Is there any poi…
4 replies
Hi, I had scenario were my Sp hanged at one particular line. Using profiler I was able to find out …
4 replies
A number of indices in our database are highly fragmented. After running the rebuild command as in:…
7 replies
Hi Guys, I have the following query: select count (distinct(isnull([columnname1],[columnname2]))) f…
4 replies
Viewing 15 topics - 571 through 585 (of 2,581 total)
You must be logged in to create new topics.