Topics
Started by
Posts
Last post
This is my first message here so firstly i would liek to say 'Hello'. I have a problem i hope that …
1 replies
Hello, I want to insert a large number of records (e.g. 500,000 rows). I want to tune my query. I a…
10 replies
Here's my scenario: I have a production database which stores information regarding campaigns. This…
2 replies
Hello, I'm querying sys.dm_db_index_usage_stats and seeing values > 0 for the column user_lookup…
7 replies
hi below is my table with its index defintion CREATE TABLE [dbo].[INVITEE]( [acct_id] [dbo].[ut…
7 replies
Dear Friends, is there a way we can find out statistics information like (last updated, rows, sampl…
5 replies
By: yvr4
I would like to know, how the storage engine does the "clustered index scan" operation. I mean whet…
7 replies
Something I spent a great deal of time tracking down. Thought I would share my findings: I recentl…
3 replies
I have a relatively simple query (from an application we purchased) that when ran pegs a 24 core pr…
15 replies
Hi all, In order to monitor performance, I've got a trace set up to run on the 1st Tuesday of each …
11 replies
We have a client with a long running query (on the order of 10 hours). The query JOIN's a bunch of…
19 replies
Is it possible to create nonclustered index on columns with space and ignore the space so that it d…
10 replies
Hi all. We have the following problem: In a windows 2003 server with sql server 2008 SP1, with 512 …
14 replies
By: SQLRNNR
I have read considerably about this subject and seen many different opinions. If someone is an aut…
4 replies
Interested in strategies for maintaining Terabyte tables. Partitioning in 2005 and 2008 is severely…
13 replies
By: SQLRNNR
Viewing 15 topics - 1,411 through 1,425 (of 3,249 total)
You must be logged in to create new topics.