Geoff A (11/24/2010)

---

GSquared (11/24/2010)

---

Ninja's_RGR'us (11/24/2010)

---

GSquared (11/24/2010)

---

Per-processor is how most multi-user installations are done. CALs are mostly useful to very small shops with a small number of people accessing the...

Kwisatz78 (11/24/2010)

---

Ok I have got myself in a tiz about device CALs now!!

How does a web front end not qualify for a device CAL when all external users will be...

Sorry to highjack this...

Do you have any columns of this type??

text, ntext, varchar(max), varbinary(max).

Do you have other indexes besides those 2?

Why is having that table at 50MB a problem (other than being odd).

Maybe a weird coordination bug between the list of databases and the permissions of the users looking at that list.

Of course paint seems more likely here.

I'm not a big fan of the RIGHT(output, 38), That script will break if the filename ever changes.

I know it's more complex but I preffer to figuring out the...

GilaMonster (11/23/2010)

---

Brandie Tarvin (11/23/2010)

---

Only ever use Dynamic SQL when you absolutely have to because dynamic SQL can't cache any execution plans for re-use later, which is a performance hit (I...

Yup, good old dos. Still works better than windows in some area!!

here's a start

IF OBJECT_ID('tempdb..#Out') > 0

DROP TABLE #Out

CREATE TABLE #Out (output VARCHAR(MAX))

INSERT INTO #Out (output)

--exec xp_cmdshell 'dir \\whatever\backup'

exec xp_cmdshell 'dir z:'

--you may test if adding a leading space after the...

You're on the right track... 10% fragmentation minimum, reorg @ 29% or less rebuild at 30% and make sure to have at least 1000 pages in there.

Not much else for...

page_count.

If you have the time to learn then go for it... make sure you test on a test machine rather than prod server.

Any errors there can cause serious issues.

You're not filtering on the page count. Fragmentation is not really an issue untill you hit at least 1000 pages in the index.

So if you defrag or reorg a...

pavan_srirangam (11/12/2010)

---

There will be no issues till you run in older compatibility mode

ex: Running in higher version box with no change of compatibility mode

like 2008 box but db...

I'm guessing you are supporting 3rd pary apps which you can't access or modify the logging systems therein?

no you don't