I have never had an issue with the in-place upgrade..just make sure you take a full back up of all your DBs, script out logins, jobs, linked servers, save SSIS/DTS...

Realistically, if you're moving everything to a new physical server anyway, it would seem like the same amount of work to consolidate databases onto 2-3 instances...actually, probably less. Remember, the...

I assume this is a homework question, since you clearly wouldn't be working on this alone if it were a real project.

You need a lot more information than you've given...

I was going a different way to make it constantly updating with a Trigger, so he wouldn't have to constantly run it after every update..

--DROP TABLE TEST

GO

CREATE TABLE test (

id...

So you already have the names in the table and an empty 3rd column, which you wish you populate with the full name plus an incremented number if the name...

There is no way to ever really prevent the cache from being bulldozed when you do a large operation like a reindex/huge report/etc, so you basically just have to live...

Also just a quick note....5 hours for a 28gb database means something is severely wrong.

I have a 700gb database that I routinely restore in < 2 hours, for comparison. Obviously...

Did you check if you have debugging enabled? And do you need it to be, if so?

Disable debugging on the query (alt+f5...you might have mistakenly hit alt while you were executing with f5 and turned debugging on. Check the debug menu to see if it is).

Your...

You would need to do something like

declare @dbname nvarchar(255)

declare @sql nvarchar(500)

select @dbname = 'msdb' --Set up your cursor here to insert into this variable

select @sql =...

You're probably better off doing something like this:

http://www.sqlservercentral.com/redirect/articles/70939/

I have a few groupings of servers that I run queries against, and it supports any kind of code (create/drop/alter/etc)

You need to change authentication to Mixed Mode, which lets you create SQL logins.

Then, you need to create a new SQL login for the app to use, and give it...

Jeff Moden (8/20/2010)

---

Comment withdrawn. I couldn't find the MS reference that I remember seeing to support what I said so I've withdrawn my comment. If I find the...

Here's a similar one I've used for a few years. Note that I have not updated this code since I was just figuring SQL out, so it can definitely be...

You could do xp_cmdshell('dir c:\whatever') and then filter it based on that...that's the only way I know of. I'm sure it would be stupidly simple with powershell, but unfortunately I...