Has any one seen in their SQL Server error logs where the Shutdown time from a previous log is later then the recovery time from the next log? For...
I know that the SP is undocumented. I'm trying to run this SP at startup to look at the last log and insert it into a table. I can run the SP at...
I just started at a new environment. I have a database with a data file with maxsize restricted to 1GB, yet the space allocated to it is 2.1Gb right...
I am looking for a SQL Server enterprise scheduler recommendation. It seems like there a few out there from Idera and SQL Sentry and others. If you...
I have a SP that I can run from QA, and command line with no issue. But for some reason it hangs when it's called from the APP. At first we...
We are beginning to start a hardware refresh and I was wondering what type of preference people on this board have? In my experience I have used...
We currently use transactional replication for reporting purposes. It's a pain in the neck a lot of times because lot of people have need/have access...
Does the SQL Server Agent run under AWE memory allocation? I currently have 8GB on my server with 6GB enabled for AWE, but I'm getting some SQL...
Has anyone got got email notification to work on 64bit? SQL mail does not work with 64bit. I've been able to set up database mail to send out test...
We are getting hammered big time with a forum message board application. Our Db is attached to a SAN with a 4 disk LUN. The app is send out about...
My cache Hit Ratio is about 82-84% and my disk query is pretty high. I'm running a message board database. My data file is located on an EMC SAN....
We migrated to AMD dual Core Opterons from a 32bit OS with microsoft search to the 64bit OS with microsoft search. Now FullText Search is dependent...
We are getting an error 22022 not enough storage. It looks like SQL Server is sucking more memory then it's suppose to. We're running 4 X dual core...
I know that this is a very general question and that it would depend on alot of other variables. What is the maximum batch requests/sec for SQL...
Hello, I was running a sp_helpindex on my tables and received a lot of nonclustered, hypothetical, auto created indexes. From what I've read so far...
Hello,<br /><br />Currently we are zipping our backups using winzip. However I've heard that wmzip can cause corruptions to the data. I am...
Hello I run a message Board DB and I am getting high CPU at various times. There doesn't seem to be any pattern to this timing. It has happen in...
HELP, I have a select statement retrieving about 100 column, (sorry bad developers) I placed a non clustered index on the where search criteria,...
Hello, I am trying to replicating newly created tables over from one server to another in an automated process. I am working with commerce server...
Separate names with a comma.
