Viewing 15 posts - 11,791 through 11,805 (of 22,214 total)
Not sure, it seems to lag by an execution. If I run it once, it shows as the way I ran it previously.
Version: Microsoft SQL Server 2008 R2 (RTM)...
September 28, 2011 at 7:32 am
Jack Corbett (9/28/2011)
Hey can an execution plan expert (Grant?) take a look at this thread, http://www.sqlservercentral.com/Forums/Topic1181619-338-1.aspx. Interesting behavior noted in execution plan properties with SET ANSI NULLS.
I am NOT...
September 28, 2011 at 7:24 am
Just check the execution plans on the queries to see what, if anything, changes when the index goes away. It's not a measure of performance, but it's always good to...
September 28, 2011 at 7:05 am
Without the structure, this is just a guess, but couldn't you do a subselect to get the unique set of two columns and then join that to the rest of...
September 28, 2011 at 6:16 am
I have used a unique value in a compound index before, but not one that was already indexed, let alone the PK on the table and, I assume, the clustered...
September 28, 2011 at 6:11 am
I'd look at two different ways of doing this, and neither is moving the whole thing and then deleting.
1) You can use transactional replicatoin with filters so that only...
September 28, 2011 at 6:09 am
I've never heard of either of those backup softwares. Just curious, what is it that you're trying to get that you don't get using the native backup capabilities?
September 28, 2011 at 4:42 am
I remember one time we had a requirement that we had to return 100,000 rows in 3 seconds. I'm sitting there with my jaw on my chest asking why on...
September 27, 2011 at 12:21 pm
Tim Walker. (9/27/2011)
We're now about to kick off another round of evaluation (partly...
September 27, 2011 at 8:54 am
Not jargon, but unavoidable technical terms.
You can identify blocking processes by looking at dynamic management objects (DMO). The one that most concerns you is sys.dm_exec_requests. That shows active queries in...
September 27, 2011 at 5:31 am
opc.three (9/26/2011)
September 27, 2011 at 3:44 am
I don't know what TWS is either. I tried looking it up online but I'm getting crazy stuff like Texas World Speedway. You have to help us. We're not sitting...
September 27, 2011 at 3:42 am
If I were looking at starting an upgrade process right now, yeah, I'd jump on to Denali & skip 2008. Think of it like this, 2008 is already almost 4...
September 27, 2011 at 3:30 am
You can reference a unique constraint when making a foreign key. It's that or a primary key.
September 27, 2011 at 3:21 am
Clustering is all about availability in SQL Server and has nothing at all to do with performance.
If your query is slow, why is it slow? What does the execution plan...
September 26, 2011 at 8:47 am
Viewing 15 posts - 11,791 through 11,805 (of 22,214 total)