Viewing 15 posts - 9,301 through 9,315 (of 9,725 total)
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
Yeah, unfortunately you can't move a 2005 database to 2000 without a lot of work. Even then, something will probably fail.
Kimberly Tripp (works for MS) actually said this about...
November 13, 2007 at 4:53 am
But in your previous post, you said you're writing "TO" SQL Server 2000. And that is what seems to be the problem to me. Check your destination source...
November 13, 2007 at 4:47 am
MP,
You should be aware of everything.
Are your Servers names actually changing? What about share folder names? Instance names? DNS names / pointers? Permissions?
If you're going to...
November 13, 2007 at 4:45 am
The first 15-30 minutes of my day are checking the jobs, making sure all of them ran correctly. This determines how the rest of my day goes.
If jobs failed...
November 13, 2007 at 4:35 am
You really should look at Books Online, topics: Fixed Database Roles and Fixed Server Roles. This will give you a listing of all available permissions that are already set...
November 13, 2007 at 4:17 am
Viewing 15 posts - 9,301 through 9,315 (of 9,725 total)