Topics
Started by
Posts
Last post
Hi All, I need to write a query in order to fetch some standard reports for showing Performance of …
7 replies
Hi, Thanks for a great forum ... and site, really nice articles here đŸ™‚ I'm using .NET & SQL 20…
16 replies
I have a T-SQL query which has 3 conditions in the WHERE clause seperated by a AND operator. If i c…
5 replies
Hi there, total newbie here! i'm running sql doctor and it's recommending that we rewrite the wher…
3 replies
We recently moved physical database servers from our corporate office to a collocation facility, an…
1 replies
Hello to all, I'm running in trouble to specify a plan guide for a query issued with sp_executesql…
2 replies
Hi all, I'd like to add new / tune existing indexes on a specific table in order to achieve some pe…
11 replies
Infra Multi Instance Server -4 instances 8 CPU 16 GB memory—around 9 GB is always available Disk St…
12 replies
My guess is yes, and the RID column adds size to index2 since I guess it is stored twice, once as a…
14 replies
On sql 2005/2008, if you auto stats on and you regularly rebuild indexes, is there a need to update…
13 replies
Does anybody know a good reason why we would build a composite index using RID where RID is a PK? i…
10 replies
I have a SQL 2008R2 64 bit server running on VMWare and it is allocated 24 GB of memory allocated t…
1 replies
Hi All, I'm stuck in an interesting scenario. I've a procedure and I'm trying to optimize it, now b…
9 replies
what is the difference between RPC:Completed and SP:Completed in sqlprofiler. In profiler the info …
7 replies
I have 16 processors and 24 Gb Ram in my server . but now the server is using 21 gb of ram for las…
10 replies
Viewing 15 topics - 451 through 465 (of 3,249 total)
You must be logged in to create new topics.