Viewing 15 posts - 13,036 through 13,050 (of 22,219 total)
You're confusing two sets of functionality. The variables in Visual Studio are just part of the build and deployment, not a part of coding. All they really are is SQLCMD...
"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
March 15, 2011 at 6:37 am
EasyBoy (3/14/2011)
Grant Fritchey (3/14/2011)
"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
March 15, 2011 at 5:38 am
Jeff Moden (3/14/2011)
"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
March 15, 2011 at 5:36 am
I tried to open those files, but couldn't get either to open.
It sounds like, based on the description, parameter sniffing. For identical parameters values, are the plans different? I...
"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
March 14, 2011 at 3:21 pm
You don't have to drop the database. You just have to move the files and overwrite the existing database.
But I am confused by your initial question. You said that you...
"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
March 14, 2011 at 11:39 am
Lowell (3/14/2011)
"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
March 14, 2011 at 11:34 am
Have you checked out this book on PBM?
"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
March 14, 2011 at 9:45 am
Using the DMVs in that manner is fine. You just need to know, and be aware, that they only reflect what is in cache when you run them. If stuff...
"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
March 14, 2011 at 7:19 am
Pay no attention to the Luddite. 😀
I've been using Tweetdeck for a quite a while on both my PC and my Droid. I tried it on the iPad, but it...
"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
March 14, 2011 at 6:49 am
It looks like you've got the basics well covered. One thing I would add for sure is the ability to capture wait states on the servers. You're going to want...
"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
March 14, 2011 at 6:45 am
Lynn already answered. It depends on the data involved and the fill factor on your indexes. simply a count of rows and columns doesn't tell us anything. You can have...
"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
March 14, 2011 at 6:40 am
You might want to take a look at the book "Beginning SQL Server 2008 Administration." I wrote the chapters on backup, restore, and performance tuning. It covers everything in SQL...
"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
March 14, 2011 at 6:37 am
If the most frequently used columns to retrieve the data is all three that you listed, that might make a better choice for the clustered index. Testing is the key...
"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
March 14, 2011 at 6:31 am
If the goal is to identify which servers or databases have a failed backup, instead of running reports, I'd suggest taking a look at setting up Policy Based Management. You...
"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
March 14, 2011 at 5:35 am
musa 84273 (3/14/2011)
"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
March 14, 2011 at 5:32 am
Viewing 15 posts - 13,036 through 13,050 (of 22,219 total)