SQL Trace

SQL Trace

RE: Congratulations Frank

Go Frank!  Congratulations!

RE: Refer to calculated field in expressions?

Thank you both for your helpful advice.-Jason

RE: SQL Replication Error

Do you have available space in the disk that you are trying to create the replication database.In the wizard it shows the path where the db wil be created.

RE: How can i make auto number from the first day of the year?

SELECT convert(varchar(3), DATEDIFF ( day , '01/Jan/'+ltrim(str(year(getdate()))) , getdate())) + '-' + convert(varchar(4), YEAR(getdate())) This Will Solve the Problem, remember very first number will be zero.   Manish  

Database Implementation Question

Hi Everyone, I am hoping somebody on this board can help me decide  Here's my challenge.I am developing a custom C# windows application that will be distributed on a retail level. The users will be creating lots of data and be searching,updating etc. They will be excuting some intense custom configurable reports etc.I would like […]

Delphi Code Generator

Comments posted to this topic are about the content posted at http://www.selectdelphi.com/

RE: Statistics on multiple columns

quote: Thanks Jonathan, I read the paper (Automating Statistics Management for Query Optimizers ). Very **very** complex! If I understand well, there's no simple rule of thumb. You have to try and to test (heuristic approach) and so on ... Am I right? Patrick SIMONS, MCP Yes, that paper is quite technical... You can guess […]

RE: Remove alpha characters

Jonathan, I agree about using 'STUFF' - in fact, when I went back to my code to copy it into my message, I realized that I had used 'STUFF', rather than concatenatation, but re-wrote it to confirm my original claim.