Viewing 15 posts - 406 through 420 (of 1,034 total)
GilaMonster (4/10/2012)
This is just one reason:
http://sqlinthewild.co.za/index.php/2009/09/15/multiple-execution-paths/
Another reason has to do with the 'single...
April 10, 2012 at 6:46 am
GilaMonster (4/10/2012)
There is absolutely no need for dynamic SQL here (and the problem was that there were no quotes around the concatenated string in the dynamic SQL.
Really? Wow... I...
April 10, 2012 at 6:42 am
The first query works (when you correct the columns to match the parameters) because you're getting implicit type conversions to numbers. '001' becomes 1 on both sides of the equals...
April 10, 2012 at 6:40 am
My coin flips always seem to turn out the wrong way. *sigh*
April 9, 2012 at 6:57 am
Thanks for an easy one.
I personally love this data type... it makes dealing with multi-time zone data a little bit easier.... datetime data still gives me more headaches than any...
April 5, 2012 at 9:16 am
tiago.palhota (4/4/2012)
If i kill his session, that numbers are reset , if the guy starts again the query (this is comming from reporting services...
April 4, 2012 at 9:17 am
Nice question... looking at the formats I guessed... I spend a lot of time in SSIS these days, but it's mostly SQL-SQL not Text File-SQL.
That said, those were the two...
March 23, 2012 at 6:50 am
Koen Verbeeck (3/20/2012)
When a view is created, information about the view is stored in the following catalog views: sys.views, sys.columns, and sys.sql_expression_dependencies.
Information that is stored in...
March 20, 2012 at 7:01 am
thanks for the explanation Gail....
I didn't this one for sure, but looking at 7500 rowlocks I figured it would escalate... and I kind of remembered that things don't go to...
March 19, 2012 at 2:25 pm
I plan to switch as soon as possible. The SSIS improvements alone are worth any upgrade pain we go through.
For BI we want Crescen...errg...umm... PowerView, and BISM, though having...
March 16, 2012 at 6:46 am
Koen Verbeeck (3/15/2012)
Basic, easy question? I never use the damn thing 🙂Thanks for the question, it was very interesting to learn a bit more.
+1 here as well... never use the...
March 15, 2012 at 6:48 am
Jeff Moden (3/13/2012)
mtassin (3/13/2012)
alfredoapereira (3/13/2012)
but you must have a tally table in your database. and you may not need a calendar table.
Not true... the Tally CTE outperforms the Tally Table....
March 13, 2012 at 12:37 pm
alfredoapereira (3/13/2012)
Koen Verbeeck (3/13/2012)
alfredoapereira (3/13/2012)
Hi you all.Well, I prefer to use a tally table. more clean.
I prefer to use a calendar table, even more clean 😉
but you must have a...
March 13, 2012 at 10:14 am
Jonathan AC Roberts (3/13/2012)
What if you want it in a different language?
Then use this
WITH Months AS (
SELECT monthindex = 1, month_name = DATENAME(mm,DATEADD(mm,0,0))
UNION ALL
SELECT monthindex = 2, month_name =...
March 13, 2012 at 10:07 am
alfredoapereira (3/13/2012)
but you must have a tally table in your database. and you may not need a calendar table.
Not true... the Tally CTE outperforms the Tally Table. But even...
March 13, 2012 at 9:55 am
Viewing 15 posts - 406 through 420 (of 1,034 total)