Viewing 15 posts - 5,461 through 5,475 (of 7,164 total)
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 18, 2011 at 12:28 pm
You can setup a trace to do that. Look into the Errors and Warnings Event Category:
http://technet.microsoft.com/en-us/library/ms177448.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
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...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2011 at 12:54 pm
Welsh Corgi (7/17/2011)
opc.three (7/17/2011)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2011 at 12:42 pm
ALZDBA (7/17/2011)
SQLkiwi (7/16/2011)
I normally write such stubs the other way around, to avoid all that tedious messing about with quotes in the view definition:...
+1 because of the lack of...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2011 at 7:16 am
Reading Jamie's blog has sent my brain's CPU to 100% at times (so has reading Paul's for that matter) but my computer has never had an issue š
Seriously though, maybe...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 17, 2011 at 7:09 am
Viewing 15 posts - 5,461 through 5,475 (of 7,164 total)