Viewing 15 posts - 6,976 through 6,990 (of 22,226 total)
Extended Events will only work in 2008 or greater.
I haven't tried connecting to 2005 from 2014 Profiler, so I'm not sure what the issue might be.
Instead of using the Profiler...
"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 9:04 pm
Should work fine.
Also, there's this from Microsoft.
"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 12:52 pm
I also recognize that some guy responding to your question on the internet is not going to be exactly compelling evidence on your side. So, I did a quick search...
"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 11:20 am
Service Oriented Architectures are great. No question.
But this idea that a persons name has to be broken into multiple tables because part of it might be updated independently from 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
January 8, 2015 at 11:02 am
Unfortunately, the devil is in the details on the tech. There's not a single winning piece of tech on the Microsoft side. I think the only winning piece of tech...
"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 10:52 am
And I'm with Perry. I'd use .bak for all sorts of backup files, but differentiate them in the name.
"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 6:27 am
Nah. You can call your backup files .doc if you want to. They'll still work fine.
Don't do that though.
"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 6:26 am
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
Viewing 15 posts - 6,976 through 6,990 (of 22,226 total)