I call shenanigans.

If you tried it, you'd report the same performance hit I was talking about.

Performance on a page like this sucks., and...

none.

no performance impact, because the mail command is asynchronous...the mail is queued to the service broker, and it processed outside of the transaction;

On a recent email campaign, i queued about...

the DDL of the table can help us solidly determine why the index gets skipped;

for example:

one wild guess: if tbl3.ColA and tbl2.ColA in your example below are not the same...

to find a datavalue, you'll have to use a cursor or it's equivalent of building a SQL command for each varchar/char column and executing it.

I've done this before, so let...

i think if your animated gif is over a certain size, or gets resized automatically, the format is not gif89a? (animated?), it's a different gif;

double check you r gif you...

it goes back to what you said you want to do...I might be misunderstanding.

I thought you said you said both find anything and find anything except...

will something like this work...

krishnakhanna (2/17/2012)

---

Basically structure data like the following for all users and tables

Name ...

both SQL and Oracle support pattern matching for any character:

select * from YourTable

where YourColumn like '%H_M%'

SQL supports a type of regular expression like this:

select * from YourTable

where YourColumn like...

the views ALL_TAB_COLUMNS / USER_TAB_COLUMNS has the table name and the raw column info like column name, data type, column id , etc just like our sys.columns;

is that what...

for any browser to try and create/render a drop down menu (html <select>)

with 600K objects, i'd figure you are looking at a render time in minutes; closer to 10 minutes...

i'm just throwing a guess out here, but I don't think you should be building a connection string...

in all my CLR,s when I declare a SQL connection, i do it...

you need to be able to also join against a master list of all sites.

when you cross join dates and sites, you get all possible values...which you can then join...

answering my own question, now that I've been caffeine infused:

i was looking for the border-collapse:collapse; property, usually applied on the table tag.

i believe in 2008 and above, they tightened the security rules on who gets admin of the sql server, and Builtin\Administrators was removed, so you have to be explicitly added...

most likely a permissions issue.

to run a cumulative update, you need to be an administrator ont he amchine...

xp_cmdshell does not run as the logged in user...it runs under whatever the...