Topics
Started by
Posts
Last post
I recently took a position as a DBA and inherited some sql servers. One of the jobs that runs ever…
16 replies
Hi, One of our application have a complex SELECT query and it has been doing its job in 20-30 minu…
4 replies
Consider my table as follow, declare @tUsrAcct table ( TrnxID int identity(1,1) not null, UsrID var…
6 replies
I have a development laptop with a Windows XP sp3 and a 300GB drive partitioned into 2 parts. Driv…
2 replies
Hello all, I have been trying to determine how to make certain select query's more efficient and l…
4 replies
I need to monitor for a deadlock occurance. Which will have the least performance impact to the se…
3 replies
I required to implement to set index on view in order to improve the performance. plese help me wit…
3 replies
We have 2 servers. One running a hotfix of SP2. The other is a new dev server now on SP3. The spec …
3 replies
Summary: I have multiple tables...with good amount of data and it will definetly grow after every 3…
7 replies
Hello, this is my first post on ssc. I am not even sure if this is the correct forum for this quest…
19 replies
Hello, We have some performance problems and are now looking at our configuration of the SQL 2005. …
4 replies
How can we find an id/ spid which is blocking some other transaction using a query?
3 replies
I have a problem with perfomance when reading data in sql. Most probably because there are alot of …
1 replies
Is there any gain, performance or otherwise, to be had by placing all "Create Table" statements at …
4 replies
Hi, Fragmentation will occur if physical and logical order are different.. but there is a confusio…
5 replies
Viewing 15 topics - 1,381 through 1,395 (of 3,249 total)
You must be logged in to create new topics.