Viewing 15 posts - 7,846 through 7,860 (of 22,219 total)
Yeah, if that equals NULL was in the WHERE clause I'd be laughing my bottom off.
"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 1, 2014 at 5:00 am
Also, if you're backing up to a remote drive across the network, check the network connectivity. That can seriously impact backup performance.
Check the wait statistics while the backup is running...
"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 1, 2014 at 4:58 am
I wouldn't worry about the indexes on 2014 more than I would on 2008. Whatever index rebuild you normally use should be fine. Traditionally many people will update their statistics...
"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 1, 2014 at 4:54 am
You should plan on testing that they work in every case. Some will, but others will require upgrades to the client components. There are new versions for SQL Server 2014.
"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 1, 2014 at 4:52 am
Nice write up.
And you didn't say hello? Please do next time.
"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 1, 2014 at 4:47 am
New Born DBA (6/30/2014)
"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 1, 2014 at 4:38 am
That's caused by a long running checkpoint operation, where the data gets written to disk from memory. It's not an indication of a memory leak. It's an indication of large,...
"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 30, 2014 at 1:42 pm
Tuning is a cyclical process that you just keep doing and doing. Basically you monitor a server, gather metrics on what's performing well, what isn't, what normal looks like, 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
June 30, 2014 at 1:36 pm
I don't know that I'd use ODBC. I'd rather go for as direct a connection as possible. You should be able to make a direct connection if it's Microsoft Azure...
"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 30, 2014 at 9:32 am
I have to say, this really sounds like interview questions. I'm only answering interview questions if I get the job.
"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 30, 2014 at 9:19 am
Perry Whittle (6/30/2014)
Grant Fritchey (6/30/2014)
As long as you have unique file names on a given server,
It's not the server dictating this. You can have 100 databases all with the primary...
"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 30, 2014 at 9:13 am
Not sure then in that case. I've seen poor performance in some machines after waking, but not a specific query issue with SQL Server.
"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 30, 2014 at 8:40 am
george sibbald (6/30/2014)
"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 30, 2014 at 8:11 am
Chowdary's (6/30/2014)
Actually am checking the server which is having only 2012.There am getting the issue.
Pls help me out if there is any...
"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 30, 2014 at 8:09 am
Is the machine you're querying from and the data location and the machine going to sleep, all the same machine? If so, I suspect you're probably seeing some memory artifact...
"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 30, 2014 at 6:32 am
Viewing 15 posts - 7,846 through 7,860 (of 22,219 total)