RE: Memory Management

How much physical memory is on the server, how much memory is used during those peak times, and how much memory did the vendor set for fixed allocation? If I had to take a guess, it sounds like there may not be that much physical memory on the server. During peak times, the Windows Server […]

RE: Is the Schema Still Needed?

Interesting idea. I hadn't considered that. Thanks for the info. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net

RE: Is the Schema Still Needed?

The use of schemas is common in Oracle because small "databases" in Oracle tend to be implemented within a single instance, each owned by a separate schema. This, along with public synonyms hide most of the complexity of this from the user but still make maintenance for the DBA more straightforward and helps with understandability […]

RE: Where Do I Want To Go Today? - Upsert

I like this idea, Oracle has a similar command but their version is unfortunately structured in a way that makes it difficult (if not impossible) to code against. But very useful in terms of loading data to a data warehouse. Not sure how useful it would be with bcp, since bcp is more of a […]

RE: INSERT Problem

I believe that select into is a non-logged operation. Of course if you do a select into or bcp, you're breaking the transaction chain, so you'll have to do a full dump.

RE: Tool For Security Review

Thanks Brian! I was going down that road and have had good success querying Active Directory from SQL Server in the past but was hoping that I could find something off the shelf to make my life easier for this project. If I get the time to work through this in the near future I […]

RE: Connection Error

Reading your mail made me go Check Some Settings, and you were spot on. My Desktop did not have Permissions on the Sorce SqL DataBase. Thanks, Pretty Dumb of me.

Which of the following queries would properly audit...

RE: Moving databases from SQL7 to clustered SQL server

s_detach_db/sp_attach_db or backup/restore. For login/password transfer, See http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k

RE: Elevate permissions within stored procedure

By "ambiguous" I mean that I don't want to have explicit column names in the stored proc. Because the tables can vary by client, I don't want to code the sproc with explicit columns. Basically, I use OPENXML for inbound and FOR XML AUTO for outbound. The selects are simple, but inserts and updates require […]