Often overlooked is grabbing more data than needed (SELECT * FROM). Had someone trying to figure this one out for hours and it took about 5 minutes to realize there...

Oh well... The only reason I came to it was the newsletter had it in it... Still learned from it so it's all good

When you are dealing with managing a shared DB server for websites it is a lot easier to manage SQL credentials then an AD structure

sattusarmaha (3/1/2011)

---

Hi Charles,

If Gail Shaw is wrong, can u pls giv me answer of below query -

Declare @A as NVARCHAR(max)

SET @A = replicate(convert(NVARCHAR(MAX), '¢¢¢¢¢¢¢¢¢¢'), 805)

select @A

select len(@A)

GO

Why @A...

A little more information would be nice as to what the big picture of this is... Is the parameter some data that needs to be retrieved from SQL? I...

Finally got the time to get back to this. I ended up using xp_CmdShell / SqlCmd, and it seems to work just fine. This is actually called from another procedure...

The application installing this would not have directory access to tell sql where to backup/restore/move the files, so I did not see this as viable

Maybe the permissions issue is not with EXE files, rather adding (non MS) software

The only only MS only options that I can see would be to have a CLR written...

Kind of in the same boat by me. I am a web developer but my niche as of late has been TSQL. Our latest projects have been using Net MVC...

In regards to temp vs variable tables, when I am building procedures that could use either I will develop using both methods and check the performance on both instances.

May want to read through here:

http://social.msdn.microsoft.com/Forums/en/netfxnetcom/thread/a6a0f0b1-c873-4c89-97dd-bae85dfe749d

I agree with Paul, it is more consistent and efficient.

When dealing with time, look at the fact that sql does not have a clock in it, it needs to ask...

When I saw the thread in the daily newsletter the first thing I thought of as well was just running the update script to prepend the ASP. portion onto the...

The code you have in this thread is averaging 210ms. NS was not a DateDiff option in Sql2000 and it does not appear to have been in 2005 either according...

Thank you for the great information. I created the Tally Table (mine took 93,516 ms) and created that function. The performance gain was on the order of ~350%. I then...