Viewing 15 posts - 1,471 through 1,485 (of 7,484 total)
Not everyone. Some of us stick to easy to remember things like 1,1,1
August 30, 2015 at 9:03 am
Sean Lange (8/26/2015)
I have always laughed when I saw this because it is all caps it is not exactly clear when reading where the word breaks are. I have...
August 26, 2015 at 9:28 am
Nice simple question. No wrong answers yet. (Not many right ones, either).
Surprised it's still there; it's been a NOOP in 2005, 2008, 2008R2, 2012 so I expected it...
August 25, 2015 at 9:09 pm
Sean Lange (8/25/2015)
Ed Wagner (8/25/2015)
Alvin Ramard (8/25/2015)
Ed Wagner (8/25/2015)
August 25, 2015 at 8:33 pm
Interesting how many different ways there are to do this.
Back in the early SQL 2000 days I wanted to send HTML-formatted reports from SQL Server; DB_SENDMAIL was the first option...
August 25, 2015 at 6:48 pm
You should maybe do it the way your comment says - use cascading deletes; change the foreign key to have ON DELETE CASCADE and then use just the single delete...
August 25, 2015 at 5:21 pm
jckfla (8/18/2015)
Eric M Russell (8/18/2015)
August 25, 2015 at 12:50 pm
SQLRNNR (8/18/2015)
call.copse (8/18/2015)
I am probably unusual in that I don't really like FacebookNope - sounds perfectly reasonable to me.
Perfectly reasonable would be an understatement for me. I...
August 25, 2015 at 12:36 pm
It's 45 years since last I worked without source control; and I can't understand why people still do it.
When I arrived at a new job in 2002 I was absolutely...
August 25, 2015 at 12:29 pm
Steve Jones - SSC Editor (8/24/2015)
Wow some great lists. This might be a good thread to compile into an article.
Well, most of the tnings I listed are not scripts I...
August 25, 2015 at 8:55 am
Ed Wagner (8/25/2015)
Stuart Davies (8/25/2015)
Revenant (8/24/2015)
ZZartin (8/24/2015)
whereisSQL? (8/24/2015)
DonlSimpson (8/24/2015)
Ed Wagner (8/24/2015)
djj (8/24/2015)
Ed Wagner (8/24/2015)
Luis Cazares (8/24/2015)
whereisSQL? (8/24/2015)
Ed Wagner (8/24/2015)
TomThomson (8/24/2015)
SQLRNNR (8/24/2015)
oeufrevuelto
Pistol
Pete
Mickey
Mouse
Moose
Rocky
Stalone
Schwarzenegger
Geezer
Me
Myself
Eye
Ore
August 25, 2015 at 8:36 am
Seems a bit obvious - if you want eveything to work cleanly then (a) don't use a non-existent parameter (although a third or people who've answered so far appear to...
August 24, 2015 at 9:05 am
1.
BEGIN TRY
--
--
END TRY
BEGIN CATCH
--
--
END CATCH
2.
BEGIN TRAN
--
--
COMMIT TRAN/ROLLBACK TRAN
3.
BACKUP DATABASE ----
TO D:\BACKUP\---- ;
4.
SET TRANSACTION ISOLATION LEVEL ----
5.
USE PLAYPEN
edit: Number 5 is maybe the one I use...
August 22, 2015 at 11:30 am
Jeff Moden (8/21/2015)
GoofyGuy (8/21/2015)
The DBA gets to torture and embarrass the app developer. Nothing, but nothing, pleases a DBA more than this.
Not for me. I absolutely love it when...
August 21, 2015 at 5:10 pm
Viewing 15 posts - 1,471 through 1,485 (of 7,484 total)