Table and index partitioning can dramatically improve performance when partition elimination can be performed.

This means that the query predicates can help the optimizer choose which partition(s) to read and which...

junlong_9292 (7/6/2012)

---

2012-07-06 20:11:42.23 Server Error 2(error not found) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup...

Brad McGehee has a nice spreadsheet that you could use to document your instances.

You can find it here: http://www.bradmcgehee.com/2012/06/do-you-document-your-sql-server-instances/

Impressive article, Dwain!

Thanks for sharing.

Great news! Congratulations!

Well, you didn't need a certification to...

Your current query, based on the sample data you posted, returns these results:

ROMA_Accept_Fee ROMA_Pre_Reg_Fee

--------------- ----------------

NULL NULL

What would you like...

What is the expected result?

A SQL Server Audit could do the trick.

I haven't checked, but I'm pretty sure you can capture those events.

Hope this helps

Gianluca

Exactly my thoughts, until I had one.

Believe...

Agreed. That's the reason why I coded my own replacement[/url].

This should do the trick:

DECLARE @COPYDatabaseUserName [sysname]

SET @COPYDatabaseUserName = 'Domain\Laurine Torrone'

DECLARE @statement nvarchar(max);

DECLARE @sql nvarchar(max);

DECLARE @results TABLE (

DatabaseName sysname,

name sysname,

principal_id int,

role_principal_id int,

role_name char(4),

default_database_name sysname,

default_language_name sysname

)

SET @statement = '

...

SQLComplete free does both (code formatting and intellisense).

Works quite well.

L' Eomot Inversé (6/20/2012)

---

The thread seems very quiet. I've been away three days and there are only 62 new posts on it.

But I may not find...

Sean Lange (6/20/2012)

---

Dates are a datatype. Formatting is for display. You can't change the format of a datetime. You can however get a string representation in just about any format...

Duplicate post.

Replies here please.