Viewing 15 posts - 9,286 through 9,300 (of 9,715 total)
Then take what I said and reverse engineer it a little. Since you're already inside, you know what the weaknesses in the system are. Start documenting them.
One of...
November 16, 2007 at 2:10 pm
Xintanaka,
It sounds to me like you're trying to justify to this small company why they should hire you, correct?
In that case, don't take impersonal data and usethat as a justification....
November 16, 2007 at 4:04 am
And thanks to everyone for the congratulatory posts. I'm just soooo thrilled about this.
November 15, 2007 at 9:58 am
Matt, How did you know the plot of my tale???? Not only an upgrade gone wrong, but the entire Board of Directors standing over a poor DBA's desk demanding...
November 15, 2007 at 9:57 am
And to enable xp_cmdshell (if you haven't already), go to SQL Server Surface Area Configuration -> Features. This is where you can enable it. It'll be listed under...
November 15, 2007 at 4:52 am
Don't forget, if you're doing a lot of deleting (data from tables), these transactions do get logged. That could also be adding to the size of your Transaction Log....
November 15, 2007 at 4:18 am
Don't forget that you don't have to do all your sorting & grouping in SQL Server itself. You can do some of it with the Groups in SSRS. ...
November 15, 2007 at 4:13 am
Ahh, who needs access to data anyway! Right? @=)
I love the title of the book you co-authored. "How to Cheat at Securing SQL Server"... How much...
November 15, 2007 at 4:00 am
I would advise testing with both an int PK and a change of the nchar(6) to char(6). Run Profiler during the tests so you can see what it's doing....
November 14, 2007 at 4:45 am
Thanks for checking that out, William. I appreciate the confirmation.
So, pretty much any reversion from 2k5 to 2000 has to have the following traits:
1) No use of 2k5 objects...
November 14, 2007 at 4:37 am
Remember that any datatype starting with the letter "n" is a Unicode-compatible datatype and requires extra overhead for processing. Because Unicode characters have so much more space in them...
November 14, 2007 at 4:32 am
And remember, you don't have to install Reporting Services for SQL Server to function.
SSRS is a separate install that you are required to choose (or not) during the...
November 14, 2007 at 4:24 am
Matt Miller (11/13/2007)
Anything that DOES just gets added to your tombstone:D
First response: HA!!!!
Second response: Oh no! AD jokes on a SQL forum. Run away! Run away!
@=)
November 13, 2007 at 9:31 am
Anything that doesn't kill you is something else you can add to your resume. @=)
Good luck with your move.
November 13, 2007 at 9:22 am
No, I haven't. I've never needed to revert. But even though that wizard is out there, I'm sure it can't revert everything.
There are a lot of...
November 13, 2007 at 6:42 am
Viewing 15 posts - 9,286 through 9,300 (of 9,715 total)