if you want to go the all TSQL route, then Openrowset of a single file,or linked server for a folder full of files is probably the answer.

with an linked server/openrowset...

you cannot change the default trace, but you can create your own trace, with the exact same settings, and have it use more rollover files, larger files, etc.

another issue...

exactly why i said it...

gautham.gn (2/10/2014)

---

Hi,

I have a requirement that two update conditions may happen for a table A. And we need to store the updated records in table B in such a way...

David, where would you put the data reference to the file? is there an additional column at the end of the table, that you can use to update right after...

since what he pasted was almost, but not quite, tab delmited, i rant it through my macro to cleanup;

MAYBE the data is two columns, but here's what i think he...

pretty sure that error is client-side error from ssms, and not a sql server error.

is your script pretty large? does it not have GO statements between some of the blocks...

have you seen sqlfiddle.com/ yet?

it's a nifty web based site that puts you in a sandbox for testing;

in the long run, it's much better to add a sql express or...

for sql users or windows users, you need to UNION ALL something like this to explicitly show the sysadmins, since they inherit the permissions via their server role

SELECT r.name,'sysadmin',dbs.DatabaseName

FROM...

something to help you visualize:

anything with rows modified<5% don't really need to be touched, anything with rows modified < 30 % can take advantage of the REORGANIZE command; anything...

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...