I have been taught not to use GOTO until and unless its extremely necessary. I am working on a project having 2400+ stored procedures and only 2 of them uses...

can u check adding selects one by one i.e. first just run the 'MenuItem' select then add 'MenuItemVersion' in the @command variable this might help to get at which point...

http://www.speedproject.de/enu/squeez/index.html

Looks like a nice compression tool.

Kash.

Good question!

Well IMHO a good developer is a good visualizer and tansformer i.e. visualizes the problem its pros and cons its limitation and then transform it to any language he...

Is ur where clause sargable? I mean it uses indexed columns or uses non-indexed columns and is it using any function in where clause?

U may gain some efficiency using indexes.

U...

SQL Server generates a 128 byte unique name for each temporary table. The last 12 charaters i.e. 000000102330 is the Current Session ID generated by SQL Server. So every temporary...

Thanx all for ur replies.

We will hopefully be starting evaluting SQLExpert and SQLBuilder this week.

Regards.

Yes. I am looking a tool that can review T-SQL code based on the given criteria or atleast can check some common performance problem, excessive joins and excessive use of...

Statistical Indexes.

To start with u can search the following in SQl Server Books Online

statistical information, indexes

http://www.microsoft.com/technet/treeview/default.asp?url=/technet/itcommunity/chats/trans/SQL/sql0327.asp

and Inside Microsoft SQL Server 2000 by Kalen Delaney

HTH

Regards.

Thats the best I can do.

SELECT REPLACE(CONVERT(varchar(12), CAST('2003-04-09 00:00:00.000' AS DATETIME), 6),' ', '-')

(and it will be 09-Apr-03 not 08-Apr-03)

Hope this helps.

Regards.

'auto increment column'

U can select an IDENTITY type column and all the other fields from the required table into a temporary table and the select from that temporary table like:

USE...

Thanx to all of u. I am just compiling a small report based on this discussion. This helped me a a lot.

And yes Andy, as soon as I completed my...

Thanx to all of the responses.

Now can anyone please comments on the scalability of SPs and Dynamic queies i.e. if there are 200+ users accessing the system what should be...

Very good article.

I was needing one to show it to my team lead, manager, etc. We are currently in phase of converting SPs (2400+) to dynamic queries (not all but...

Few month back one of our team member reported this error to me. But he was just stress testing the identity columns which are used in the database. Not in...