Viewing 15 posts - 2,536 through 2,550 (of 13,469 total)
one record at a time?!?!
can you show the code for the procedure? does it have a cursor? are there triggers ont he destination table? does the trigger have cursors?
lots of...
February 11, 2014 at 7:44 am
rajborntodare (2/10/2014)
people having one record per person per each month.
how to get a list of the guys having record...
February 10, 2014 at 2:58 pm
the log does not save the commands that were executed, only the data that actually changed.
you'd want to start using a trace or extended events to capture commands in the...
February 10, 2014 at 2:09 pm
something like this would give you the count that meets your condition, as well as the total count for a total
does this help?
SELECT
SUM(CASE
...
February 10, 2014 at 1:44 pm
the key for the install of the AccessDatabaseEngine_x64.exe from microsoft is there's a /passive parameter to install the 64 bit regardless of whether the 32 bit was...
February 10, 2014 at 12:52 pm
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...
February 10, 2014 at 10:26 am
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...
February 10, 2014 at 9:41 am
Igor Micev (2/10/2014)
Lowell (2/10/2014)
INSERT INTO TableB(a,b,c)
SELECT a,b,c FROM INSERTED
WHERE ConditionA=1
INSERT INTO TableB(a,c,d)
SELECT a,c,d FROM INSERTED
WHERE ConditionB=1
[/code]
Be careful. What if the first INSERT extends the ConditionB set?!
exactly why i said it...
February 10, 2014 at 7:40 am
gautham.gn (2/10/2014)
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...
February 10, 2014 at 7:08 am
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...
February 7, 2014 at 2:34 pm
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...
February 7, 2014 at 1:39 pm
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...
February 7, 2014 at 1:27 pm
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...
February 7, 2014 at 1:24 pm
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...
February 7, 2014 at 1:07 pm
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...
February 7, 2014 at 12:18 pm
Viewing 15 posts - 2,536 through 2,550 (of 13,469 total)