Viewing 15 posts - 736 through 750 (of 5,590 total)
Good question Dwain... thanks for submitting it. (I wonder how many that got this correct ran the code first...)
One minor nit-picking comment. You initialize the dates like this:
DECLARE @Date1 DATETIME...
October 2, 2012 at 10:12 am
Good question Ron.
If anyone wants to learn more about using the Apply operator, check out the "Using APPLY" links in my signature block for some great articles written by Paul...
October 1, 2012 at 7:52 am
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/28/2012)
Koen Verbeeck (9/28/2012)
laurie-789651 (9/28/2012)
Koen Verbeeck (9/28/2012)
Grant Fritchey (9/27/2012)
Who is going to make it to any of the SQL in the City events coming up in the...
September 28, 2012 at 7:16 am
You need to remember that string manipulation in windows is horribly slow. I wrote an article on creating delimited lists using the FOR XML in 2011 here[/url]. Using this method,...
September 28, 2012 at 7:10 am
Just figured out a solution to a SSRS report that I've been messing with for way too long.
:satisfied: (as long as the customer likes it)
September 27, 2012 at 9:00 am
Stefan Krzywicki (9/21/2012)
WayneS (9/21/2012)
Hmm... how would that handle identical twins, etc with identical DNA?Identical twins don't have identical DNA.
Interesting. I hadn't heard this before, and...
September 21, 2012 at 12:50 pm
Hmm... how would that handle identical twins, etc with identical DNA?
September 21, 2012 at 10:41 am
Don't forget that in SQL 2005 +, that the default trace (which starts automatically) captures deadlock graph information. So you can set up a job that fires when this event...
September 21, 2012 at 7:10 am
Steve Jones - SSC Editor (9/17/2012)
WayneS (9/17/2012)
Steve Jones - SSC Editor (9/17/2012)
FYI, if you're attending the Summit, we have a networking dinner set up again: http://networkingdinnerpasssummit2012.eventbrite.com/
Signed up.
Is there going to...
September 17, 2012 at 9:21 am
Nakul,
Good Article. Thanks for pointing out other areas where updating system tables can cause issues.
Out of curiosity, is the sp_configure option for Allow Updates set to 1 on your system?...
September 17, 2012 at 7:47 am
Steve Jones - SSC Editor (9/17/2012)
FYI, if you're attending the Summit, we have a networking dinner set up again: http://networkingdinnerpasssummit2012.eventbrite.com/
Signed up.
Is there going to be a SQLServerCentral / RedGate party?
September 17, 2012 at 7:39 am
Evil Kraig F (9/15/2012)
Short form: Is there a yearly threadizen gathering that I'm...
September 16, 2012 at 2:30 pm
SQLRNNR (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
GilaMonster (9/14/2012)
SQL Kiwi (9/14/2012)
Lynn Pettis (9/14/2012)
Hey, any comments on what is posted here?My first reaction was, "LOL!". Posted a more serious comment.
Thank you, you saved...
September 14, 2012 at 4:49 pm
Brandie Tarvin (9/11/2012)
September 11, 2012 at 11:14 am
Brandie Tarvin (9/10/2012)
Scott D. Jacobson (9/9/2012)
Just saw this on Hacker News and immediately thought of this long running thread: http://mattgemmell.com/2008/12/08/what-have-you-tried/%5B/url%5DThe Hacker News comments are interesting as well.
Yeah, the comment that...
September 10, 2012 at 9:07 am
Viewing 15 posts - 736 through 750 (of 5,590 total)