Viewing 15 posts - 16,891 through 16,905 (of 22,226 total)
For 2005/2008, take a look at sys.dm_exec_syessions. It will give you a basic breakdown of information for the connections in the system, including start times on the last batch. For...
"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 27, 2009 at 6:54 am
Performance Monitor is traditionally the place to get this kind of information. You can look at the counter Database:Transactions/Sec:DBName to get the transactions/sec for any given database or use the...
"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 27, 2009 at 6:47 am
jcrawf02 (7/24/2009)
Jeffrey Williams (7/24/2009)
I wonder what it says about me that I actually enjoy reading all of these books that are supposedly targeted at teens? :hehe:
That you have better...
"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 11:00 am
Jack Corbett (7/24/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 24, 2009 at 10:29 am
ankur_libra (7/24/2009)
Does it mean Clustered index created on Primary Key is same as Unique Clustered Index?
Also it is said: PRIMARY KEY constraints create...
"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 8:50 am
Scott (7/24/2009)
Looks great, but I must admit I find it hard to take the name seriously. What next - Ultimate Fighter tote bag?
The day pack my wife carries from them...
"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 8:41 am
One of many attributes that combine to make me "scary."
"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 7:09 am
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
Viewing 15 posts - 16,891 through 16,905 (of 22,226 total)