I agree! 😀

The backup file isn't changed. What happens when you do the restore is that the mdf/ldf/ndf are created as sparse files. All reads from these files are redirected to the...

I've turned the kids onto chorizo here, and that's supplanted bacon most of the time.

I found this one, but only in L. I need a XXL.

http://compare.ebay.com/like/220414998857?ltyp=AllFixedPriceItemTypes&rvr_id=122730417474&crlp=1_263602_263632&UA=%3F*F%3F&GUID=60410c241280a02652f10851ffc94969&itemid=220414998857&ff4=263602_263632

Apologies to anyone that feels I crossed the line into too much advertising. I was asked to write something on this product, and I think I failed to editorialize on...

The same functionality, AFAIK, continues in SQL 2008. If you have those fields and insert too much data, it gets truncated.

We understand your situation. I think most of us have...

You need to write some code.

Query sys.server_principals for users, write a loop or cursor with the results, build an ALTER LOGIN script from there.

http://msdn.microsoft.com/en-us/library/ms188786%28v=SQL.100%29.aspx

I'm not sure what you mean. 10 varchar(2000) in one table still wouldn't have more than 8k in the row since that's a 2000 limitation. You can convert to varchar(max)...

If this is a one time thing, or rare thing, you could use the data import wizard in SQL Server to do it. Otherwise, I agree with Paul's advice. Openquery...

One more thing on the iPad/iPhone. There are quite a few libraries doing electronic lending of materials. Mine uses the Overdrive Media Console, which registers to my account. I can...

Yes, sorted in that order. The data is stored like that on pages.

Note that page splits happen all the time, updates cause them when the new values don't fit on...

Brandie Tarvin (8/10/2010)

jcrawf02 (8/9/2010)

I think one of those has...

Buffering isn't something I've typically worried about. Are you selecting millions of records? If not, I wouldn't be concerned here. The default isolation works fine.

Replication was a little shaky in...

The insert will occur inside the clustered index, and if there is not enough space, a page split will occur.

This would be cumbersome in T-SQL. You'd be better off running SQL Trace and capturing all changes that way, replaying them against another copy of the database.