Viewing 15 posts - 5,926 through 5,940 (of 22,219 total)
SQLBill (6/25/2015)
GilaMonster (6/25/2015)
I found a photo of my Siamese.*sniff*
Okay, so how many looked at the cat and then looked at the books and thought "I have that one, don't 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
June 25, 2015 at 8:56 am
aido-1116077 (6/25/2015)
This was one option I was considering running after a daily insert into the DW tables
BACKUP LOG [databaseName]
TO DISK = 'nul:' WITH STATS =...
"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
June 25, 2015 at 8:50 am
I would only suggest splitting up the databases if you have separate functionality that you're supporting. If the 40 web sites all have the same functionality, then breaking up your...
"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
June 25, 2015 at 8:48 am
An index rebuild also updates statistics. So no, I wouldn't rebuild those stats right after that. Also, an index rebuild will update the statistics with a full scan, not 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
June 25, 2015 at 4:56 am
There's not enough information to do more than make a few guesses.
The first thing you need to do is capture the query metrics for the queries that are called when...
"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
June 25, 2015 at 4:54 am
Get the Querying book. It's just outstanding.
"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
June 25, 2015 at 4:50 am
Thank you very much for the kind words. Good luck with your indexes.
"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
June 24, 2015 at 8:11 pm
Here's an example[/url] of a PowerShell script that will script out the indexes. It's written to only pull the indexes from a single table. You can pretty easily modify 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
June 24, 2015 at 11:39 am
You could just use SSIS. It can connect to Azure SQL Database and you can move the data that way.
"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
June 24, 2015 at 4:14 am
Remember, timeouts are a client-side issue. The problem, most of the time, is likely related to resource contention within SQL Server. But it isn't limited to that. I've seen network...
"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
June 24, 2015 at 4:10 am
Uuummmm, did you go and break the thing? Sure looks like the line snapped.
"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
June 23, 2015 at 10:35 am
rodjkidd (6/23/2015)
Grant Fritchey (6/23/2015)
Wow, you guys were seriously chatty kathy while I was gone.Welcome back oh mighty one!
Did you have fun, by any chance? hehe
Rodders...
Nope. No fun at all. Especially...
"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
June 23, 2015 at 7:57 am
Wow, you guys were seriously chatty kathy while I was gone.
"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
June 23, 2015 at 7:07 am
Matt Miller (#4) (6/19/2015)
Grant Fritchey (5/20/2015)
ForumsFora. Language Nazis need not apply. Your meaning was clear.sorry - just could not help myself 😉
Curse 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
June 23, 2015 at 6:52 am
+1 to what Jeff said. It's always great to get the information of what really happened and what the issue was. Thank 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
June 13, 2015 at 10:05 am
Viewing 15 posts - 5,926 through 5,940 (of 22,219 total)