Viewing 15 posts - 46 through 60 (of 72 total)
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...
March 4, 2011 at 10:30 am
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
March 4, 2011 at 8:32 am
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
March 3, 2011 at 12:09 pm
sattusarmaha (3/1/2011)
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...
March 3, 2011 at 8:59 am
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...
March 2, 2011 at 10:31 am
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...
March 1, 2011 at 5:32 pm
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
February 24, 2011 at 1:46 pm
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...
February 16, 2011 at 9:02 am
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...
February 16, 2011 at 8:49 am
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.
February 16, 2011 at 8:33 am
May want to read through here:
http://social.msdn.microsoft.com/Forums/en/netfxnetcom/thread/a6a0f0b1-c873-4c89-97dd-bae85dfe749d
February 10, 2011 at 9:03 am
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...
January 28, 2011 at 10:31 am
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...
January 5, 2011 at 8:27 am
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...
December 22, 2010 at 10:07 am
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...
December 21, 2010 at 9:16 am
Viewing 15 posts - 46 through 60 (of 72 total)