Viewing 15 posts - 931 through 945 (of 11,676 total)
DECLARE @TimeChar CHAR(4) = '0545';
SELECT REPLACE(LEFT(CONVERT(VARCHAR(20),DATEADD(MINUTE,15,CONVERT(TIME,LEFT(@TimeChar,2) + ':' + RIGHT(@TimeChar,2) + ':' + '00')),114),5),':','')
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 8:11 am
Grant Fritchey (3/10/2015)
Koen Verbeeck (3/10/2015)
Grant Fritchey (3/10/2015)
... Then move on to my books.Subtle. :Whistling: 😀
I keep updating them for a reason.
The private jet doesn't pay for itself, right 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 7:24 am
To be honest, I wouldn't like to manage 2TB of data with standard edition (and possible 16GB of RAM).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 7:03 am
Grant Fritchey (3/10/2015)
... Then move on to my books.
Subtle. :Whistling: 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 7:02 am
I'm afraid you need to create the temp table first, and then use the regular INSERT ... SELECT syntax.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 2:50 am
If you want table partitioning, you need Enterprise edition.
Also, table partitioning in itself is not a performance solution. It's more a maintenance solution for big tables. The possible performance benefit...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 2:48 am
I'm not 100% sure what happens, but I think the error is a bit misleading.
SQL Server will parse the SQL statement and validate it before it actually executes it. Maybe...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 2:31 am
Nice question, thanks Steve!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 10, 2015 at 2:23 am
Without breaking any NDA, I don't think spatial aggregates should be high on your list.
There are more important topics to cover, such as window functions and XML.
I don't remember having...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2015 at 3:52 pm
No, the data flow cannot be dynamic. It needs fixed metadata.
There are commercial components out there that can handle changing metadata.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2015 at 3:49 pm
Easy one!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2015 at 4:09 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 6, 2015 at 1:57 am
Awesome question Tom, well done.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 6, 2015 at 1:55 am
djj (3/5/2015)
Iwas Bornready (3/5/2015)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2015 at 7:01 am
First of all, which version of SSIS?
With procedure, do you mean stored procedure?
1. yes. Depending on the version of SSIS this is easy or rather complicated.
2. yes. Depending on the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 5, 2015 at 6:02 am
Viewing 15 posts - 931 through 945 (of 11,676 total)