Topics
Started by
Posts
Last post
Someone pls point to some articles that decsribe, how statistics is maintained and managed internal…
9 replies
We are having a new server which has SQL 2005 standard edition SP2 installed on it (OS windows 200…
5 replies
Everywhere I read, I notice that if the filegroups (partitioned) and indexes are placed on differen…
2 replies
I have spent the last few weeks trying to improve a web based systems performance by looking at bad…
24 replies
Suppose you created a file with 30,000 or more lines of "insert into values" to a table in TempDB. …
9 replies
Hello I have recorded a Profiler trace to a flat file using the sp_trace procs. When I query the fl…
11 replies
I am trying to use sys.dm_exec_sessions to check how many reads I just did in TSQL... I can use STA…
3 replies
Hello guys We have a strange case. We have a SAP , on Windows 2003, using SQL Server 2005, and usin…
12 replies
Hi Guys! i'm still a junior DB Developer with a problem in one of the solutions i work on; at work …
2 replies
Hi, I have a web application (ASP.NET 2.0) connecting to a sql server 2005 instance (SP2) residing …
1 replies
Hi i want to schedule updatestatistic command for the indexes , my system is 24/7 used. how many ti…
5 replies
is there any way to view what kind lock happening to table when query get executing ?
3 replies
First of all, yes I know what's the difference between an inner join and a left join just in case s…
22 replies
Hi Guys, Need some advice on something. I have a table that has indexes on a different filegroup, t…
8 replies
My initial query for a report returned 2.82 of data in 34509 rows and took 1:34. I removed some unn…
5 replies
Viewing 15 topics - 2,941 through 2,955 (of 3,249 total)
You must be logged in to create new topics.