Viewing 15 posts - 811 through 825 (of 965 total)
There is no hard and fast answer to whether it is problemattic or not. It really depends a lot on what the impact of the page splitting is. ...
November 3, 2008 at 5:05 pm
Client side, in Management Studio you can use Help --> About which will output:
Microsoft SQL Server Management Studio9.00.3042.00
Microsoft Analysis Services Client Tools2005.090.3042.00
Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML2.6 3.0 4.0...
November 3, 2008 at 2:20 pm
You don't have to look at the DLL's to know whether a patch has been applied. The build number from SELECT @@Version can be used to figure out what...
November 3, 2008 at 1:37 pm
The Service Account for the SQL Agent has to be a sysadmin in the SQL Server for it to startup. The Error 18452 being thrown is coming from the...
November 3, 2008 at 1:34 pm
It sounds to me like you added the column incorrectly to the table, as a computed column with the value of getdate() which is non-deterministic. It should have been...
November 3, 2008 at 1:22 pm
Jeff Moden (10/31/2008)
Do you mean that you changed it to T-SQL?
If you did and you still have problems, can you post your TSQL Trigger code. If you didn't, can...
October 31, 2008 at 9:05 pm
I don't see anywhere in your code that you need CLR to do this. A Simple TSQL Trigger would do this much better.
October 31, 2008 at 12:00 pm
Not really. We had some headaches from time to time that we would also have experienced in a physical implementation when our SAN got overloaded. Adding a 4GB...
October 30, 2008 at 10:41 am
This is a common problem I face when we add a new SQL Server to our environment. The Netbackup Admin sets the policy to work for all databases because...
October 30, 2008 at 9:41 am
This is saying that you attempted a Log backup on the master database which is not supported by any tool including SQL native backup. You can only take a...
October 30, 2008 at 9:32 am
The 1.5 times the phyiscal memory size is based on whether you want the server to be able to do kernel mode or full memory dumps. This is usually...
October 30, 2008 at 9:30 am
You would still need to create a DDL Trigger for the actions you want to audit, and then you can use RAISERROR and specify the WITH LOG option to send...
October 30, 2008 at 9:26 am
Define what you mean by DDL Auditing? You can easily monitor most DDL commands with DDL Triggers in SQL Server 2005. There are plenty of articles out there...
October 30, 2008 at 9:19 am
Jeff Moden (10/29/2008)
Gosh... sounds like a little "push" and you'd have a full blown app. Why not write it as an app?
Jeff,
As resistent as you are to CLR inside...
October 30, 2008 at 9:13 am
The blocked process monitor is actually piggy backing on the deadlock monitor background thread, which is always running, so impact is very minimal. This is covered in the BOL...
October 30, 2008 at 7:37 am
Viewing 15 posts - 811 through 825 (of 965 total)