Viewing 15 posts - 12,136 through 12,150 (of 22,233 total)
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
"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
August 8, 2011 at 2:28 pm
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
"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
August 8, 2011 at 12:19 pm
I've been failing at Google-Fu today. I'm trying to track down the name of that pet store (or at least a good copy of the story about it, name or...
"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
August 8, 2011 at 12:11 pm
SQLRNNR (8/8/2011)
Grant Fritchey (8/8/2011)
SQLRNNR (8/8/2011)
GilaMonster (8/8/2011)
Ask Grant about GoDaddy, and take a couple steps back.
Grant didn't like it at all, but I also believe his configuration was a bit different...
"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
August 8, 2011 at 12:06 pm
SQLRNNR (8/8/2011)
GilaMonster (8/8/2011)
Ask Grant about GoDaddy, and take a couple steps back.
Grant didn't like it at all, but I also believe his configuration was a bit different than what they...
"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
August 8, 2011 at 11:47 am
GilaMonster (8/8/2011)
Ask Grant about GoDaddy, and take a couple steps back.
He should take a couple of steps back, then ask about GoDaddy.
Short answer, no, I don't think much of them....
"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
August 8, 2011 at 11:44 am
I don't have a good tutorial for you on doing this upgrade for replication. By & large, upgrades are better and safer when they're done as a side-by-side upgrade, meaning...
"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
August 8, 2011 at 11:00 am
Also, depending on how the jobs are configured, you might have a single job doing things for multiple databases. Just to be aware in case whatever search mechanism you put...
"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
August 8, 2011 at 7:42 am
right there with you too, bu what generated the error? Go there first. I don't know, there's got to be more to this question than first appears.
"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
August 8, 2011 at 6:35 am
Have to add this: Why is my log full.[/url]
"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
August 8, 2011 at 6:29 am
Just so you know, SQL Compare from Red Gate Software[/url], can even compare a live database to a backup file. You don't even have to restore the database to make...
"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
August 8, 2011 at 6:16 am
I'm sure I'm missing something, but it looks like you're trying to use @@IDENTITY with a uniqueidentifier data type. They're not the same and that would explain the fundamental issue....
"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
August 8, 2011 at 6:13 am
Maybe I'm a little slow, but remove the old server from your backup process. Unless there's something here you're not stating, that seems to be the answer.
"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
August 8, 2011 at 6:10 am
SQL Dev-938873 (8/7/2011)
Thanks for ur replies..Can plz suggest... which is better from SQL Server or From Front End (.Net)????
A couple of us have said it. The front end.
"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
August 8, 2011 at 5:53 am
GilaMonster (8/6/2011)
Grant Fritchey (8/6/2011)
In SQL Server 2008 and greater, you could use DATETIME2 data type which can also manage time zones.DateTimeOffset, not DateTime2.
Doesn't handle daylight saving though.
Oh crud. Of...
"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
August 6, 2011 at 5:02 am
Viewing 15 posts - 12,136 through 12,150 (of 22,233 total)