We are looking to migrate from a busy datawarehouse server to a new server and I have been t…
9 years, 7 months ago
By: Modest DBA
could anny one please explain me the meaning of equality_columns, inequality_columns, included_c…
By: Gail Shaw
In our Database we have enabled the CDC initially from the past 2 years it has grown…
I have one Stored procedure That takes around 2 hour to execute.
it runs in 2 hours on server with …
By: Sean Lange
We have the db in staging server which runs in SQL 2008 R2 RTM version holding 32 GB of RAM. We hav…
I am seeing something in Sql 2008 (Express and R2) that I do not totally understand, I am hoping so…
I have attached an execution plan whose components are adding up to 248%
Though I was able to resol…
By: Kingston Dhasian
I have a huge amount of data table EMP with 15 columns, and it has only one primary key with its cl…
By: Neeraj Prasad Sharma
I was wondering if something that we do (as suggested by our partners) with HP-UX and Pr…
By: Perry Whittle
I have table
(Table_A (A_id int(PK),
I am trying to figure out which queries have caused blocking on my system, or which queries …
I am running SQL Server 2008 R2 (64-bit) standard on a Windows 2008 64-bit server. I typically noti…
Whar are the advantage and disadvantage of table partation in sql server.
trying to fine tune a stored procedure
it has 10 union all between select scripts..performance is v…
9 years, 8 months ago
By: Sean Pearce
I hope you pro's could help me out with some performance issues I'm having..
Oke, so we have so…
Viewing 15 topics - 616 through 630 (of 635 total)
You must be logged in to create new topics.