Viewing 15 posts - 41,266 through 41,280 (of 49,552 total)
idrees.butt (2/2/2009)
am I supposed to read the whole book or just the relavant chapters? which are relavant chapters?
Since you're new to this, read them all. The books are...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 10:35 am
Marios Philippopoulos (2/2/2009)
Wow, would the trigger feed on itself that way? I hadn't thought of that...
That's only possible if recursive triggers are enabled. It's a database-level option and it's disabled...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 10:23 am
myst.black (2/2/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 8:02 am
I'd also recommend T-SQL Fundamentals by Itzik Ben-Gan. I've only glanced through it, but it looks good.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 7:59 am
2 Tim 3:16 (2/2/2009)
"If the page has not yet been updated on the source database, a read operation on the snapshot reads the original page from the source database".
Yup. That's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 7:53 am
2 Tim 3:16 (2/2/2009)
I'd like to just add that only changed pages get read from the Snapshot. Non-Changed pages still get read from the original database.
Unless I'm badly misreading,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 7:12 am
Chris Morris (2/2/2009)
Gail - nice weapon! Horrible haircut:P
I'll change the avatar back in a few days. That's the second comment about the haircut.
Funny thing is, it's not far different from...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 7:09 am
Arun (2/2/2009)
For this when we configure log shipping, it contradicts with the backup plan in the production server. Thats the problem. 🙁
Why? There shouldn't be any problem. Take full backups...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 6:30 am
From a quick glance, this doesn't need a cursor at all.
One question - if all 5 of the carrier names are blank, do you want 5 records in the table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 6:27 am
Marios Philippopoulos (2/2/2009)
Not that I don't believe you, but can you post a link that mentions...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 2, 2009 at 6:17 am
Arun (2/1/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:50 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic647819-361-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:49 pm
Varchar(8000) stores a maximum of 8000 characters. Varchar(max) stores a maximum of 2 147 483 647 characters.
See Books Online, the page titled "char and varchar" for more info.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:41 pm
What DB are you restoring?
Can you post the code that you're using to do the restore?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:39 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic647812-146-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 1, 2009 at 11:38 pm
Viewing 15 posts - 41,266 through 41,280 (of 49,552 total)