The code calling the procedure should test string lengths to see if they exceed what the procedure expects. You code the procedure with a specified size, test for it...

Or this:

DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003', @Prod VARCHAR(MAX), @Product_Name VARCHAR(10) = 'Vehicles'

SET @Prod= 'Product: ' + @Product_name + ' (Expires ' + STUFF(CONVERT(VARCHAR(12), @Expiry_Date, 107), 1, 3, DATENAME(MM, @Expiry_Date))...

TheSQLGuru (12/19/2012)

---

It is my belief that this query gets a seek (i.e. is SARGable) as a function-around-a-column because Microsoft KNEW it...

Really need to see the actual execution plan to help answer this, but a guess would be the writes are to a work table for the ORDER BY clause, even...

RVO (12/19/2012)

---

I don't have enough space on local drive.

I don't think there is anything with cards or routers.

As I mentioned I did a test. I copied 1 GB file to...

Adi Cohn-120898 (12/19/2012)

---

I have to admit that it is very hard for me to define the term SARGable. Before we started our discussion in my opinion SARGable criteria was...

Here is the code using the EXISTS in the WHERE clause:

/*Create the table*/

CREATE TABLE dbo.Apps

(

IDVARCHAR(50)NOT NULL,

StatVARCHAR(50)NOT NULL,

StatDateDATENOT NULL

)

;

/*Putting data in the table to create the test enviroment*/

INSERT INTO dbo.Apps

(

ID,

Stat,

StatDate

)

Values

('1', 'AppRec',...

I don't think this has to do with the log files from the production system. Is the DR database in STANDBY mode (i.e. readonly) between log files being received...

mpradeep23 (12/17/2012)

---

Hi

We have a table which contains allmost 1 lak to 2 lak of records

querring on that table getting delayed give me idea how to make it faster

Thanks...

xmozart.ryan (12/17/2012)

---

Hello, i'm newbie in t-sql.. and when i try to catch event before update on trigger sql using instead of update, but i got stuck using this coz the...

mahesh.dasoni (12/16/2012)

---

I have SP which contains function

convert(varchar(12),[datetime],112) =convert(varchar(12),getdate(),112)

this takes lots of time during the Market hours and it is very essential as well.

Is there any alternate which we can...

Looks like the the championship game will be between the SSC Steelers and the SQL Bolts!

Can the SQL Bolts repeat as the Champions of the SSC Fantasy Football League?

Has anyone been paying attention to the Consolation Bracket? Looks like the 11th and 12th place teams will be playing for 7th and 8th position!

The use of a semicolon (;) is also required to terminate the MERGE statement.

I definately agree. It would be nice to have a method to easily determine what a particular scenerio would cost licensing wise as you are starting to architect a...