Joe -

Just in case you were wondering: the difference between your syntax (the so-called "simple case" syntax) and Andras' is that the "simple" version of the syntax assumes that...

Oh - and that's just the first month...:)

Like Jeff said - a lot. By getting to be both dev and DBA you get to fine-tune that fine line between "ivory tower normalization" (the DBA voice) and...

That's usually the way Software Assurance works (you're allowed to upgrade to whatever version), but keep in mind that SA is time-limited (meaning - you must be within the SA...

Once you find the offending code however - restart the server and see what size the tempDB naturally grows to. Once you have a stable number - make that...

Actually - I'm not sure what you plan on getting with that. The numbers are going to be all over the place aren't they?

I'd have to agree there with Brandie. I tried this on two "wide" (180 columns) tables with NO records:

declare @i int

select @i =0

while @i<1000000

begin

insert...

I'm slow but I still get there at times:)

It's that time of the week where I need the "hands bypass" mechanism. The thought's there - but the...

IIF is not a legal construct in Transact-SQL. You need to use the CASE statement instead.

CASE when condition THEN true_value else False_value END

you're right about the same number of columns...which is why the first SELECT of mine was padding with NULLS (as you said). Just make the number of columns the...

As long as you stay with MAX or MIN - I agree with Antares' solution. All of the other aggregate functions will get wrecked by a join before you...

That's not a whole lot of info to go on, but - yes you could. If I understand your request correctly - you'd want to explore something like a...

unless you are dumping the results of the profiler trace to a table like nic_aud_trace, in which case your script would in fact "kill" that profiler session

IF EXISTS (SELECT...

I prefer to reset the right value by using:

dbcc checkident('MyTable', reseed, 0)

dbcc checkident('MyTable', reseed)

The reseed with no arguments will change the seed to the next higher number not used in...

Did you somehow kick yourself out of the "publisher" role? The account creating the reports would need publisher or Content manager access in order to publish/deploy to the server.