Viewing 15 posts - 2,191 through 2,205 (of 7,168 total)
Easwaran-336667 (1/31/2013)
Please note that I've downloaded the Red Gate's data compare tool which shows the difference but did not provide the script to sync it.
redgate SQL Data Compare will most...
January 31, 2013 at 5:29 am
I have not found telnet to be all that reliable since some firewalls will block it. PortQry is what I use for things like this. It will allow you to...
January 31, 2013 at 5:27 am
SELECT cntr_value AS [amount of memory SQL is using in KB]
FROM sys.dm_os_performance_counters
WHERE counter_name = 'Total Server Memory (KB)';
SELECT physical_memory_in_bytes / 1024.0 AS [amount...
January 31, 2013 at 5:17 am
The Service Pack installer will manipulate the state of the service so connections will be interrupted or impossible at specific times during the upgrade. Definitely test the upgrade in a...
January 31, 2013 at 5:08 am
Phil Parkin (1/31/2013)
johnnycash (1/30/2013)
January 31, 2013 at 5:02 am
A SQL Server Backup/Restore will absolutely restore whatever statistics were in place when the backup was taken from the source. A restore brings online a byte-for-byte representation of the database...
January 31, 2013 at 4:53 am
beejug1983 (1/31/2013)
1) In task manager we always observes that sql service is consuming more memory than actual. Why...
January 31, 2013 at 4:45 am
If you already have a stored proc that can create a database using dynamic sql then why would you store any code in a table (bad idea in general) and...
January 31, 2013 at 4:34 am
Which version of SQL are you on?
January 30, 2013 at 8:24 pm
You should not have to enable the TRUSTWORTHY bit. In fact I would recommend turning that off if only enabled during this effort in an attempt to get something working.
Steps...
January 30, 2013 at 7:27 am
APA0876 (1/29/2013)
How to get the Deadlock Graph from the xml extracted from system_health extended event.
Retrieving Deadlock Graphs with SQL Server 2008 Extended Events By Jonathan Kehayias[/url]
January 30, 2013 at 6:48 am
I would say test your workload with the 'easy tiering' in place and experiment with different raid levels within that context. The disk-virtualization technology has gotten better, it may surprise...
January 30, 2013 at 6:45 am
mramaswamy (1/29/2013)
But I later updated the package using the new build assembly from prod. My...
January 29, 2013 at 9:18 pm
UncleBoris (1/29/2013)
January 29, 2013 at 5:52 pm
UncleBoris (1/29/2013)
SQL 2008 STD
The database is set to auto grow the data file by 4096 MB.
The data file is almost full so will...
January 29, 2013 at 1:44 pm
Viewing 15 posts - 2,191 through 2,205 (of 7,168 total)