Regarding "naming databases according to whether they are production, development".

What we do is use a place holder for databasenames (e.g. %%DBNAME%%) in our scripts and if we want to...

Another caveat about using GUIDs as keys:

Beware of using non-sequential GUIDs as a non-clustered PRIMARY KEY on large historical data. If you want to delete a block of data (say...

You might not be seeing a performance hit if your looking at events user by user - but it may get slower the longer you run this model (depending on...

Warning : when using this procedure the result set it executes is run on the one of the main processor threads of SQL Server, not your connection thread. If you...

Hi, those quotes are yours. I'm not trying to imply that it is *his* algorithm (even though that was what I said), but that...

Hi,

Echoing the post about the algorithm suggested above that is by Itzik Ben Gan. This is the one I regularly use and after doing a brief performance test against...

Hi there,

Thanks this helped a bit. The dummy parameter solution from Ken did stop the problem in my sp. However this is also occuring in inline functions - which confused...

I use IMCEDA's SQL IDE Pro and that returns 3.4 and QA returns 3.999999999.

Unfortunately I went with the wrong correct answer! Doh!

That was a useful post - not!

I thought this was a very good question. But I did get it right.

I concur - try the following script:

set ansi_nulls on
declare @var int
IF @var is null Print '@var is null (ansi_nulls on, no init)' -- This will...

These yes\no questions are a bit simplistic and allow for a lot of guess work to take place. I knew the answer but if I didn't I probably would have...

I answered the syntax is invalid for the reason above.

Please can these questions be better checked for errors. Do you guys try answering the questions before you post them?

P.S. I've...

Should the cursor not also be closed before being deallocated? (Or does that not matter).

Also why do you check for @@FETCH_STATUS <> -1 in the WHILE LOOP then for @@FETCH_STATUS...

#6 works the best (needs resizing of course - too big) but I have a problem with all of them. The cube motif has one set of light sources but the...

quote:

---

Another very useful editor with great find and replace tool (and regular expressions) is the freeware program Notetab Lite http://www.notetab.com....