Darren Myher (5/28/2008)

---

Assuming that you mean the command:

ALTER...

Setting the size of the files during the ALTER DATABASE statement will both change the initial size AND shrink the files.

You can also just set the initial size lower using the ALTER DATABASE syntax.

As I recall it will do both for you (set the initial size and shrink...

Happy to hear, but more importantly - GO BE ON VACATION!

Stop geeking it out with the rest of us shmoes - take the night off or something.....:D

Vicki Aversa (5/28/2008)

---

While trying to stay politically correct, All I'll say is

this dog rolled over a long time ago.

I stopped trying to make sense about 2 years ago. Now,...

You're going to want to tap into CLR for this. That custom extended procedure doesn't exist in a SQL Server 2005 install.

you'll probably want to set something to walk the clustered index keys. something along the lines of a look that pulls in 100K to 1M rows per shot, walking...

What's the data types of these columns?

TalkTime + HoldTime + WrapTime + WaitTime + PreviewTime + DeadTime

Start here:

http://www.sqlservercentral.com/articles/Test+Data/61572/%5B/url%5D

or - you add it back into a datetime. Then use whatever date/time format suits you.

DECLARE @Time DateTime

SET @time = GETDATE()

[MY QUERY]

PRINT dateadd(ms,DATEDIFF(ms,@time, GETDATE()),0)

By default - DAC is only enabled on local connections. You can change that in the Surface Area Configuration Manager (enable remote DAC = True).

From BOL:

By default, the connection...

Yup - messed up the field to count. Too much copying and pasting.

Essentially:

- the first two tables (questions/answers) help establish all of the possible choices. Meaning - the answers...

I'm not sure why you'd need some fancy instantiating the AV app.

If you can live with a short delay, we stayed simpler:

- Upon getting a request like...

All right then - let's try flipping this around a bit:

SELECT C.AnswerText, COUNT(C.AnswerValue) AS 'Count'

FROM

dbo.SurveyQuestions AS Q...

And thank goodness for that. That would be a performance disaster. You don't want to do that IMO.