Not a waste of time. Use what works best for you.

SSMS doesn't do that.

You could still use Access for it, so far as I know.

Or you'll be building your own front end.

SSMS is really meant for DBA work, like managing...

There are tables in the execution plan that aren't in the query, probably because they're in the view. Can you post the view definition? Ideally, the table DDL...

Mike Caldwell (11/9/2010)

---

Fingerprints are non-deterministic passwords.

The hash of the...

Nope. I've done that, and never seen an issue. Unless by "multiple" you mean hundreds or thousands, which might eat a few too many resources.

VBA (Visual Basic for Automation) is designed for exactly that kind of thing. You can program an Excel sheet to pull from SQL, push to SQL, pivot on SQL,...

Can't really help on this without a copy of the execution plan.

What's the problem with the join method? Is the query unexpectedly slow?

Sean Lange (11/9/2010)

---

I thought maybe they stood for no chance this person is qualified for the "DB_Developer" position and should therefore keep looking for the entry level position. 😛 You...

Mike Caldwell (11/9/2010)

---

the fingerprint software must have saved an unencrypted version of the key material (i.e. your password) somewhere in order to present it to the OS and log you...

Try a join instead of a string function buried in a UDF.

IF OBJECT_ID(N'tempdb..#Patterns') IS NOT NULL

DROP TABLE #Patterns;

CREATE TABLE #Patterns (

Country CHAR(3),

Pattern VARCHAR(100));

INSERT INTO #Patterns

...

The troll speaketh!!

Security is always about the cost of obtaining it vs the value of what can be obtained.

If the data you have access to is valuable enough, you have to assume...

You can set one of the options for replication to not include schema changes.

But even if you do, what happens when someone adds or changes a column in one of...

Kit G (11/9/2010)

---

GSquared (11/9/2010)

---

Alvin Ramard (11/9/2010)

---

Especially in The Thread.

Speaking...

Is the XML split across files, or just pages within the files?

If it's just pages within the files, take a look at OpenRowset Bulk Single_CLob in Books Online or MSDN....