Viewing 15 posts - 1,021 through 1,035 (of 1,110 total)
Sounds like you need to do your own homework.
February 10, 2015 at 10:15 am
This approach will not work over holidays.
You're going to need a calendar table to make this work in all cases.
February 10, 2015 at 7:20 am
You're going to have to do some sophisticated regular expression parsing to get about 90% of the way there. You probably won't be 100% successful at splitting all the...
January 13, 2015 at 2:52 pm
Its possible its trying to run the whole kit and caboodle in one transaction. I don't remember 2k5 well enough to know when it commits, or where you can force...
January 13, 2015 at 2:37 pm
bubby (12/29/2014)
I am not exporting the data, I am trying to run the query and want to save the results as csv files with headers, the data is huge
errr... that...
December 29, 2014 at 11:56 am
chrisn-585491 (12/19/2014)
I want JSON support in SQL server, like the way it supports XML.
Psssst.... Wanna buy some PostgreSQL? I got a truckload real cheap...
Evil, evil, keep it away! It'll infect...
December 19, 2014 at 8:06 am
Jeff Moden (11/12/2014
It's not PowerShell. The login that SQL Server uses needs to have privs to where the file is.
Yep, try running your individual job steps as the user...
December 19, 2014 at 8:00 am
I want JSON support in SQL server, like the way it supports XML.
And a pony.
December 19, 2014 at 7:40 am
I have a client sending me .json files to feed into SQL for processing. I ended up hacking up a powershell script to read the json file to a powershell...
December 17, 2014 at 1:45 pm
There is a small risk with doing this, but I think the risk is higher writing straight to a network share. Guess I've seen way to many 'network errors'...
December 8, 2014 at 6:55 am
We use the ola hallengren scripts to backup to a local drive, then added a step to the job to move the files to the file share we want them...
December 8, 2014 at 6:48 am
Viewing 15 posts - 1,021 through 1,035 (of 1,110 total)