Exactly my YMMV point (your mileage may vary).

Regards, Dave.

My favourite! 🙂

Declare @SomeField varchar(100)

Declare @SomeVariable varchar(100)

If @SomeField = 'ConditionA'

Select 'It was A'

Else

Begin

Select 'Use the Begin-End for...

We looked at Robocopy and Powershell here and tried various implementations but found them not totally 100% reliable and secure.

In the end we went with a third party product called...

Thanks. Great article and script.

Just one question, is there a way to do this without revealing the users password in the script or in the run command if...

Great little article Orlando. And a nice neat trick for what I find is a common requirement.

</ soapbox on

It's just a shame that Microsoft don't have a single command...

Were you only bothered about the 3 stored procedures in the database? Did the database not hold any data??

You better get some daily backups set up quickly.... 🙂

Rdgs, Dave.

So, each Heap has 16 columns that will include player info such as Account#, first, last, dob, address, and then the rest that are regarding their play that includes number...

Sometimes I find it better to kill the client rather than kill the query.

🙂

(I loved Gail's restraint on her second reply.....)

Nice clear example Sioban. Thanks. I frequently come across clients who have unintended duplicates in their tables. Data cleansing is a major part of the ETL process in some organisations.

Rgds,...

bartedgerton (10/8/2013)

---

Basu's suggestion was right.

Here is my full query to list all DDL changes:

ALTER PROCEDURE [dbo].[SchemaChangesToday]

@dbName VARCHAR(128) = NULL

AS

BEGIN

DECLARE @filename nvarchar(1000);

-- Get the name...

You could look for the query on the server to try and identify what table it was accessing.

For example, if you have Windows Server 2008 then you can...

Yes I agree Excel is not good for enterprise solutions.

</vent on> However, Access is even worse.....!!! </vent over....>

🙂

Koen Verbeeck (11/27/2013)

---

Indeed. Visitors should register at the reception and give up their license plate. If a car is on the visitors parking space and it has not been registered,...

Cracking article Joshua....

🙂

For faster deletes have you tried repeating the from piece?

For example, in your original post, change this:

>>>>>>>>>>>>>>>>>>>

/* Delete the data */

DELETE TOP (@BatchSize) FROM MyDB.dbo.DoDetailTxns

WHERE StatementID IN (SELECT StatementID...