Viewing 15 posts - 28,156 through 28,170 (of 39,769 total)
First of all you shouldn't shrink databases. It moves things around and causes fragmentation and can slow down index response and increase query times. Shrinking should only be done if...
June 18, 2008 at 8:19 am
You are there to make things better, drive the use and efficiency of SQL Server forward. Training someone to bring up the rear so when you're gone things still move...
June 18, 2008 at 8:04 am
tables, views, etc are NOT files. They are objects within a database file. You can have multiple database files per database, but those do not determine the tables, etc.
You script...
June 17, 2008 at 3:28 pm
Like cut/paste, drag/drop?
Not yet. Thought you could file this as a "wanted enhancement" on Connect (connect.microsoft.com).
sqlSentry might help here. I know they can move jobs from one to another. Not...
June 17, 2008 at 3:27 pm
I don't use devices ever.
I want separate files for every backup. If you have 2 or more backups on a single device or file and something happens, you could lose...
June 17, 2008 at 3:25 pm
I'd go with the above advice. You could even schedule this to run only on selective tables, meaning only do tables that start with a-f on one day, g-m on...
June 17, 2008 at 3:24 pm
If that doesn't work, do the shutdown. You can rename one file and the db will be suspect and then you can deal with things.
June 17, 2008 at 3:18 pm
We've debated eliminating the prizes, but the way we've given them away, if we try to determine who's eligible and who's not it becomes an administrative issue. One that we...
June 17, 2008 at 3:14 pm
You really need three scripts since they have to be run in different places.
The source does the backup or detach and needs to run on the source server.
The copy...
June 17, 2008 at 3:12 pm
I'd do this, checking the script for things like security account.
You can right click in SSMS and script jobs.
June 17, 2008 at 3:10 pm
Is it up to 500 and the next row would through it over?
Does this have to happen regularly, like with every import?
This sounds like something I might tackle in an...
June 17, 2008 at 3:07 pm
It appears the site is just a place where they link to Google Ads and Amazon for purchase, so you're welcome to go there. I don't see any value in...
June 17, 2008 at 9:21 am
Great comments and glad you all liked the article. I think Dave Ramsey is good as well, and we've used the snowball method for consumer debt and it worked well.
6%...
June 17, 2008 at 9:16 am
An SSC member starts putting together a Question of the Day, and, halfway through, realises he could phrase it better.....
Hey, I resemble that remark.
On the hardware thing. If loads are...
June 17, 2008 at 9:08 am
There's always more work. Remember that when you think you have to finish something up to clear the decks.
June 17, 2008 at 9:05 am
Viewing 15 posts - 28,156 through 28,170 (of 39,769 total)