serg-52 (11/19/2014)

---

Thanks, good question.

I was not sure but rather had an impression that sending parameter of the UDT declared in the current DB to the proc in the other DB...

Besides Tempdb which can be a very big database, the other system databases are tiny, i.e their sizes are in MBs, and the question for their log files fails in...

edwardwill (11/17/2014)

---

The update was incomplete as well. The requirement was to update two rows, so the SQL should have read

SET IDENTITY_INSERT dbo.Roles ON

UPDATE dbo.Roles

SET RoleID=-3

WHERE RoleID=-2;

UPDATE dbo.Roles

...

Toreador (11/17/2014)

---

Out of interest, what was the reason for needing to make this update? I can understand inserts (sort of) due to the need to support legacy data, but not...

serg-52 (11/17/2014)

---

There's one more option to update IDENTITY i.e. using ALTER TABLE ... SWITCH. To be safe intermediate table column is declared as PRIMARY KEY. So original IDENTITY column...

The Question came as a real case experience with a software developer, and I had to do the update in that way, ... so thought to share it.

Thanks.

Your question is about SQL Server 2012, and you've posted a reference for SQL Server 2014.

Additionally from the reference:

[1]The minimum memory required for installing the Data Quality Server component in...

I'm almost sure you'll obtain a performance gain if you could put the data of the selects for TBL_1 and TBL_2 in temporary table(s) and re-write the queries. Additionally you...

Thanks DanMcClain,

Then the function becomes very simple. Examples:

DECLARE @date DATETIME = '02/01/2012';

SELECT DAY(EOMONTH(@date)) AS Result;

SET @date = '02/01/2014';

SELECT DAY(EOMONTH(@date)) AS Result;

Result

-----------

29

Result

-----------

28

Thanks to All that contributed on the discussion. Everybody that will need such function will have to choose from the many versions of the function for returning days in a...

You can do it directly with SSIS.

Jeff Moden (11/5/2014)

---

Igor Micev (9/20/2014)

---

xp_cmdshell should be disabled from the security risk aspect. When you have xp_cmdshell enabled you're allowing processes outside sql server to do changes to databases.

I...

Yes, and thanks for the links. I know there are some issues with sp_msforeachdb. Additionally I've read somewhere that it may...

Yes, there are many articles on capturing stats in sql server.

Take a look at this one http://www.sqlservercentral.com/articles/baselines/96270/

You can overview some more here: http://www.sqlservercentral.com/Search/?q=statistics&s=0&t=a&sort=relevance

Try this

SET NOCOUNT ON

CREATE TABLE #all_users (db VARCHAR(70), sid VARBINARY(85), stat VARCHAR(50))

EXEC master.sys.sp_msforeachdb

'INSERT INTO #all_users

SELECT ''?'', CONVERT(varbinary(85), sid) ,

CASE WHEN r.role_principal_id IS NULL...