Topics
Started by
Posts
Last post
Hello, Does anyone know why some indexes would not rebuild (the Index Physical Stats report says Re…
6 replies
By: bang725
I'm having a performance problem, while migrating a large amount of data from one database to anoth…
34 replies
Guys, I have an employee table in which each employee is categorized by employee type (up to 100 ty…
19 replies
By: sgmunson
How to identify long running or blocking area in the stored procedure using sql server 2000 profiler
2 replies
We currently have a database that contains 12 tables containing related information. The tables co…
5 replies
We have a query which we are tuning but at the present it generates a LARGE amount of reads. When f…
2 replies
I used DMV's to get some detailed information on indexes. Running the query resulted in significant…
1 replies
insert Emp select E.* from JobType as E , X..EmpIND as ID where E.EMpid = ID.Empid collate Latin1_G…
6 replies
Hi, I have a cursor which fetch around 1000 rows from the table. This step is fast there is no isue…
7 replies
Hi, I have query that ,when I try to run it, takes a very long time. But during the runtime if I c…
7 replies
Could someone please pin point the cause of it? The exact same query finishes in a few seconds with…
7 replies
Dear All, I have a table which has got an IDENTITY COLUMN. There is another column in the same ta…
7 replies
By: Lowell
I've got a page lock on my application, but i don't know how to read it. i've attached xml file fro…
1 replies
Hi, We want to move some hugely used tables to another filegroup.For that we have added one filegro…
9 replies
By: bang725
can somebody tell me about below results ? DBCC SHOWCONTIG scanning 'Universal' table... Table: 'Un…
2 replies
Viewing 15 topics - 2,341 through 2,355 (of 3,249 total)
You must be logged in to create new topics.