are you saying the restore from a backup took 3 hours to run?  that's seems very long.  how many gb is thd database? 

why don't you just take a backup of the entire db in the normal way?  then you can play around all you like, and if you mess it up, just restore...

It's certainly possible.  They will of course compete for resources (cpu, memory, and disk) when both are under load.

I wouldn't recommend it for a production server. 

according to probability of the customer to purchase that product, ideally.

about views with ORDER BY clauses in them: don't do it.  it's a bug if the query designer is adding that.  The order by belongs in the query that targets...

sounds like a homework problem to me. 

why not code up this little program and see for yourself?

also, the property you are thinking of is byte.MaxValue, not maxvalue.  C# keywords...

From BOL, on the topic of creating a login from a certificate http://msdn2.microsoft.com/en-us/library/ms189751.aspx:

        "This certificate must already exist in the master database."

so, you need to create your cert in...

that's a little weird to store an street number in a float. 

are streets fractional where you live?  if so to how many digits of precision?

that's weird.  does it persist even after a reboot?

if so I guess you'll just have to do everything in unicode. 

btw, your view has a bug in it, but it's a very common one.

you should not have ORDER BY clauses in a view, nor should you have the TOP 100...

why not just use bcp?  to me it's much nicer than either ssis or dts for moving large amounts of data around.  but then i dislike the GUI...

1) you can rename a table with sp_rename: http://msdn2.microsoft.com/en-us/library/ms188351.aspx

2) one way to do this would be to script out all the procs/views/functions and do a search/replace.  I wrote a...

and here's how Job Activity Monitor figures it out:

exec

msdb.dbo.sp_help_job

with those numerous links in your sig, I have a feeling that your posts are some sort of SEO strategy rather than a request for real information. 

plumbinf.com?  roofinh.com?   you seem...

Madhi shows how to go straight to excel in this marathon sqlteam post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926