Can you put the row_number() on the results of the union? SELECT t.name, ROW_NUMBER() OVER (ORDER BY t.name)FROM ( SELECT name FROM a UNION...
If you're using a maintenance plan for the log backups, there's an option for how many days worth to keep, after which SQL Server will automatically...
An indexed view is self-updating, immediately reflecting changes to the underlying tables. If you don't need that real-time updating -- and it sounds...
I do occasionally shrink the database files when they've gotten excessive for some reason (like we moved a bunch of data) and there's no longer room...
Drat. Well, thank you all for your help!
I think my question has become this: After making a full backup, is there a way to tell the transaction log that all the entries in it have been...
Oh! Well. How irritating for my purposes. We thought we were being ever so clever to funnel all those changes into a full backup instead of a big...
I'm using the maintenance plan's "Reorganize data and index pages" option on the Optimizations tab with the "Reorganize pages with the original...
That's what I'm doing -- running a full backup right after the index rebuild so that the next transaction log backup won't be abnormally large.
My production server is behaving in a very strange way which I cannot replicate on my development server, and I'm wondering if anyone else has ever...
SELECT name, xtype FROM sysobjects WHERE uid = USER_ID('the login name') xtype gives you an abbreviation of the object's type. You'd need to do this...
Separate names with a comma.
