There is a very long post titled "just the date, please" at http://www.sqlservercentral.com/Forums/Topic379596-8-2.aspx that, for various algorithms, confirms the validity and has performance comparisons.

The best solution consists of

1. Cast...

"could you post a copy of the code that fixed your parameter sniffing problem?"

This application is running under SQL Server 2000 and the analysis consisted of running a...

[Quote]

... accidental cross joins, triangular joins, or the RBAR associated with Cursors and/or While loops especially those in a UDF. ..

[/quote]

Looks the start of another article - I certain...

It appears that you are attempting to take monthly forecasts and summarize to quarterly with the monthly notes concatenated into a single column.

Please read Jeff Moden's article titled...

Steve Jones advised to use "sqlcmd -L" but there are are a number of problems with this solution:

sqlcmd is for SQL Server 2005 and higher and does not exists for...

Windows Management Interface can be used to query the services , filter for the program to be "sqlservr.exe", and then write the results to a file. Example of...

RBarryYoung has indicated the advantages and disadvantages of paramater sniffing and cached query plans. There are two design items that I recommend.

1. Variables that are used in a...

I find the whole question to be moot. SQL Server access should only be granted to support groups and to applications and no users and no developers should be allowed...

The solution seems overly complex when a "LEFT OUTER JOIN" appears to have the same result.

select ym_visit.car_init, ym_visit.car_no, ym_visit.arrv_date_time, ym_visit.plant_id

, ym_visit.yard_id, ym_visit.track_id, ym_spot.position

, ym_visit.cust_name, ym_visit.order_no, ym_visit.out_block_code

, ym_visit.sched_ship_date

, ym_visit.class_code, ym_visit.scale_weight, ym_visit.road

,...

"Why no backup? "

Here is a good one - I got paged at 1AM last night for a inaccessable SQL Server. I had never heard of the server before...

If you specified "alter index.. REORGANIZE" or "DBCC INDEXDEFRAG", then you have a very strange situation.

But, if you actually specified "alter index.. REBUILD" or "DBCC DBREINDEX", which copies the data...

For table msdb.dbo.sysjobhistory, since some @#*& idiot at MS has columns run_date , run_time and run_duration using the integer datatype with an internal format of YYYYMMDD or HHMMSS, I have...

Please read Jeff Moden's article 'The "Numbers" or "Tally" Table: What it is and how it replaces a loop' at http://www.sqlservercentral.com/articles/TSQL/62867/

First, construct a set with the 24 hours of the...

Were you aware that the "WHERE" conditions are applied after the "OUTER JOINS" are performed, so should any of the columns be in the outer joined tables, this change the...

In reply to Jeff Moden's question: Under the "union all" solution, there are no "parameter", just SQL Statements that are sent to the server in the normal manner as a...