Viewing 15 posts - 421 through 435 (of 1,034 total)
andrew.diniz (3/13/2012)
Apart from rCTE's scaling linearly, this statement is not correct. Read Jeff's article. A table, however large or small, will always perform many times faster than a rCTE.
That's simply...
March 13, 2012 at 9:54 am
andrew.diniz (3/13/2012)
Apart from rCTE's scaling linearly, this statement is not correct. Read Jeff's article. A table, however large or small, will always perform many times faster than a rCTE.
That's simply...
March 13, 2012 at 9:41 am
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 😉
I use a Tally table to...
March 13, 2012 at 7:28 am
Krtyknm (3/13/2012)
Nice thoughts and suggestions!! But My idea is to keep the SQL script very simple, instead of creating the monthname statically we can go with the dynamic way.Thanks,
Karthik
Recursive CTE...
March 13, 2012 at 7:26 am
rmechaber (3/5/2012)
This was a terribly difficult question: I spent 10 minutes looking for the syntax error, catch, gotcha, trip-up, etc., only to submit the straightforward, correct answer.:-DRich
Same thing here... I...
March 5, 2012 at 6:46 am
I'm with Nils,
This is everything to do with NULL since IN/NOT IN is just translated into a pile of equivalence tests or not equivalence tests.
!= NULL
using the same query...
March 1, 2012 at 7:18 am
For Backups I tend to use maintenance plans.
For Index and Statistics maintenance, I tend to use scripts. Mostly because Microsoft's Index Maintenance takss don't take into account the level...
February 28, 2012 at 7:05 am
It's always good to broaden your horizons.
As a DBA/BI DW Architect/ETL Developer I can say I keep busy.
If you go BI, pick one tool from the top 3...
February 28, 2012 at 7:03 am
Nice and easy.... not used to this.
Scared that 25% got it wrong.
February 28, 2012 at 6:47 am
Do you mean in the filter itself? Won't that change how it functions when I'm not testing it?
Right now if I click on the filter and edit the formula...
February 24, 2012 at 7:18 am
Having no luck with that.
Tried
'Bill Smith;John Doe'
"Bill Smith;John Doe"
"Bill Smith,John Doe"
'Bill Smith,John Doe'
Each returns nothing when I run the query, but if I just specify either Bill Smith or...
February 23, 2012 at 2:14 pm
RTM... interesting... 🙂
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64)
Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT...
February 22, 2012 at 9:10 am
tilew-948340 (2/22/2012)
dawryn (2/22/2012)
In theory you can't set or maybe you can, depends on which article you read.
In practice you can set and new...
February 22, 2012 at 8:41 am
GilaMonster (2/21/2012)
SqlMel (2/21/2012)
It's now down to 2% 🙂
Nils Gustav Stråbø (2/21/2012)
I'm surprised that 21% believes that you can do a point in time restore...
February 21, 2012 at 8:10 am
One day I will understand XML.... and then it will change.
Anyways, a developer and I came up with this. I will never get how I can change namespaces to...
February 20, 2012 at 10:09 am
Viewing 15 posts - 421 through 435 (of 1,034 total)