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
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
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
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
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.