thanks for the info. Did a lot of reading up this weekend. Haven't seen anything regarding licensing though. If I'm running 4 procs with standard...
I need to set up some sort of high availability solution from a data center in Virginia to a data center in Texas. Seems like mirroring is probably...
That article deals only with converting the numeric data type in oracle. It does not work for the clob and blob data types.
I have a linked server connection from my sql server to an oracle database. I can query any of the tables unless they have a blob or a clob data...
I wiped our test box which we want to have sql 2000 as the default instance and a named instance of sql 2005. I wiped the box, installed sql 2000...
So why is it not good for auditing? I need to audit my production box, but if I'm going to do trigger based auditing, then I don't want to affect...
Those are the ones that I have been looking into. My question is...has anyone ever done replication for the sake of removing auditing from the...
I need to do auditing of a number of different databases. I've found 2 types....trigger based (Apex) and t-log based (lumigent). We do litespeed...
I realize that I have different options. I just can't find anything stating whether or not dbreindex makes a copy of the table and then deletes the...
I have a table that is about 180GB. I drop and recreate the indexes on it monthly. I remember hearing a long time ago that if you run dbcc...
I have a restore stored procedure that curses through a list of complete backups and restores them all. If there is an error restoring one of the...
The articles that you sent me are things that are supposedly fixed in sp4. The one about referencing views inside of views with a lot of joins...
We just moved to a new server. It's 64 bit, 4 dual core x64 processors, 64 bit OS. Multi-threading is enabled, so it appears as 16 processors. We...
I need to do a relatively quick audit of two SQL Server boxes in order to determine which box is performing better and could handle a new database...
Thanks for your help. Great idea!
I'm trying to set up integrity checks using sql litespeed and I want to be able to test it and see how it would react given that a database becomes...
Any clue why an insert statement into another database with no ordering would cause it to blow up though? Chris
I've been having a lot of problems with tempdb getting very large lately. I've never had these issues in the past and I'm not really doing anything...
We are doing a very time critical restore. We are restoring to 2 weeks ago and I was going to synch up the last two weeks with the data that we...
I have a table that contains about 170 million rows. Monthly I drop all the indexes, load new data (about a million more records), and recreate the...
Separate names with a comma.
