Viewing 15 posts - 6,751 through 6,765 (of 9,400 total)
Koen Verbeeck (1/7/2015)
Ed Wagner (1/7/2015)
Koen Verbeeck (1/7/2015)
Xavon (1/7/2015)
January 7, 2015 at 6:41 am
Koen Verbeeck (1/7/2015)
Xavon (1/7/2015)
January 7, 2015 at 6:32 am
batgirl (1/7/2015)
Ed Wagner (1/7/2015)
SQLRNNR (1/6/2015)
Ed Wagner (1/6/2015)
crookj (1/6/2015)
SQLRNNR (1/6/2015)
crookj (1/5/2015)
Ed Wagner (1/5/2015)
djj (1/5/2015)
Ed Wagner (1/5/2015)
Stuart Davies (1/5/2015)
Ed Wagner (1/5/2015)
SQLRNNR (1/2/2015)
SonicBoom
Bust
Museum
Night
History
Buff
BIFF
Tree (Why don't you make like a tree and get out...
January 7, 2015 at 6:28 am
SQLRNNR (1/6/2015)
Ed Wagner (1/6/2015)
crookj (1/6/2015)
SQLRNNR (1/6/2015)
crookj (1/5/2015)
Ed Wagner (1/5/2015)
djj (1/5/2015)
Ed Wagner (1/5/2015)
Stuart Davies (1/5/2015)
Ed Wagner (1/5/2015)
SQLRNNR (1/2/2015)
SonicBoom
Bust
Museum
Night
History
Buff
BIFF
Tree (Why don't you make like a tree and get out of here)
Future
Lightening
1.21 Gigawatts
January 7, 2015 at 5:58 am
I also clicked COUNT right away, then paused and thought about GROUPING. I actually looked it up and saw that I didn't ignore NULLs. Guessing between the two...
January 7, 2015 at 5:33 am
Really good question. For those of us who don't get to play with Enterprise Edition, partitioned views are the only option we have. Thanks very much.
January 7, 2015 at 5:26 am
Koen Verbeeck (1/7/2015)
Sean Lange (1/6/2015)
January 7, 2015 at 5:21 am
TomThomson (1/6/2015)
Ed Wagner (1/6/2015)
djj (1/6/2015)
crookj (1/6/2015)
Ed Wagner (1/6/2015)
TomThomson (1/5/2015)
Ed Wagner (1/5/2015)
djj (1/5/2015)
Ed Wagner (1/5/2015)
BWFC (1/5/2015)
crookj (1/5/2015)
Ed Wagner (1/5/2015)
HistoryBuff
Polish
Shine
Moon
Titan
Cronus & Theia
Zeus
Orion
Belt
Black (Shodan)
Nidan
Sandan (I know a few)
January 6, 2015 at 12:41 pm
Nice, Luis. I didn't consider using regular expression. I went down the road of splitting the parts of the date and then concatenating them and converting the result...
January 6, 2015 at 12:23 pm
sharonsql2013 (1/6/2015)
Sample :21 Dec 2014 00:16:15
25 Oct 2014 00:16:18
30 Dec 2014 00:16:53
90000
23 Oct 2013 00:16:27
You probably already realize that it's always best to select an appropriate data type during design...
January 6, 2015 at 11:51 am
crookj (1/6/2015)
SQLRNNR (1/6/2015)
crookj (1/5/2015)
Ed Wagner (1/5/2015)
djj (1/5/2015)
Ed Wagner (1/5/2015)
Stuart Davies (1/5/2015)
Ed Wagner (1/5/2015)
SQLRNNR (1/2/2015)
SonicBoom
Bust
Museum
Night
History
Buff
BIFF
Tree (Why don't you make like a tree and get out of here)
Future
January 6, 2015 at 11:29 am
Let me cast another vote for not letting applications connect with sysadmin privs - it's just plain dangerous and you're asking for trouble. Ask yourself who's responsible for the...
January 6, 2015 at 9:20 am
SQLRNNR (1/6/2015)
Koen Verbeeck (1/6/2015)
Ed Wagner (1/6/2015)
Jeff Moden (1/6/2015)
GilaMonster (1/5/2015)
Jeff Moden (1/4/2015)
January 6, 2015 at 9:13 am
Phil Parkin (1/6/2015)
Nice one Jeff 😎
Agreed - very nice. Use math in a set and watch it fly.
January 6, 2015 at 9:02 am
djj (1/6/2015)
crookj (1/6/2015)
Ed Wagner (1/6/2015)
TomThomson (1/5/2015)
Ed Wagner (1/5/2015)
djj (1/5/2015)
Ed Wagner (1/5/2015)
BWFC (1/5/2015)
crookj (1/5/2015)
Ed Wagner (1/5/2015)
HistoryBuff
Polish
Shine
Moon
Titan
Cronus & Theia
Zeus
Orion
Belt
Black (Shodan)
January 6, 2015 at 8:08 am
Viewing 15 posts - 6,751 through 6,765 (of 9,400 total)