Viewing 15 posts - 1,816 through 1,830 (of 11,678 total)
Phil Parkin (9/29/2014)
Koen Verbeeck (9/29/2014)
You'll get these errors when your input column is a string...
September 29, 2014 at 4:01 am
The YEAR function (and MONTH and DAY) only work on date data types, not on strings.
You'll get these errors when your input column is a string data type.
September 29, 2014 at 3:54 am
ronan.healy (9/29/2014)
Phil Parkin (9/29/2014)
ronan.healy (9/29/2014)
21/03/2018
I keep getting an error. do I have to convert it I tried the following code to try and...
September 29, 2014 at 3:44 am
What is the error?
To what data type are you converting?
What is the locale used in the package?
September 29, 2014 at 3:34 am
As a SQL developer, you should know how to develop TSQL of course.
I can recommend the books written by Itzik Ben-Gan.
Microsoft SQL Server 2012 T-SQL Fundamentals
If you have more specific...
September 29, 2014 at 3:17 am
Really appreciate the amazing effort the PASS BoD has done this weekend to set the issues straight.
September 29, 2014 at 2:49 am
LowMemoryLimit: a dedicated amount of RAM for the SSAS instance.
TotalMemoryLimit: when this is reached, SSAS will take measure to cut down on RAM usage. But SSAS can still go over...
September 29, 2014 at 2:47 am
You can find some answers here:
If you have Enterprise edition, you can do an online rebuild. There might still be some locking though.
If you don't have Enterprise edition, the table...
September 29, 2014 at 1:33 am
To enable compression on a table or index, it needs to be rebuild.
This can be done with ALTER TABLE or ALTER INDEX.
More info:
September 29, 2014 at 1:23 am
Steve Jones - SSC Editor (9/26/2014)
September 29, 2014 at 1:20 am
SQLRNNR (9/26/2014)
Koen Verbeeck (9/26/2014)
Apparently PASS passwords (sorry for the alliteration) were compromised[/url].Change your passwords if you haven't already...
ARRRGGGGHHH
Hopefully you didn't change them right away, because there was no SSL or...
September 29, 2014 at 1:19 am
If you want a leading zero, you'll need to store it as a string, not as an int.
By the way, a much easier expression is this:
SET @currMonthNum = RIGHT('0' +...
September 29, 2014 at 1:07 am
I know for ETL you have Talend and Pentaho. Haven't really worked with those tools yet.
September 29, 2014 at 1:05 am
gautamcs22 (9/29/2014)
there will be three rows as i have experianced. due to union ,because union takes all records .
No, that is "union all".
Union removes distinct rows.
September 29, 2014 at 1:02 am
Viewing 15 posts - 1,816 through 1,830 (of 11,678 total)