Running the upgrade advisor against a full day's trace is a good call, especially if you have apps issuing embedded SQL...the more you can capture and analyze the better off...

mmohan.net (7/27/2011)

---

Hello All,

Here is the issue I’m facing.

My task is to get guid’s from database field and run few updates based on the guid values.

I had taken execute sql task...

Thanks for posting back!

From the article...

chrisph (7/27/2011)

---

I am pulling a database from a 3rd party contained in a .7z nightly, running a command to extract it and now need a SQL script that will restore...

homebrew01 (7/27/2011)

---

I don't quite understand. What is .7z ?

Is the database backup file changing nightly, but the databse will ulimately have the same name each day ? Could...

PERSISTED was a nice idea but it can't be done due to the data access the UDF is trying to do.

Sure, HTH 🙂

Here's a quick demo SQLTestUser to show the technique:

IF OBJECT_ID(N'tempdb..#temp_table') > 0

DROP TABLE #temp_table ;

CREATE TABLE #temp_table

(

type_smallint SMALLINT,

type_bit BIT

) ;

INSERT INTO #temp_table

...

Ahhh...got it. Sorry, I was looking at your latest "is not quite a performance-booster" comment as a claim of loss of performance or something.

<still_learning>I know collations as a set of...

Anytime, HTH 🙂

Jeff, I figure you were trying to dilute things a bit here, which I do too depending on the forum as it were, but I want to make sure we...

Regarding item 3: granting permissions at the schema level simplifies things significantly. If your requirements allow it I would do that rather than going to the object level.

Regarding item 4:...

Dan explains a one-size-fits-all approach that I think is elegant and is the one I use and recommend unless "granular or complex" security requirements exist:

Keep Schema and Ownership Simple

Please post the resolution so others can see in case they had the same error or similar issue.

SELECT roles.name AS role_name,

...