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...

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...

Phil Parkin (1/31/2013)

---

johnnycash (1/30/2013)

---

Thank you all and yes, I agree that all this should be done at the presentation layer and not at the DB level, but this is one...

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...

beejug1983 (1/31/2013)

---

Experts - I have few doubts over below statements. Please provide your inputs.

1) In task manager we always observes that sql service is consuming more memory than actual. Why...

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...

Which version of SQL are you on?

http://www.sqlservercentral.com/Forums/FindPost1003578.aspx

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...

Retrieving Deadlock Graphs with SQL Server 2008 Extended Events By Jonathan Kehayias[/url]

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...

mramaswamy (1/29/2013)

---

I found the Key file used to build my custom assembly was different in production region.

But I later updated the package using the new build assembly from prod. My...

UncleBoris (1/29/2013)

---

thanks for the info. I grew a database on the prod server by 4096MB and it took a couple of seconds and looking at the "Performance Volume Maintenance Task"...

UncleBoris (1/29/2013)

---

Hello, not sure on what best practice is.

SQL 2008 STD

The database is set to auto grow the data file by 4096 MB.

The data file is almost full so will...

Logging all activity to a table could be disastrous for performance. The recommended way to handle auditing is to write to...

If the owner's login is disabled in the instance then it can still successfully function as a database owner for things like cross-database ownership chains and such. Make sure none...