Viewing 15 posts - 14,326 through 14,340 (of 22,219 total)
Do you mean you want to know what database was most recently queried from (or to)?
In that case, you could do something like this:
SELECT TOP 10
...
"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
September 21, 2010 at 12:20 pm
If you supply a value through OPTIMIZE FOR, it's going to use that value. It won't help it arrive at a better plan, just the one that it can arrive...
"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
September 21, 2010 at 12:08 pm
You can use DMV's, or server side traces and Gail's articles are a great place to start. If you're running 2008 you can also look at using the Data Collection...
"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
September 21, 2010 at 11:29 am
You can backup out to a UNC path, but, it's usually not a good idea because then you're dependent on the network to handle the backup and that can sometimes...
"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
September 21, 2010 at 11:26 am
The LIKE statement with a % in the front of the string will result in table or index scans, no options. That is likely why things are running slowly.
"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
September 21, 2010 at 11:23 am
I'll take the field. Probably a sucker bet, but...
"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
September 21, 2010 at 11:17 am
I'm not aware of anyone specifically consulting on this issue, but there is a book available that might help you narrow down your options if you're feeling overwhelmed.
"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
September 21, 2010 at 11:07 am
I agree with Jack.
But to talk about option 2 for a minute (becuase there will be times you have to go that way), simply adding the nullable column will not...
"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
September 21, 2010 at 8:24 am
I guess I don't understand, but that looks like what Craig posted. Could you try to explain it again?
"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
September 21, 2010 at 8:13 am
If you're doing lots of design work, yeah, having a good ERD tool like ERStudio is an excellent force multiplier. You can really get a lot more work done 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
September 21, 2010 at 7:55 am
You need to generate the script. You can use SQL Server Management Studio (SSMS) to generate the script. It's the easiest way. If that doesn't do what you need, 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
September 21, 2010 at 7:22 am
Greg Edwards-268690 (9/21/2010)
jcrawf02 (9/21/2010)
Finally! The perfect database tool! :w00t:http://spreadsheets.about.com/od/datamanagementinexcel/ss/080608_database.htm
Excel can do anyhing, even word processing! 😛
It's kind of like I can record a macro, so I can repeat anything.
Greg...
"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
September 21, 2010 at 7:16 am
Glad to hear these things are appreciated. The people who put them on and the speakers put a lot work into them.
Did you meet people too?
"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
September 21, 2010 at 7:10 am
Ninja's_RGR'us (9/20/2010)
TheSQLGuru (9/20/2010)
"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
September 20, 2010 at 1:11 pm
Bhuvnesh (9/20/2010)
lallu_jaya (9/20/2010)
Do you suggest Covered index on all the following columns?Do we have covering index in sql 2000 ? :unsure:
Yes, by adding all the columns in the key definition...
"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
September 20, 2010 at 9:33 am
Viewing 15 posts - 14,326 through 14,340 (of 22,219 total)