Grant Fritchey

Forum Replies Created

Viewing 15 posts - 4,876 through 4,890 (of 22,219 total)

RE: Seeking advice on upgrade - SQL 2014 vs SQL 2016

Upgrading to 2014 or 2016 is basically an identical amount of labor. With that in mind, I'd go for 2016. Yeah, it's newer, it might be a little rocky 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

April 5, 2016 at 12:57 pm

#1869969
RE: Zip compressed backup

Also, fair warning, if you encrypt a file, it won't compress well. Good backup software compresses, then encrypts.
"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

April 5, 2016 at 11:47 am

#1869939
RE: Are the posted questions getting worse?

SQLRNNR (4/5/2016)
Grant Fritchey (4/5/2016)
Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete works sometimes"
... Surely, please,...
"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

April 5, 2016 at 11:10 am

#1869913
RE: Why Identity value gets jumps to lower value ?

Sachin Nandanwar (4/5/2016)
Kishore M. K. (4/5/2016)
Is this Stop-Start of SQL Service is causing IDENTITY value to jump to lower random value ?
This has been a known issue on atleast 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

April 5, 2016 at 10:19 am

#1869887
RE: please fine tune this query

Seems the OP removed the query. Shame. I'd love to see the execution plan. The query, all by itself, didn't seem to have any obvious issues. I'd be curious what...
"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

April 5, 2016 at 10:17 am

#1869886
RE: Are the posted questions getting worse?

Phil Parkin (4/5/2016)
Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.
Oh god...
"The delete works sometimes"
... Surely, please, tell me this...
"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

April 5, 2016 at 10:13 am

#1869885
RE: finding store proces that need to be recompiled

That sounds like an issue with statistics or possibly a bad parameter sniffing issue (or both in combination). Recompiling the procedure causes it to create a new plan based on...
"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

April 4, 2016 at 5:25 pm

#1869678
RE: Does this issue go away past SQL Server 2008 R2?

Oh, we're going off memory here. I did run into this issue on 2008r2, but only with a single app. We tracked down which app was having the failure 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

April 4, 2016 at 3:03 pm

#1869651
RE: Does this issue go away past SQL Server 2008 R2?

I've only seen that error come up in the event of timeouts, or, when we had an app that was using an older version of OLEDB to connect to 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

April 4, 2016 at 1:36 pm

#1869617
RE: mysterious slowdown every 4 minutes

Possibly, but SQL Server isn't going to flush the log in a clockwork, every four minutes, fashion. So I can see how external I/O issues can lead to the log...
"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

April 4, 2016 at 11:14 am

#1869598
RE: On-Priemise to SQL Azure migration - How to migrate domain users

You have to create an Azure Active Directory service in your Azure account and then federate that with your local Active Directory. AD in Azure SQL DB is in preview...
"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

April 4, 2016 at 8:03 am

#1869516
RE: Restore Database Failed: 'Exclusive access could not be obtained because the database is in use.'

jacksonandrew321 (4/4/2016)
you must set the database to single user mode before attempting to restore see here: http://www.sqlserverlogexplorer.com/exclusive-access-not-obtained-database-use/%5B/url%5D
This is a two year old thread.
You don't have to set the database to...
"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

April 4, 2016 at 6:52 am

#1869492
RE: How to print out a SQL statement in SP...?

Do you mean, capture the information? In SQL Server 2008 you can use trace events. In 2012 or greater you use extended events.
"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

April 4, 2016 at 3:48 am

#1869432
RE: How do I Avoid Deadlocks?

I agree with the other answers, so this is just piling on.
Fundamentally, deadlocks are a performance issue. Yeah, if the code is written in such a way that locks occur...
"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

April 1, 2016 at 8:39 am

#1869176
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (3/31/2016)
Bucket list item. Made it on stage at major MS conference.
HUZZAH!
Well done.
"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

April 1, 2016 at 8:17 am

#1869164

Viewing 15 posts - 4,876 through 4,890 (of 22,219 total)