Topics
Started by
Posts
Last post
Please execute the below script which will create a table and populate few rows. Then execute the q…
6 replies
Can some one please send me the link to get the latest hotfixes for sql 2000 sp4? Also please provi…
2 replies
We are running SQL Server 2005 SP3 on a guest OS on VM Ware. Many Times we have self-blocking spids…
8 replies
I would like to know what is the best procedure to defrag *Data *Index *Files in a SQL Server 2005 …
5 replies
Hi, How can i find out which one of the procedure need to be optimize in the server profiler? th…
5 replies
select empid, empspec into tmpempids from dbo.vwEmp as a inner join tmpeligdates as b on a.CustID=b…
17 replies
Hi everyone, I’m facing a bit of a strange problem with processor affinity mask settings. I recentl…
16 replies
We've got a SQL 2005 database where we're experiencing some blocks once or twice a day. I've enabl…
5 replies
How to maintain the same identity column during the sql 2005 to sql 2008 migration? For example, th…
3 replies
I have a table in SQL 2000, indexed on a client and Material Number (not Clustered, not unique) th…
4 replies
We're bringing a new system on line, and some users are complaining of some slowness. This is on S…
2 replies
Hi all I currently have some indexes I wish to enable the allow page lock option on, but wish to kn…
6 replies
How can I identify the INDEX a given query is using? My proc runs in 15 min's on SQL 2000. We migr…
1 replies
if I set my fill factor at 50 now every other row there is a blank,with a 100 row table, 50 rows pe…
5 replies
Hi friends, We have some stored procedures (173 proc) which import data from external system to o…
2 replies
Viewing 15 topics - 1,576 through 1,590 (of 3,249 total)
You must be logged in to create new topics.