Viewing 15 posts - 36,931 through 36,945 (of 39,524 total)
I read a bunch of Mr. Celko's posts in Usenet when I was getting started and learned a lot.
However, as mentioned above. I like the punch card formatting for #1....
August 27, 2002 at 9:02 am
Change the password often. Develop a plan to avoid having this be cumbersome.
Profile and audit your server. If you catch people, deal with it administratively.
This is a reason why shared...
August 27, 2002 at 8:53 am
Save it as a text file, or perhaps grab it using the MS HTTP control in DTS.
Interesting idea, though.
Steve Jones
August 26, 2002 at 10:04 am
Why change these? Are they instances?
Steve Jones
August 26, 2002 at 9:28 am
I had this as well. I'm sure you can clean out the registry and get a default, but I didn't bother.
No difference for a named instance. Just have the name...
August 23, 2002 at 1:43 pm
I had this as well. I'm sure you can clean out the registry and get a default, but I didn't bother.
No difference for a named instance. Just have the name...
August 23, 2002 at 1:20 pm
http://www.sqlservercentral.com/columnists/bknight/dbaroles.asp
http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp - Need to update this
Steve Jones
August 23, 2002 at 10:46 am
The XML usually comes back as a single result set or a stream. You have to work with it differently.
ADO has a method to convert it. Check the 4guysfromrolla.com or...
August 23, 2002 at 10:43 am
I'd be very careful here. HSM has matured, but I used to use it in an imaging solution and it was sssssllloooowwwww at times looking for old images. Not sure...
August 23, 2002 at 10:41 am
Glad it worked. I think this took me awhile to get working on one server, but was flawless on another. I don't use the debugger often, but it seems to...
August 23, 2002 at 10:37 am
I had a copy at my last job. Pretty good, well written. Don't remember anything earthshattering in the book, but a good reference to keep handy while trying to figure...
August 23, 2002 at 10:34 am
Unless you had profiler running, there isn't. QA shows the time in the lower right corner. You can also use select getdate()s bracketed around your queries and output this to...
August 23, 2002 at 10:25 am
Could probably build somethng, but no way I know of. Profiler would capture the info and then you could print the result set from the file or table.
Steve Jones
August 23, 2002 at 10:13 am
Viewing 15 posts - 36,931 through 36,945 (of 39,524 total)