doh thanks and i edited my psot...

SQL uses the CONVERT function to format dates...there's an optional parameter, like 101, which means dd/mm/yyyy; you can read the details inbooks online under "Cast and Convert"

i think this is...

AWE was the work around for 32 bit systems, because hard drives available RAM got larger than the upper limit of the # of address the system can keep track...

thanks for the clarification Gail!

you said "... If a plan is never cached, it won't appear in the query stats DMV at all...", can you clarify?

I thought every query...

i can think of two ways:

1. set up a DML trace, and after it's run for a while, look at the high values in Duration, Reads,Writes or CPU as a...

DAC is the Dedicated Administrative Connection...If you enabled in on your server (it's optional and off by default), when you have a runaway process you can still connect, and maybe...

forsqlserver (6/7/2011)

---

Shrink Creates Fragmentation, U can use other ways to shrink the database.

check the mdf,Ldf size,

Take a full backup,

Change the recovery model to simple,

again do a full backup,

check the ldf...

ok...i see the plan...but it goes back again to what will the table be used for? the purpose of the table has a lot to do with the best way...

a single, master table tracking all changes and the original values isn't really going to work well...think it through with me.if you want to keep old and new values, you...

sure!

more information about SQL2008 Change Data Capture

so many acronyms on the internet...no way for me to know or infer what MDS was...

ok, i googled a little bit for you here:

http://www.google.com/search?hl=&q=Master+data+services+unauthorised.aspx

and i found this information at...

yep there's a built in function to help;

PARSENAME; give it a try, here's an example:

SELECT

PARSENAME(TheString,4),

PARSENAME(TheString,3),

PARSENAME(TheString,2),

PARSENAME(TheString,1)

FROM

(SELECT '192.168.1.55' AS TheString UNION ALL

SELECT 'Discount' UNION ALL

SELECT 'dbo.Discount'...

is the "MDS homepage" here on SQLServerCentral.com, or somewhere on the internet?

doh Gail beat me to it..i found the example in my snippets:

GRANT EXECUTE ON Schema::schemaname TO <RoleName>

for the default schema... if you leave out the specific objectname it it grants to all objects:

GRANT EXECUTE TO [YourRoleName]

i think for a specific, non-default schema, say QA schema i...