Viewing 15 posts - 1,516 through 1,530 (of 6,395 total)
HappyGeek - Friday, August 25, 2017 2:47 AMStar
Monger
August 25, 2017 at 4:33 am
August 25, 2017 at 4:24 am
August 25, 2017 at 2:41 am
That is where tools like Red-Gates SQL Prompt come in handy to code refactoring.
You could also look at the sys.columns or information_schema for the columns in the tables...
August 24, 2017 at 5:51 am
You have lost quorum and as such lost the cluster. If you want to do things cleanly you will need to re-establish a quorum of some sort.
If the...
August 24, 2017 at 1:20 am
Will Fact once loaded from stage using the 4 day method be a full load of data as like stage. So once the process is complete both stage and fact...
August 22, 2017 at 6:49 am
Not by any chance using copy only log backups or someone toggled the default parameter value for it in the Ola script? Just started at a place where they have had...
August 18, 2017 at 6:40 am
You will just need to add the SQL Agent account access to the server and database on the other side of the link.
Alternatively you can modify the link...
August 18, 2017 at 5:16 am
August 18, 2017 at 3:17 am
What is the configuration of your TempDB now? Are all of the files from sys.database_files shown in D or E or a mixture?
If they are all in one...
August 18, 2017 at 2:57 am
Ed Wagner - Thursday, August 17, 2017 7:40 AMGrowth
Engorge
August 18, 2017 at 2:41 am
August 18, 2017 at 2:19 am
Reading between the lines, it sounds like your going to pass in a string'123456789' for example then split that into '123' '456' '789' and pass each into the stored proc?
August 18, 2017 at 1:07 am
If they are not on the same network you will need to ensure that the right NAT rules and firewall rules are in place to allow you to transvers the...
August 18, 2017 at 12:58 am
Don't you need to add a ending cell number as you cant go up to cell AD1 as you start in cell B9 in Excel, so you need to define the whole...
August 17, 2017 at 8:11 am
Viewing 15 posts - 1,516 through 1,530 (of 6,395 total)