Viewing 15 posts - 271 through 285 (of 819 total)
Rune Bivrin (3/26/2015)
Let's assume that there's no output file already there in the location.
If the file is already available in the location, will it write anything to the file?
Which is...
March 26, 2015 at 2:12 am
sipas (3/24/2015)
Carlo Romagnano (3/24/2015)
Extremely easy!Why 2 points?
🙂
Speak for yourself - plenty of people get confused about multiple foreign keys and cascade deletes. They're all extremely easy when you know the...
March 24, 2015 at 7:37 am
Simpaticissimo!
:-D:-D:-D:-D:-D
March 23, 2015 at 2:03 am
patricklambin (3/17/2015)
I have appreciated because it is an example of "bad code" ( too difficult to understand ) that I have met too many times...
March 17, 2015 at 2:16 am
Hany Helmy (3/15/2015)
Gr8 question, thanx 🙂Did anyone tried this feature before? And is there any actual performance gained?
I tried just a little. The answer is as usual "depends".
If you query...
March 16, 2015 at 2:11 am
DataTherapist (2/23/2015)
What's the fine details here that I'm missing?
A clustered columnstore index is regulating how...
February 23, 2015 at 10:11 am
Interesting, I just learned about them last two weeks.
😀
February 23, 2015 at 1:01 am
Koen Verbeeck (2/20/2015)
Carlo Romagnano (2/20/2015)
BY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
|...
February 20, 2015 at 3:18 am
ADD [ COUNTER ] SIGNATURE TO module_class::module_name
BY <crypto_list> [ ,...n ]
<crypto_list> ::=
CERTIFICATE cert_name
| CERTIFICATE cert_name [ WITH...
February 20, 2015 at 1:41 am
pmadhavapeddi22 (2/11/2015)
select * from sys.syscacheobjects where objtype ='adhoc' and...
February 11, 2015 at 1:30 am
Sean Lange (1/27/2015)
Carlo Romagnano (1/27/2015)
with c
as(
SELECT * FROM (VALUES
(1,2013,1,100)
,(1,2013,1,200)
,(1,2014,0,500)
,(1,2014,1,200)
,(2,2013,1,200)
,(2,2013,1,200)
,(2,2014,1,100)
,(2,2014,1,100)
) AS V([Customer],[Salesyear],[Complete],[Amount])
)
SELECT
...
January 27, 2015 at 7:29 am
Raghavendra Mudugal (1/27/2015)
Carlo Romagnano (1/27/2015)
Strange, but the version with PIVOT is a bit slower than that with GROUP BY. See execution plan!...
actually I was doing the same thing on...
January 27, 2015 at 4:04 am
Viewing 15 posts - 271 through 285 (of 819 total)