Viewing 15 posts - 7,801 through 7,815 (of 9,399 total)
Eirikur Eiriksson (6/18/2014)
😎
USE tempdb;
GO
;WITH SQL_VISDOM AS
(
SELECT
...
June 24, 2014 at 9:54 am
It depends. The true question is what color the server are drawn in. See http://www.youtube.com/watch?v=BKorP55Aqvg for more information. Be forewarned that this video may make you laugh...
June 24, 2014 at 9:44 am
rodjkidd (6/24/2014)
Well done Koen!And in other news, just read Jeff's article on functions... Another stunning Spackle, and one I need to re-read, probably more than once! Nice job there Jeff
Rodders...
As...
June 24, 2014 at 9:39 am
crookj (6/24/2014)
Ed Wagner (6/24/2014)
Sean Lange (6/24/2014)
Ed Wagner (6/24/2014)
djj (6/24/2014)
BWFC (6/24/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
Ed Wagner (6/23/2014)
djj (6/23/2014)
crookj (6/23/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
sluggerBaseball
Babe
Ty
Al
Shoeless
Bundy
Ted
Murder
First
Date
Integer
Float
Root Beer
June 24, 2014 at 9:37 am
Speaking to Matt's point, I hope you're date-stamping your backups and also keeping more than just one day's worth.
June 24, 2014 at 9:29 am
whereisSQL? (6/24/2014)
Ed Wagner (6/24/2014)
Sean Lange (6/24/2014)
Ed Wagner (6/24/2014)
Sean Lange (6/24/2014)
Ed Wagner (6/24/2014)
djj (6/24/2014)
BWFC (6/24/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
Ed Wagner (6/23/2014)
djj (6/23/2014)
crookj (6/23/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
sluggerBaseball
Babe
Ty
Al
Shoeless
Bundy
Ted
Murder
First
Date
Integer
Inequality
Index
Stocks
Mutual Funds
June 24, 2014 at 8:07 am
Sean Lange (6/24/2014)
Ed Wagner (6/24/2014)
Sean Lange (6/24/2014)
Ed Wagner (6/24/2014)
djj (6/24/2014)
BWFC (6/24/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
Ed Wagner (6/23/2014)
djj (6/23/2014)
crookj (6/23/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
sluggerBaseball
Babe
Ty
Al
Shoeless
Bundy
Ted
Murder
First
Date
Integer
Inequality
Index
June 24, 2014 at 8:01 am
Sean Lange (6/24/2014)
Ed Wagner (6/24/2014)
djj (6/24/2014)
BWFC (6/24/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
Ed Wagner (6/23/2014)
djj (6/23/2014)
crookj (6/23/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
sluggerBaseball
Babe
Ty
Al
Shoeless
Bundy
Ted
Murder
First
Date
Integer
June 24, 2014 at 7:30 am
I couldn't agree more. Continuous learning is a part of SQL Server because there's always something more to learn or get better with. There's always going to be...
June 24, 2014 at 6:33 am
I would first have the SQL Agent run as a domain account so you have control of it's permissions. I think it'll behave well if you set the start...
June 24, 2014 at 6:26 am
I believe this would depend on the source file you're sending. If the Excel file is read-only or password protected, then it keeps those properties when you email it...
June 24, 2014 at 6:22 am
djj (6/24/2014)
BWFC (6/24/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
Ed Wagner (6/23/2014)
djj (6/23/2014)
crookj (6/23/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
sluggerBaseball
Babe
Ty
Al
Shoeless
Bundy
Ted
Murder
First
June 24, 2014 at 5:58 am
I knew the answer without even reading the options, which is (of course) why I clicked the wrong one. Lesson of the day: Slow down and think it through.
June 24, 2014 at 5:46 am
SQLRNNR (6/23/2014)
Ed Wagner (6/23/2014)
djj (6/23/2014)
crookj (6/23/2014)
Ed Wagner (6/23/2014)
SQLRNNR (6/23/2014)
sluggerBaseball
Babe
Ty
Al
Shoeless
Bundy
June 23, 2014 at 1:40 pm
Viewing 15 posts - 7,801 through 7,815 (of 9,399 total)