Topics
Started by
Posts
Last post
Hi all I noticed in task manager that sqlservr.exe looked to be hogging memory so I ran some perfm…
4 replies
I have a LINQ generated TSQL statement. LINQ is very fond of generating derived tables E.g. SELECT …
9 replies
I've come across a problem with an index that runs contrary to what I know about indexes. I'm hopin…
11 replies
What kind of performance could you expect extracting data through a linked server? I am extracting …
8 replies
Can somebody tell me what is ideal size for table. Ideal size means a. Number of rows ? b. Number o…
8 replies
I'm looking for thoughts/feedback on the following idea: NOTE: First off let me say that I can’t pr…
6 replies
I am trying to globally suppress the 'xxx row(s) affected' messages for all queries on a SQL Server…
3 replies
I am running the stored procedure where it includes bulk insert for many tables. I have a question …
2 replies
Hi All, Just implemented partitioning in SQL Server 2005. Which should be a great tool for better f…
8 replies
I'm helping with a performance tuning project at work and thought I understood the duration column …
3 replies
Dear Firends, I need some help with tuning the below query: SELECT assetdesc, runname, …
9 replies
I have a question regarding the Disk counters in performance monitor. I am monitoring a server that…
7 replies
I have a database in PROD1 and PROD2 environments. Both the databases are identical including index…
4 replies
Here is the issue: Developers want statistics created on every column :w00t: on every table :w00t: …
17 replies
I am having a problem with the first case statement in my query. Its telling me that the error is L…
2 replies
Viewing 15 topics - 1,231 through 1,245 (of 3,249 total)
You must be logged in to create new topics.