Viewing 15 posts - 901 through 915 (of 11,676 total)
If you have SQL 2012 or up:
REPLACENULL(address1,address2)
If not:
(ISNULL(address1)) ? address2 : address1
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 18, 2015 at 1:55 am
wolfkillj (1/18/2013)
nagesh.prasad (1/16/2013)
Also, Money doesn't provide any advantages over Decimal.
Except when working with SSAS. Analysis Services doesn't know decimal, it only knows float and money. So if you need a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 18, 2015 at 1:52 am
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 18, 2015 at 1:50 am
Eirikur Eiriksson (3/17/2015)
Luis Cazares (3/17/2015)
Can someone help with a crystal ball or interrogation system for this thread?http://www.sqlservercentral.com/Forums/Topic1668185-391-1.aspx
You will have to ask Koen, he supposedly took it to the shop for...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 18, 2015 at 1:46 am
Hany Helmy (3/17/2015)
Stewart "Arturius" Campbell (3/16/2015)
Koen Verbeeck (3/16/2015)
Carlo Romagnano (3/16/2015)
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 17, 2015 at 4:35 am
Easy one and a bit of a déjà vu as well.
Thanks Steve for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 17, 2015 at 2:26 am
Jacob Wilkins (3/16/2015)
Koen Verbeeck (3/16/2015)
Can only create nonclustered columnstore index in SQL Server 2012
This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2015 at 9:17 am
Brandie Tarvin (3/16/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2015 at 5:48 am
Carlo Romagnano (3/16/2015)
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2015 at 3:07 am
Can only create nonclustered columnstore index in SQL Server 2012
This makes it seem like you could only create nonclustered columnstore indexes in SQL 2012, but not in 2014. At least...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 16, 2015 at 3:06 am
Sushant Yadav (3/7/2015)
Dear Koen Verbeeck,I am using SQL Server 2008 R2.
In that case your options are more limited. You can use xp_cmdshell to call DTEXEC directly, or maybe call a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 13, 2015 at 2:47 am
DATEADD(YEAR,-2000,myDateColumn) ?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 13, 2015 at 2:45 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 13, 2015 at 2:32 am
richard.vanveen (3/12/2015)
Does the reporting services add-in cost extra, or is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 9:06 am
You can use the sys.dm_db_partition_stats dmv to find the number of rows per partition for your table.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 12, 2015 at 9:04 am
Viewing 15 posts - 901 through 915 (of 11,676 total)