Viewing 15 posts - 6,976 through 6,990 (of 22,219 total)
sqlmunkee (1/8/2015)
ALZDBA (1/8/2015)
...That's the reason I don't use "set single user", but put it offline, right before the restore.
+1 - I always SET OFFLINE, never SINGLE_USER, as you can't be...
"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
January 8, 2015 at 4:25 am
It's basically a message telling you that you're running SQL Server on a grossly underpowered machine. 2gb is just the bare minimum to get the server started. You need more...
"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
January 8, 2015 at 4:23 am
"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
January 8, 2015 at 4:19 am
OK. Not a problem. The link I provided should do what you need then.
"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
January 8, 2015 at 4:04 am
Welsh Corgi (1/7/2015)
Should I use the 2008 upgrade advisor or what?
I don't understand what you're trying to do.
Your first post said:
SQL Server 2014 Upgrade Advisor to be run on 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
January 7, 2015 at 6:57 pm
Alexander Suprun (1/7/2015)
Grant Fritchey (1/7/2015)
"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
January 7, 2015 at 6:52 pm
Alexander Suprun (1/7/2015)
Grant Fritchey (1/7/2015)
syquil (1/7/2015)
Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit?...
"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
January 7, 2015 at 6:49 pm
syquil (1/7/2015)
Can you expand on any 'gotchas' or 'no-nos' with the edit window for my own benefit? I typically only...
"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
January 7, 2015 at 4:39 pm
Hello and welcome to the forums.
I absolutely agree with #5. It's actually good advice.
Unfortunately, the rest, in fact, I'd say they got basically 180 degrees out of alignment.
You should...
"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
January 7, 2015 at 4:20 pm
It's kind of a weird question. I mean I've built complex queries, but I don't remember that many of them now. Plus, most of the ones I wrote, I probably...
"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
January 7, 2015 at 4:00 pm
Maybe it's a typo, but why would you run the SQL Server 2014 Upgrade Advisor against a SQL Server 2014 instance? Isn't it already on 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
January 7, 2015 at 3:49 pm
ROWVERSION is unsupported. There's a good listing of the supported and unsupported data types here in the Books Online.
Be very cautious about when and how you're going to apply...
"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
January 7, 2015 at 3:48 pm
That's certainly a potential solution to the problem.
Let me provide the link as a URL link.[/url]
Just so you know, if you post a link, use the little globe button above...
"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
January 7, 2015 at 3:35 pm
Definitely blocking. But no other information there. I don't think anyone is going to have anything to add beyond the suggestions we've made.
"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
January 7, 2015 at 12:53 pm
Not a problem. Happy to help. Let me know how it works out. I'm curious.
"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
January 7, 2015 at 11:59 am
Viewing 15 posts - 6,976 through 6,990 (of 22,219 total)