Viewing 15 posts - 16,111 through 16,125 (of 22,211 total)
Jeff Moden (12/4/2009)
Grant Fritchey (12/4/2009)
December 4, 2009 at 7:38 am
GSquared (12/4/2009)
December 4, 2009 at 6:56 am
GilaMonster (12/4/2009)
Grant Fritchey (12/4/2009)
More, absolutely more. The key values plus the include values plus the clustered key, it has to add up to more.
Depends what the key is. If...
December 4, 2009 at 6:53 am
ChiragNS (12/4/2009)
GrantDoes the default trace show delete statements?
Nope. Sorry. Stupid statement. It tracks errors & objects created/deleted, that sort of thing.
December 4, 2009 at 6:46 am
Great primer Barry. It covers the basics of what's needed very well. Since so many questions come through on the board around the concept of "How do I get started...
December 4, 2009 at 6:01 am
GilaMonster (12/4/2009)
sashikanta.mishra (12/3/2009)
December 4, 2009 at 5:55 am
Manie Verster (12/3/2009)
Per example
Password expiry period = 3 months
Password lock out = 3 failures
Strong password required = true
Now I know that by default SQL Server uses...
December 4, 2009 at 5:52 am
I generally prefer several smaller tools that do jobs really well. Take for example type ahead. It's built into SSMS, but it stinks. Get a copy of Red Gate SQL...
December 4, 2009 at 5:39 am
So you've got identical execution plans on identical databases on the same server, but one is running slow and the other is not?
Contention is the first thing that comes to...
December 3, 2009 at 12:43 pm
You've effectively written two different queries, and yeah, each query needs a different execution plan. Recompile is probably your best option.
December 3, 2009 at 12:19 pm
fminns-1058143 (12/3/2009)
But who/what is using up the other connection?
The reason I want single user mode is because I want to try testing a restore of the master database which...
December 3, 2009 at 9:13 am
fminns-1058143 (12/3/2009)
No matter what I do, and no matter how many other processes I kill off I still always get the same message telling me that only...
December 3, 2009 at 8:45 am
I'm with Lynn here, spend $50 on the Developer's edition of SQL Server. If you're trying to invest in your future... $50, please.
December 3, 2009 at 8:36 am
And what happens when database A or B become terribly problematic due to size, contention, number of users, what have, and you need to move them to another server? Linked...
December 3, 2009 at 8:33 am
If restarting the service doesn't clear the trace, then you've got something running within SQLAgent or as a startup script that refires it. If SQL Server is shut down, so...
December 3, 2009 at 8:20 am
Viewing 15 posts - 16,111 through 16,125 (of 22,211 total)