Oh, I do so hope a potential employer googles you! :pinch:

Looks ok to me.

Please post DDL etc etc... 😀

Lynn Pettis (6/26/2012)

---

Welsh Corgi (6/26/2012)

---

I tried BOL but I must not have entered the right search criteria.

Then I goggled it and got a article that provided the example that I...

Nice question, thanks.

Some nice stories, cheers 🙂

Had someone at a place I worked, "sold" about 100,000 cars in milliseconds. :pinch:

Nice question, thanks.

I'd like to start a quick poll: who's updated the most rows in a live table accidentally by not including a where clause in their update statement?

(Doesn't count...

RovanSQL (6/13/2012)

---

you mean the PRINT will only...

Thanks, they should be converted to their variable values by sp_executesql, PRINT will only show the variable as it is, e.g. @rstring.

As this happens within sp_executesql, you won't see it...

Hi Rovan,

Are you running PRINT @sql to get that output?

Does the EXECUTE command not have the expected results?

Thanks

Gaz

Hi Derek, the statement immediately previous to the WITH keyword must terminated by a semicolon.

Nice...

Massive fragmentation overnight?!

Run it table by table, or index by index to narrow down the location of the problem?

It appears it does just run DBCC SHOWCONTIG - found this, straight from the horses mouth: http://www.sqlskills.com/BLOGS/PAUL/post/Inside-sysdm_db_index_physical_stats.aspx

DBCC SHOWCONTIG was replaced by sys.dm_db_index_physical_stats. Under the covers though, they both use the...

Is it a particularly big database?

Far as I know, sys.dm_db_index_physical_stats is a way to produce more consumable results from the 2008 equivalent of DBCC SHOWCONTIG.

How about SUBSTRING?

select count(EmailId), SUBSTRING(EmailId, charindex('@', EmailId)+1, LEN(EmailId))

FROM dbo.Customermaster

where SUBSTRING(EmailId, charindex('@', EmailId)+1, LEN(EmailId)) NOT IN ('gmail.com', 'yahoo.com', 'yahoo.co.in', 'msn.com', 'hotmail.com', 'hotmail.co.in', 'rediffmail.com',

'rediff.com', 'ymail.com', 'indiatimes.com', 'yaghoo.com', 'localmail.com', 'yahoo.co.uk', 'yahoo.in', 'reidffmail.com',...