Viewing 15 posts - 32,296 through 32,310 (of 59,102 total)
Teemo (10/13/2011)
hello guys,Is it true that when you created a table variable, and inserted a data on that table variable all stored on tempdb? same as temp table(#table)?
thanks in advance
Yes......
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 9:09 pm
Agh! Apologies, Perry. I didn't scroll down far enough to see your previous answer.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 8:11 pm
Perry Whittle (10/13/2011)
Option Explicit
'Delete all SQL Server backup files more than x days old
Dim oFS, oSQLBackupFol, oFol, oFil
Set oFS = CreateObject("Scripting.FileSystemObject")
Set oSQLBackupFol =...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 8:10 pm
Amanda Bates-348384 (10/12/2011)
I recently got a new manager, and had one of many, many meetings with him. We were discussing...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 7:55 pm
Like this...
UPDATE inv2
SET Cost = inv1.Cost
FROM dbo.Inventory inv1
INNER JOIN dbo.Inventory inv2
ON inv2.Part_ID = inv1.Part_ID
...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 7:37 pm
I believe you need to include the "RAW" option in order to keep from generating the "stray" charcters which are typically used to identify the file type internally to the...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 7:29 pm
Needless to say, I prefer the "all in one place" aspect. MS took the time to write a "suite" of CLR's to implement the HierarchyID... I'd love it if...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 7:10 pm
daveriya (10/13/2011)
i am getting this error : [Microsoft][SQL Native Client][SQL Server]Conversion failed when converting datetime from character string.i place 'set @Account_date = convert(datetime,'yyyy-mm-ddThh:mm:ss.mmm',126)'
The datetime format you've selected is one...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 6:56 pm
I agree... I don't currently know of a method to send emails using an "effictive" set-based method. Sure, there are set-based methods to generate other code in a set-based...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 10:12 am
On the "poll" section of this thread, I see that 9 people voted as "[font="Arial Black"]Yes, but I can give you a good example of when you HAVE to use...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 9:58 am
opc.three (10/12/2011)
Think third-party web service. A company that offers a value-add service to enrich data that does not reside locally, i.e. data not reachable via standard T-SQL methods.
Actually, that's a...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 9:17 am
L' Eomot Inversé (10/13/2011)
SQLRNNR (10/13/2011)
GSquared (10/13/2011)
Ninja's_RGR'us (10/13/2011)
BrainDonor (10/13/2011)
I know a few users I'd like to send into space.
Yup but the thing is they'll come back. Not really the best...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2011 at 8:51 am
Roy Ernest (10/12/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2011 at 10:19 am
bitbucket-25253 (10/12/2011)
I'm very fortunate to know Jeff, and I'm honored to consider him a friend. He has taught, and continues to teach all of us many things. And not just...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2011 at 10:13 am
SQLRNNR (10/11/2011)
Try this
SELECT MerchantID
from #tempSort
ORDER BY LEFT(merchantID,8) DESC,CASE WHEN ISNUMERIC(REVERSE(right(REVERSE(right(merchantid,LEN(MerchantID)-8)),3))) = 1 THEN 1 ELSE 0 end
Oh... be careful, Jason. REVERSE is terribly expensive compared to other methods especially...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 12, 2011 at 1:31 am
Viewing 15 posts - 32,296 through 32,310 (of 59,102 total)