Topics
Started by
Posts
Last post
Now ,A table Table1 have 300 columns and 6000 rows, with Table2 Left Join. example: SELECT t1.*,…
7 replies
I have a trigger that appears to execute a very large number of logical reads; on one occasion it h…
38 replies
Hello all, i have some questions: 1. what's the different between clustered and non clustered? i've…
13 replies
What is the recommended options from BOL about the memory usage configuration of Win2k3 for sql ser…
5 replies
select M.* from DEV1.StatePA.dbo.Revenue as M , DEV1.Budget.dbo.PayPa as PP where M.RevID = PP.Rev…
10 replies
declare @start_pd_date as varchar(10), @end_pd_date as varchar(10); set @start_pd_date = Convert(va…
8 replies
Hi everyone, I Have a big report that is run via crystal reports that currently takes aorund 7-10 m…
12 replies
Is there anyway to keep complete SQL Server 2005 user database in Server's Physical memory? suppose…
41 replies
I wondered if anyone else has seen contention in tempdb due to the SQL Agent? I've got an issue wh…
4 replies
Hi all, I've got a business need here that needs to be fulfilled with a dynamic key. To be clearer,…
9 replies
I have a table of 39,842,660 rows and clustered index on the primary key. Here is the information I…
4 replies
Hello! Using SQL Server 2005, placing data into a database from a classic ASP page. I have a stored…
10 replies
I have been getting these messages very frequently from our performance diagnostic tool: 8/23/2008…
9 replies
Hi evryone, i need your graat help by suggesting the solution to my problem. Im us…
5 replies
I just been handed a project that has only one table, and one proc. This table has 300 inserts per …
13 replies
Viewing 15 topics - 2,146 through 2,160 (of 3,249 total)
You must be logged in to create new topics.