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...
General Size- 2582MB Space Available - 685 MB Data Files Space Allocated - 2112MB Automatically grow file - checked File Growth by - 10% Maximum...
Maxsize = 1GB, filesize = 2.1GB I don't understand it either. I would take a screenshot, but the data is confidential. Like I said, I'm new to...
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...
My friend said that one of the uses for the HTX technology is for the SAN vendors on their HBAs. If that is true then that's pretty exciting news,...
Ok I see what your point of the Power at the wheel analogy is. My mistake sorry. But I think HTX is going to be the answer for PCI-E
HTX is designed for IO http://www.hypertransport.org/tech/tech_htx_pci.cfm?m=9 I think you're right about the 2 duo core on a wafer = quad core...
From what I'm hearing right now, even from my friend, the XEONS are faster at the DUAL processor server level. because Intel is pretty much pushing...
He is a Bios programmer for for the Newisys and they build servers for HP and SUN so he does have access to all sort of performance models and...
I have a friend who is in the server business. He says that the XEON weakness is the Northbridge. It is 80's technology. 2 Sockets AMD and Xeons...
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...
When in doubt restart sql server agent <img src='/community/emoticons/emotion-6.gif' alt=':(' /> lol
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...
I think both RED Gate and SQL LiteSpeed are good. Red Gate is about about half the price. Our company when with Red Gate. It is really a very nice...
You should not use the Administrative Tools --> Services to stop the SQL server in a cluster. You should always try to stop the the SQL using the...
Separate names with a comma.