george sibbald (8/2/2011)

---

whats your objective here? do you want to know exactly how SQL is using the memory and if so to what end, or do you just want to...

WTF?!?!?!!?!?!?!?!? SERIOUSLY?!?!?!?!?!?!?!?!!?

This isn't a monitoring function. This is a report. I coud probably give this to a web programmer and tell them to parse it and I would...

Alright, how do I figure out what is getting used above the buffer pool? Are they counters or something else?

Thanks,

Fraggle

You could do it with a SQL Agent Job pretty easly. Just setup a pre-populated list of the 5th business day each month. The run an IF statement...

I resolved this. Figured I would let everyone know what happened.

When we intially tried getting this setup, there was a database user account that was not getting removed. ...

Try starting here first. Will give you the basics. Then we can go from there as there is simply way to much information for a single post.

http://msdn.microsoft.com/en-us/library/ms175477.aspx

Fraggle

For this to work, you certain assumption would have to be made. Are you only dealing with ZipCodes that are numeric in nature? All US zip codes are numeric....

Use magoo's code above to get the data into either a table or a variable. sp_prepare_document is only going to work with a single variable of data, not and...

I would be greatly interested in what people do measure on a regular basis?

My list is as follows:

1) File space statistics

2) Wait Stats

3) Query execution information (reads, writes,...

I am taking a guess here and am no way sure about this, but from what I remember of CTE execution plans, the data is spooled out. I guess...

Triality (7/6/2011)

---

Hello -

I am trying to update a column in my table using the following code:

UPDATE dbo.MasterStage

SET Client =

CASE

WHEN [Carrier] IN (SELECT DISTINCT(C.[Carrier]) FROM dbo.Crosswalk as C)

THEN database_Name.DBO.Crosswalk.[Client]

ELSE 'OTHER'

END

I...

Both of the above statements are true.

As stated above, Service Broker is a queuing mechanism. Meaning that you send a message to a queue and then at some point...

There is no way to Cache the data on the database side in memory.

You could setup a table and using a GUID store the information from page 1 for page...

In management studio, you want to look at Maintenance Plans.

Here is a vid that I found really quickly.

http://www.youtube.com/watch?v=yHzA5i-4qjE

Fraggle

K. Brian Kelley (6/17/2011)

---

I'm talking about ALTER on the db_datareader and db_datawriter schemas. There shouldn't be anything in them. Therefore, that set of permissions is unnecessary. I understand the general...