Viewing 15 posts - 6,166 through 6,180 (of 9,707 total)
Checking for triggers or logon scripts is a good idea. Also, check the application code to see if it has a way of altering the SA password or the SA...
March 25, 2011 at 12:20 pm
GSquared (3/25/2011)
Sounds like the sa password got changed.
Maybe, but I don't think restarting the server would have resolved a changed password issue.
I do agree that SA should not be used...
March 25, 2011 at 12:01 pm
deba_20032004 (3/25/2011)
So there is no way to improve performance.
Unless I'm misreading your comment, it sounds like you've already made up your mind that we can't help you.
Take a deep breath....
March 25, 2011 at 11:58 am
We have an active / active / active / passive setup. So, yes, definitely possible. Use virtual names when possible so when your servers reach EOL, you're not changing a...
March 25, 2011 at 11:53 am
If you are relying on default sizes (not altering them) when you create the databases, all you have to do is look at the size of the Model db files....
March 25, 2011 at 11:46 am
happycat59 (3/25/2011)
I don't think that you will be able to open the packages with BIDS 2005 that easily.
So true. When you save a package in BIDS 2008, even the...
March 25, 2011 at 11:41 am
GSquared (3/25/2011)
jcrawf02 (3/25/2011)
I just want to know who bought a Surface table to play on...
Ooooohhhhh, I WISH!!! That was the first thing I thought of when I saw a...
March 25, 2011 at 10:52 am
At risk of turning this into a technical discussion again. Aren't bulk insert operations minimally logged? Haven't they been since at least SQL 2000?
I ask because a MS document I'm...
March 25, 2011 at 8:58 am
GSquared (3/25/2011)
... but more rules are needed to have a complete solution...
Gus, you have a talent for seeing the same concerns as I do, but articulating them much better. Thank...
March 25, 2011 at 8:48 am
Gianluca Sartori (3/25/2011)
WayneS (3/25/2011)
Fill up a "group queue" with two groups, in order of the routeCode column.
Return one row from each group, in order of the routePos...
March 25, 2011 at 8:40 am
Gianluca Sartori (3/25/2011)
We have to pull out data taking one row from group 1, one row from...
March 25, 2011 at 8:00 am
GilaMonster (3/25/2011)
March 25, 2011 at 7:57 am
To get more input, I #SQLHelp tweeted the question about the transaction log to data file that I'd posted. I got an immediate response that SQL does indeed work that...
March 25, 2011 at 7:39 am
Please try to clarify (in words, without reposting the data output) what the order logic is. Remember, we don't know your data as well as you do, so you might...
March 25, 2011 at 7:19 am
GSquared (3/25/2011)
GilaMonster (3/25/2011)
I just realised I don't have an April Fools day blog post planned. 🙁
So start a completely serious post with, "I had this idea for an April Fools...
March 25, 2011 at 6:58 am
Viewing 15 posts - 6,166 through 6,180 (of 9,707 total)