Trace flag in deadlock

SQL Server Trace Flags

A comprehensive list of trace flags for SQL Server that you can use to configure your server instance.

DEADLOCK & traceflags!

RE: Indexed Views

I am confused about what can and can't be done with SQL Server Standard Edition. I have Standard Edition and want to turn some of my existing views into indexed views if it will increase the performance of selects against them.Is this possible?

RE: How to enforce a one-row table

Put the customer error message in the App?

RE: syntax for connecting from one SQL server to another SQLl Server

thanks, and sorry about double post, it was not intentional

Query for reteriving the last updated record.

Dear Friend, Can you tell me the query for reteriving the last updated record. Is there a way to do it. Thank you.

RE: date math within 1 column

This query does as you as. Difference between two most recent. Dont you want the difference between the start and end of each query though? I inserted you data into a table called test. Create Table Test([field] varchar(45)) Insert Into Test(field) values('13 2004-07-13 13:15:26.140 end query 10 0') go Insert Into Test(field) values('12 2004-07-13 13:15:01.263 […]

SQL LiteSpeed Free for Developers

Is anyone aware that you can get SQL LiteSpeed for free for SQL Server Developer Edition or MSDE?

RE: Log

Another alternative is ApexSQL Log.