Viewing 15 posts - 1 through 15 (of 15 total)
We have an issue during failover where our production databases will go into Initializing state. It is random, not consistent. We've done a lot of investigation, debugging and are stumped. ...
January 15, 2021 at 1:56 pm
Profiler is your tool. It will capture every database call, based on the events you select. You definately need RPC:Completed and SQL:BatchCompleted.
September 10, 2012 at 9:39 am
Ah poo, I must have missed this sentence:
"When the ForceEncryption option for the Database Engine is set to No, encryption can be requested by the client application but is not...
April 30, 2012 at 6:31 pm
Thanks for you help all - the problem has been solved. This is the message I got from our network admin.
I was able to fix this yesterday after some...
November 16, 2011 at 11:04 am
Thanks everyone. We only have one domain. The user can log into this computer with no problem. Still searching....
November 15, 2011 at 2:38 pm
Ufortunately, they did log off and the issue is still happening.
November 15, 2011 at 8:06 am
Unfortunately, CheckDB cannot fix this error. I tried:)
November 15, 2011 at 7:28 am
This .BAT file does this:
1. runs a SQL script that:
April 28, 2011 at 1:19 pm
Problem solved, we will use TLog shipping but use the WITH STANDBY command so the data can be read.
April 19, 2011 at 11:02 am
That was my first reaction was the data was different and I still believe it is data. I just wanted to make sure I wasn't missing anything. ...
March 9, 2011 at 10:12 am
@HowardW - please ignore my typo for the second query. What is important is the developer states the first query does not return data under 2K8 but...
March 9, 2011 at 7:36 am
Is there any performance gain when partitions are on the same set of spindles (can be same file group or different)?
December 14, 2010 at 1:32 pm
Awesome. This is really timely. I just got Enterprise approved so I can implement partitioning and this series is going to be a huge help. Is the...
December 14, 2010 at 6:54 am
Good article, but there is not enough information.
How are these done?
"The first one is achieved by a rule called JNtoIdxLookup. The second requirement is a correlated loops join - also...
September 9, 2010 at 6:20 am
Thanks. The data is XML, but the stored proc parameter and destination field in the DB are varchar(max) so the parser shouldn't be loading.
August 30, 2010 at 9:31 am