Viewing 15 posts - 2,131 through 2,145 (of 9,715 total)
Sean Lange (11/23/2015)
Interesting....you posted your response to Luis's suggestion of outer apply just 21 minutes after his post yet you state it took 7 hours.
Good catch, Sean. I didn't even...
November 23, 2015 at 8:32 am
My best suggestion would be to use a Data Flow task to insert various items to evaluate the final row, then used Derived Column tasks to add the final blank...
November 23, 2015 at 8:30 am
I don't know that it will continue where it left off.
But did you verify that SQL Server Agent is set to restart automatically (at the Agent & service level) when...
November 23, 2015 at 8:27 am
Luis, you are a better person than I am. I have no desire to keep encouraging the OP to ask for the query, so I am not answering at the...
November 23, 2015 at 8:24 am
IP addresses have nothing to do with the drive the files are on and everything to do with the NICs in the servers / assigned to the servers.
That being said,...
November 23, 2015 at 7:16 am
Sorry, I don't provide queries for homework. Please look at what I previously said about breaking down the problem and try it yourself.
November 23, 2015 at 7:13 am
You could write yourself a data dictionary report in SSRS that would pull all dependencies on each object. Then refer to that report every time you go to make a...
November 23, 2015 at 7:12 am
Check the windows events logs for errors and warnings around that time. Also look at the information messages. What is going on at the server / OS level during that...
November 23, 2015 at 7:10 am
Are DB1 & DB2 on the same server? If not, run a hardware check. I can't count the number of network issues we had because a NIC was going bad....
November 23, 2015 at 7:07 am
Jagdev, post a new thread and detail your issue a little more.
People don't tend to respond to older threads.
November 23, 2015 at 7:03 am
Have you seen this solution[/url] at Simple Talk?
I haven't used it myself, but it looks interesting.
November 23, 2015 at 7:00 am
Scott, that is an awesome explanation.
November 23, 2015 at 6:54 am
Luis Cazares (11/23/2015)
Brandie Tarvin (11/23/2015)
Hey, guys, we have a language conversion question over here. Can anyone assist with this?I'm sure this is just a typical PEBKAC. 😀
Or there are mitigating...
November 23, 2015 at 6:51 am
amy26 (11/20/2015)
but is it possible to capture disabling of triggers in a server audit or would I have to create something special for that?
You have to create something specific to...
November 23, 2015 at 6:43 am
My advice is two-fold.
First, don't try to shrink while other people are using the database. Find a maintenance window. Change the db to Single User if you have to. Keep...
November 23, 2015 at 6:36 am
Viewing 15 posts - 2,131 through 2,145 (of 9,715 total)