jcrawf02 (5/23/2008)

---

David Jackson (5/22/2008)

---

Using your test data, what would you expect this to return?

DECLARE @rebuildMe varchar(2000), @iteration int

SET @rebuildMe = ''

SELECT @rebuildMe = @rebuildMe + cast(n as varchar(10)) + '...

Using your test data, what would you expect this to return?

DECLARE @rebuildMe varchar(2000), @iteration int

SET @rebuildMe = ''

SELECT @rebuildMe = @rebuildMe + cast(n as varchar(10)) + ' '

...

This is horrible.

SET NoCount on

declare @cmd VARCHAR(8000)

SET @Cmd = 'EXEC master..xp_cmdshell '''

SET @Cmd = @Cmd + 'SQLCMD /L'''

--or for 2000 servers

-- SET...

Grand 🙂

I'd like to thank you for taking the time to post a much clearer explanation of what's going on than mine. :blush: 😀

Dave J

Glad to help 🙂

It is now using your indexes, which it couldn't do before as it has to convert every value to see if it matched your criteria.

Declare @AsOfDate...

MattieNH (5/1/2008)

---

The other thing I absolutely hate about my code is the necessity to strip the time off my dates for comparison purposes. I can't help but think there's...

What can I say, excellent article, again! Prompted me to put a link to here[/url] on my site, just to make sure I don't lose these...

Well done Jeff. 🙂

Dave...

Wayne,

I spotted another one this morning

http://www.theage.com.au/articles/2008/04/21/1208742844690.html

You can download it here[/url]! :w00t:

Dave J

I know I'm like a week late, but hey, I've been busy. 🙂

This reminded me of this.

http://www.cs.unm.edu/~dlchao/flake/doom/

Definitely want one for SQL. Each room is a different db? CPU Hogs...

You have two options, do an initial insert and then update newly inserted row, or capture what you want to insert into variables and insert in one hit. The...

I recall seeing an awfully nice auditing solution from Pop Rivett. Hang on, I'll go look...

Yep, still there.

See

http://www.simple-talk.com/sql/database-administration/pop-rivetts-sql-server-faq-no.5-pop-on-the-audit-trail/%5B/url%5D

for the article I was thinking about. Now it...

I am not going to do the 2005 test until I've actually used the product in anger, but here are the results I did...

Jeff Moden (3/4/2008)

---

No, no! Copy the code and paste it into MS Word... do a Search and Replace...

Search for ^l (circumflex small-"L") and replace it with ^p (circumflex small-"P")....

I kid you not, this mail was circulated around my...

wrap it in a code tag.

The editor may eat this but I'll try

Select col from...