If you're going to do it that way then getdate() is the best way to go.

However, I normally query the msdb..sysjobhistory table to get the starttime (warning, run_date and run_time...

Microsoft recommends 1 data file per processor core, so that's how we set up tempdb. As Manu noted there's no real point in making more than 1 log file,...

I was intending that the select become a case statement, as per the following code for the single-table (fixed bracket boundaries) design:

[font="Courier New"]create table #LookupTab (ID int, Bracket1 float, Bracket2...

If the "brackets (ie. 0-50, 50-100, etc.) are always the same for the different states then these could be added to the state table with a different multiplier for each...

I'd do it completely differently.

First, create and populate a lookup table:

create table tablookup (

kennungint,

tabnamesysname,

joincolsysname)

insert into tablookup values (1, 'tblAdressAnrede', 'FKTextAnrede')

insert into tablookup values (2, 'tblAdressTitel', 'FKTextTitel')

.

.

.

Then your procedure's code could...

We've found SSIS very good for managing multi-stream loads. It takes a while to build but manages it very nicely. If it's not something that needs to be...

I'm guessing that you want to script this to check all tables.

You can append a tablename to sp_spaceused to get the usage of a specific table. If you need...

The thing that Enterprise has over Standard that affects our environment is clustering, but it depends on your environment/requirement as to whether that's relevant. Here's a link to a...

G'day Jonathon,

Glad to be of service.

It's good to hear you're on top of the potential collation issue. It took me quite a while to work out what was going...

G'day Kendal,

When you're writing to either configuration each block is being written to two physical drives at once and the write has to complete to both drives before it is...

G'day RD,

I've never dealt with SQL Server in workgroups before, but the first thing I'd do is to "thank" whoever required this with a blunt instrument.

If you still have to...

G'day Jonathon,

It sounds like you've expanded the tempdb data file(s) but not the log file(s).

The 40MB you're loading into the temporary table is presumably being loaded using "select into ..."...