Viewing 15 posts - 736 through 750 (of 972 total)
The Rambling DBA: Jonathan Kehayias
Good article to read...
April 4, 2010 at 8:25 pm
If the disk are not providing adequate performance, it does not matter how you slice up the database files. They are still working on the same disk.
We have been...
April 4, 2010 at 8:23 pm
Paul White NZ (4/4/2010)
MeltonDBA (4/4/2010)
April 4, 2010 at 12:30 pm
bigM (4/4/2010)
So does this mean WMI query is the only approach to get the information (alert) about the memory usage of the physical server where the SQL Server resides.
You can...
April 4, 2010 at 12:23 pm
Note to self...read before posting :hehe:
April 4, 2010 at 12:06 pm
No...SQL Server will only capture counters and information for what resources it is using. It does not take much note of what is outside the boundary.
April 4, 2010 at 11:53 am
beejug1983 (4/3/2010)
I want to know if .mdf file gets deleted wrongly, can we recreate .mdf file, whereas .ldf file is available on the disk.
If it is possible suggest me...
April 3, 2010 at 2:16 pm
Could you use TableDiff (comes with SQL Server 2005)? Pull information about the configured jobs of each server to a temp table (or compare the sys tables straight, but...
April 2, 2010 at 11:26 am
darth.pathos (4/2/2010)
C:\SQL\ia64, \x64, and \x86. I also have autorun.inf, setup.exe, and a couple of other files.
I don't type that fast so Perry beat me to it...
But to re-iterate:
You should...
April 2, 2010 at 9:53 am
I supported Navision 4.x years back and it contained a Change Log table that if enabled would log just about everything a user did in Navision. If that account...
April 2, 2010 at 9:37 am
Not sure where you read but you are correct Target is how much memory SQL would like and Total is how much it has. I'm not sure you would...
April 2, 2010 at 9:31 am
Perry Whittle (3/31/2010)
HiHowever these details can be entered onto the server and the following link details how to do this if required
http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx
That would be an interesting thing to implement. ...
April 1, 2010 at 5:58 am
Unlike SQL Server 2000; 2005 and 2008 don't write license to the registry anymore. You may find instances were it might have, but Microsoft goes by "paper proof". ...
March 31, 2010 at 11:07 am
Can you post a few messages before and after this one within your log?
March 31, 2010 at 10:33 am
Try this post out:
http://www.sqlservercentral.com/Forums/Topic227694-5-1.aspx
It does not mention use of Windows logins. I use SQL Logins for my 2000 instances while connecting using SSMS 2005 and it seems to function...
March 31, 2010 at 10:30 am
Viewing 15 posts - 736 through 750 (of 972 total)