Viewing 15 posts - 34,921 through 34,935 (of 49,552 total)
shannonjk (1/6/2010)
That is strange I am only returning some 6k+ characters and I still get a truncated (though very close to the end now) sql statement.
That's possibly a management...
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
January 7, 2010 at 1:17 am
Ratheesh.K.Nair (1/6/2010)
How can we make a database in standby mode if we are specifying the WITH NORECOVERY option?
You can't. If you want the database in Standby, you use WITH STANDBY...
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
January 7, 2010 at 1:17 am
Why did you edit and remove all the useful information. I was going to set aside an hour or so tomorrow to look at this. Do you want another opinion...
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
January 7, 2010 at 1:15 am
Can't be done. In the create table statement, the default must be attached to the column. The only constraints allowed to go at the end, after the columns are Primary...
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
January 6, 2010 at 12:53 pm
Restore it with Standby. Otherwise you'd have to drop the database and start from scratch after each log 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
January 6, 2010 at 12:50 pm
Create Table User (
...
ActiveFromDate DateTime Not Null Constraint [DF_CMS_User_ActiveFromDate] Default (GetDate()),
... other columns here ...
)
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
January 6, 2010 at 12:48 pm
I know what you mean, I though Lynn was female for a very long time. (just based on the name, Lynn, please don't read anything into that)
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
January 6, 2010 at 12:09 pm
Firstly, Nolock is not in the same category as UPDLOCK or XLOCK. UPDLOCK and XLOCK are locking mode hints and you can think of these hints as specifying the minimum...
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
January 6, 2010 at 12:06 pm
If you're going to shrink after rebuilding, you may as well save the time and not bother rebuilding in the first place.
Shrinking causes massive fragmentation and will just result...
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
January 6, 2010 at 11:52 am
That's fairly normal. SQL needs space to put those new indexes.
I'd suggest you look at getting some more disk space.
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
January 6, 2010 at 11:21 am
Are you sure the diff you're trying to restore belongs to that database? The error indicates that it doesn't
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
January 6, 2010 at 11:17 am
John Rowan (1/6/2010)
but I've always had the understanding that the optimizer could still escalate the lock and ignore the hint if needed.
Escalate as in shared to exclusive or escalate...
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
January 6, 2010 at 11:09 am
support 79032 (1/6/2010)
Nowever only a complete xenophobe (named after Queen Xeno a notorious bigot) could wish to...
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
January 6, 2010 at 11:02 am
jen-1118637 (1/6/2010)
We're lucky to be at the stage where we're working on subtle, unconscious assumptions, as opposed to legislated and socially accepted ostracism.
Depends where you are in the world.
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
January 6, 2010 at 9:43 am
Andrew Gothard-467944 (1/6/2010)
GilaMonster (1/6/2010)
Manic Star (1/6/2010)
Except for some locker room behavior at a few clients, I've not noticed any serious discrimination in my 20 years in the business.
Same here....
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
January 6, 2010 at 9:00 am
Viewing 15 posts - 34,921 through 34,935 (of 49,552 total)