Viewing 15 posts - 16,891 through 16,905 (of 22,219 total)
Andy Warren (7/24/2009)
I use the 15" bag and it's worked out fine as well. Good write up!
What size laptop did you get into it? I've got my 17" laptop in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 6:57 am
Oh, right. I keep forgetting the MS finally got smart. I'm so used to having to pull that access...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 6:12 am
Because even if you change the recovery model for master, it's still going to behave as if it's in simple mode, by design.
Why are you trying to get log backups...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 6:11 am
That more or less describes it, yes. You also know that execution plans can age out of cache and then need to be compiled again, right? Or that certain actions...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 6:07 am
It's pretty straight forward. They're both clustered indexes, with all that entails. One has a constraint that only allows unique values into the column or columns that make up it's...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 6:01 am
Yeah, that's from SQL Prompt. The Snippets function will do a bunch of work for you. Type cci and hit return.
It fills out all the code needed for making a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 5:54 am
If you're returning rows of data, just use a result set. But if you're returning a single row with only a few columns, output parameters are faster. It requires less...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 5:36 am
Unless you've changed the default security on the machine (a good idea to do), you should be able to access the instance by being added to the local admin group...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 5:31 am
In terms of security, you shouldn't have any concerns, assuming you properly wall off the IIS server. Performance could be a serious issue, depending on how much memory and processor...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 5:30 am
You could also set the database to restricted user and use rollback immediate, assuming the connection that keeps getting in is not an admin connection.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 5:26 am
Jamie Batiste (7/24/2009)
I have to ask how often the Sonic Screwdriver has been used?
With great power comes great responsibility. I only use it when I have to. 😀
It really has...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 4:05 am
I'm ashamed to say I'm only reading about 15-20 books a year, a mix of novels, history & technical. It was so much more before the kids got older and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 4:00 am
Excellent feedback. Thanks everyone.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 24, 2009 at 3:47 am
David Webb (7/23/2009)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 5:18 pm
Bruce W Cassidy (7/23/2009)
Lynn Pettis (7/23/2009)
Philip K Dick may have been mental. Any one read Valis? It was a bit strange.
[font="Verdana"]It's beaten out in weirdness by "Stars In...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 23, 2009 at 5:16 pm
Viewing 15 posts - 16,891 through 16,905 (of 22,219 total)