I originally tried the Begin End for both sides of the If Else, as it is my understanding that if you do not use them SQL will only execute one...

Simplest way to do it.

I have to put together scripts to change data types or expand columns, depending on the business requirement. As part of the data type change, from...

GilaMonster (8/18/2011)

Stamey (8/18/2011)

As I said, I have encountered people who think that the batching will have an effect on things like the transaction log, in that putting a Go in...

So, to take this a little further, Is there any advantage to example 2 over example 1, besides network communication (in fact example 2 would cause MORE network communication, right)?...

Yeah, I know. I did find a TSQL script that will script out a DB and I hope I can modify that to allow me to tell it what to...

That doesn't pick up the PK dependency. Not sure why.

Also, perhaps the sp_Depends bug, it doesn't pick up the view of the table is created after the view (the likely...

I agree with Sumanta. You need to create a separate file group, with at least one file in it, and rebuild your clustered index for that table in the separate...

I try to keep things as simpler as possible, while being descriptive, but generic. What I mean is instead of HRSelfServiceDev, I'd use HRSelfService, because it carries across environments with...

I already have code that searches for the column in procs, indexes, and UDFs. My concern is for other objects, such as constraints and primary keys, or rather any other...

Compression can be nice, but will vary, depending on what kind of data i stored in the DB. The question you have to answer is, why is the DB growing...

I have asked the same question myself. OK, so your DB is encrypted. What exactly does that protect you from? I suppose it protects another app, like SSMS, from some...

Your best bet will be SQL Ping.

http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx

Chris

Those errors sound like you have a network issue. You should check that first, before you look any more at SQL Server or FTP for the problem.

Chris

It depends on the traffic each will see. My data warehouse has separate files for the different data sets in one DB, because it has so much traffic that we...

And in regards to the model being used, we don't have much choice here. This is used for an auditing application and management needs all data to remain in the...