Viewing 15 posts - 5,461 through 5,475 (of 7,168 total)
PS This could also be done, albeit with a lot more coding and testing, using a variation of the "Quirky Update" or the CLR (as noted) to get you a...
July 18, 2011 at 2:16 pm
It isn't pretty (in form or potential performance impact) but it gives the proper result.
CAUTION: a query like this is laced with costly sorts and loops (hidden RBAR) and can...
July 18, 2011 at 2:12 pm
Some inline comments...
bpw (7/16/2011)
This is my first post here - I’m hoping someone can give me some advice. I've included the procedure code along with definitions and execution plan, but...
July 18, 2011 at 1:21 pm
This thread may have some leads or answers for you:
http://www.sqlservercentral.com/Forums/Topic349843-148-1.aspx
July 18, 2011 at 12:37 pm
Note that osql.exe is deprecated as of SQL 2005. The recommended replacement is sqlcmd.exe. Consider using sqlcmd for new development. The command line options are very similar so converting to...
July 18, 2011 at 12:32 pm
chris.downes (7/18/2011)Is it possible to use log shipping for reporting and still tun transaction log backups on the prod server?
The point is, you don't need to take additional log backups...
July 18, 2011 at 12:28 pm
You can setup a trace to do that. Look into the Errors and Warnings Event Category:
July 18, 2011 at 12:13 pm
abdielmomo (7/18/2011)
Please,Is there any transact SQL Command which allows me to copy files from one folder to another on the same computer?
Thanks!
I would recommend PowerShell for this task. Chances...
July 18, 2011 at 11:58 am
To put it another way, are you sure you (or your client) chose the right tool for the job?
If not SSIS, then why not bcp, sqlcmd or even PowerShell via...
July 18, 2011 at 11:56 am
In order for a person to retrieve the Actual Execution Plan the login must be granted the SHOWPLAN permission. sysadmin's, database owners and members of the db_owner role have this...
July 18, 2011 at 11:50 am
Option 2...down the drain. I completely spaced on the limitation re: triggers on the target table.
Option 4: issue two inserts where neither uses the OUTPUT clause
- Insert 1: insert into...
July 17, 2011 at 10:38 pm
TravisDBA (7/17/2011)
I agree that being able to write decent queries and to read others' code is #2 on the list of talent for System DBA's... it's just a mandatory item...
July 17, 2011 at 4:22 pm
Jeff Moden (7/17/2011)
opc.three...IIRC, in the "CREATE or REPLACE" in Oracle (and, I believe, in the ANSI standard), the "REPLACE" is equivalent to an "ALTER".
You're right. IMHO though REPLACE is ambiguous...
July 17, 2011 at 4:08 pm
SQLkiwi (7/17/2011)
I forgot you could use OUTPUT in a derived table but I think there are some restrictions in some scenarios (Adam Machanic's blog on MERGE comes to mind).
There are...
July 17, 2011 at 12:54 pm
Welsh Corgi (7/17/2011)
opc.three (7/17/2011)
July 17, 2011 at 12:42 pm
Viewing 15 posts - 5,461 through 5,475 (of 7,168 total)