Viewing 15 posts - 8,401 through 8,415 (of 39,771 total)
Data Driven going on now: https://www.microsoft.com/en-us/server-cloud/data-driven.aspx
March 10, 2016 at 9:17 am
Completely agree. However, when the data is in there, even if you have modified and built a good data model, this is one way you might move that data...
March 10, 2016 at 9:17 am
By default, the DAC isn't available remotely, so you need to be on the console of the host: https://msdn.microsoft.com/en-us/library/ms189595.aspx
The DAC doesn't fire logon triggers: https://www.mssqltips.com/sqlservertip/1631/connecting-to-sql-server-with-a-bad-logon-trigger/
March 10, 2016 at 9:11 am
Are you using the DAC locally? Maybe show the connection string so we can be sure this is working?
In a cluster, you might need to log onto the node,...
March 10, 2016 at 9:06 am
PATINDEX is powerful, without a doubt. I have more of a fondness for charindex, mostly because I can indicate a start position. However, as Luis showed, you can get around...
March 10, 2016 at 9:03 am
Thanks for the catch. I updated the math to get the PO.
I wonder which of these works better in complex queries. It's worth some performance testing to see. I hadn't...
March 10, 2016 at 8:41 am
Sergiy (2/2/2016)
Don't you really know that pre-soring anything in Excel or any other external application does not guarantee that the set will be imported into a SQL Server...
March 9, 2016 at 4:55 pm
Eric M Russell (3/9/2016)
March 9, 2016 at 10:00 am
Japie Botma (3/9/2016)
March 9, 2016 at 9:58 am
I haven't worked on in terms of admin/dev work, but I have worked with a few mainframes over the years, including 370s.
My comments on stability certainly applied for me. The...
March 8, 2016 at 4:56 pm
I may have to try AtBat. Listening in the background is something I've enjoyed, and I certainly like listening while driving or traveling out of town. Wonder if it works...
March 8, 2016 at 4:53 pm
Good to see RC0 out. I saw the BOL page last week, but no download.
We're getting close.
March 8, 2016 at 4:52 pm
Wayne West (3/8/2016)
March 8, 2016 at 4:52 pm
I think that's true. Perhaps the full has priority for some reason.
It shouldn't really matter. SQL Server tracks what has changed and what logs are needed to ensure that recovery...
March 7, 2016 at 2:15 pm
Logs don't matter. They are independent of the fulls and diffs.
In terms of scheduling them at the same time, not sure here. I would think that they would go based...
March 7, 2016 at 1:27 pm
Viewing 15 posts - 8,401 through 8,415 (of 39,771 total)