Vets5 (11/6/2012)

---

Hi,

I'm putting together a script to run some audit checks(various different things).

I'm just wondering if there is any TSQL to return the Total RAM on a server to SSMS?

I...

What exactly do you mean by "check the scalability of an SQL query"?...

While there are likely many ways to do that, one technique that has worked for me is to use a variable, a connection manager and an expression that assigns the...

Cory Blythe (11/5/2012)

---

I have an request from a client to test a stored procedure that may run up to 500 times concurrently due to user application calls.

They want me...

I have always understood duration in Profiler to include the amount of time it takes SQL Server to fill the last buffer sent to the client. For very large result...

As with so many things in SQL Server, the answer is "it depends". But as a general...

Another good resource regarding a couple of misconceptions about the Bulk-Logged recovery model:

http://www.sqlskills.com/blogs/paul/post/A-SQL-Server-DBA-myth-a-day-(2830)-BULK_LOGGED-recovery-model.aspx

http://msdn.microsoft.com/en-us/library/ms187408(v=sql.105).aspx

restore_date datetime ...

My first guess would be the plan cache.

Here is a query I believe originated from Kalen Delaney.

SELECT objtype, count(*) AS 'number of plans',

...

abishekshroff (11/2/2012)

---

I have one sql server 2008 r2 hosted in a 2 node cluster. I have set min server memory as 64GB and max server memory is 118...

penu.v8 (11/2/2012)

---

Hi

I am working on a database whose database size is 40 gb and the index size is 1 tb.

so i ran a query to find the unused index...

Primary key that is... Not clustered index. Time for coffee on the West Coast.

Agreed. At first look, it appears to be a difficult question and if you attemp to run the scripts without the data, 4 out of the 6 statements work. But...

Without seeing the package it's a little hard to say, but it looks as if something in the package is attempting to set a variable named "User::intETLPID" to a value...

capnhector (11/1/2012)

---

if designed properly and tested thoroughly there is...