the answer is the maintenance plan is "good enough";

the maintenance plan is good, but not great; that's the sole difference.

the maintenance plan rebuilds everything, which is often not necessary; an...

stefan 97267 (2/7/2014)

---

Hello all, greetings from a cold-winter Sweden.

I have a problem that i need help with, tried to seach the forum posts but got too many hits.

A customer has...

is this a subset of a larger script? why the dynamic SQL?

also, since you drop and recreate the table every time, why not a temp table?

why create the table...

nope. it's actually a best practice to name the columns every single time, because as soon as you add a column to either table, any existing...

hoseam (2/7/2014)

---

Hi

Is there a way I can:

INSERT INTO TableA

SELECT * FROM TableB

but exclude one column from TableB?

My TableB has ID which is IDENTITY(1,1), I want to select everything to TableA...

vineet_dubey1975 (2/7/2014)

---

I am serving data to the end user(WebPage) via table 'ATABLE'. The data in the table got refreshed after every 1 hr. through a SQL Job (Truncate and refill)...

New Born DBA (2/6/2014)

---

So, what can be done at this point? I don't have any option other than using a Wizard. I don't mind using PowerShell but I am not...

if it went a way after altering the proc, and then came back after a few hours, i'd start suspecting that stale statistics were affecting performance of the existing plans;

if...

wah.... this is the first time i saw this new highlighting and "this worked for the OP";

cute ehnacement!

make step 2 test for a specific time window as part of it's process.

i start a trace @7am if it's not running, and turn it off at 5pm for example:

--###############################################################################################

--startup...

group accounts via SMTP have to be explicitly opened by your exchange administrator, i believe; it's to avoid things like spammers sending to staff@microsoft.com anf getting viagra information to 80K...

the usual answer is it depends on how you are searching;

if you are searching on last name (WHERE LName = 'McArther')

then yes, an index would help a query like that.

anything...

misspoke on "functions", sorry. unfortunately functions don't follow those nifty abilities like procs.

views can be immediately referenced if they start witk sp_, so i have things like sp_Trace02 in my...

ok this might get you started: if you enumerate the permissions for your windows group, and then join this query of active directory for gorup members, you cna get the...

i actually make things system functions , system procedures, and stuff quite a bit i have a ton of developer tools i've created and adapted that go in master.

they all...