Can you set up a test environment? At least the faulty developer won't cripple the production server 😉

See if this helps

http://support.microsoft.com/kb/951574

Dobermann, Jeff, I appologize for being wrong this time. I did not realized in a timely manner the output that Dobermann needs.

Sorry, guys :blush:

MS Visio

Database models are useful even if you work in a small shop. And not only for auditing purposes 🙂

I think that a cursor, which accesses the data ordered by date, is useful in your case.

Change the databases owners first. See BOL ---> DROP LOGIN ---> Remarks

See also http://www.sqlservercentral.com/articles/Security/removingthebuiltinadministratorssomepitfallstoavoi/1661/

and

http://www.mssqltips.com/tipprint.asp?tip=1017

I still think this is a useful addition 🙂

Paul White NZ (5/3/2010)

It's a general overview of aggregating over several columns. For...

You can build absolutely normal queries through dynamic SQL 🙂

Also check

http://www.sqlmag.com/blogs/PuzzledbyTSQL/tabid/1023/entryid/12611/Aggregate-Over-Columns.aspx

Jeff's advice is one of the best in this case.

I think that we are dealing here with an example of "Jack-of-all-trades" code (http://www.databasejournal.com/features/mssql/article.php/3830981/T-SQL-Best-Practices--Part-2.htm)

Besides the code review Jeff...

See if this helps

http://www.sommarskog.se/arrays-in-sql-2005.html

...and some quick thoughts - sorry if I'm missing anything...:

- if you insert into the table variable (@TempQuote) a big number of records (usually I use the 1000 records...

There are "missing index" mentioned in both extranetplan3004-2.sqlplan and extranetplan3004-3.sqlplan.

In SQL 2005 you can see the "missing index" tags in the XML plan.

Try to create those indexes and run the...