To determine Server collation and/or other collation setting try this:

--Server collation

SELECT SERVERPROPERTY ('collation') AS 'Server collation'

--Database collation

SELECT DATABASEPROPERTYEX('Northwind', 'Collation') DB_SQLCollation;

--Collations used in tables

SELECT OBJECT_NAME(Object_Id) AS 'Table Name',name AS 'Column name',...

Steve Jones - SSC Editor (2/13/2012)

---

Jeff Moden (2/12/2012)

---

Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects,...

Hmmm not as many unused indexes as I thought might be there. Now with the names of the table using those unused indexes you could run:

The undocumented procedure ...

Jeff Moden (2/12/2012)

---

Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects, it's gotten way out of...

Assuming it is T-SQL procedure

CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ]

[ { @parameter [ type_schema_name. ] data_type }

...

LutzM (2/12/2012)

---

"A little help" in the meaning of "Give me some fish" or...

Yet again I see another question which obviously effects the size of your database at:

http://www.sqlservercentral.com/Forums/Topic1250789-146-1.aspx

Now how about try this T-SQL and we can see if any of those indexes are...

Like most questions ... the answer is "It Depends"

Because of that I strongly suggest you read:

http://sqlcat.com/sqlcat/b/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx

Before making your decision.

-----Found after above was posted -----------------

I see in another post of yours...

Using SSMS:

On any forum page

1. Welcome banner - Clikc on "My Account"

2.My account

Profile

...

LutzM (2/11/2012)

---

shahgols (2/10/2012)

---

You got great points Rob, thanks for that!

And thanks for your response Burninator. Are you guys allowed to use USB or connect your cell phones to your...

shahgols (2/10/2012)

---

Thanks for your response. I wonder how Banks ensure that the DBAs or developers do not walk off with their data. And health insurance companies. Anyone...

Roy

One item I failed to mention, the outline/subject matter for the meeting was distributed by my manager the day before the scheduled meeting

Another "trick" my manager used. Had coffee/tea/donuts/pastry...

Roy

Thx for all the advice. Yes, they have plans for me to go higher up in the management. I have been asked to manage all Development teams and projects. It...

Try this:

SELECT ID,Dated,SUM(Amount) FROM #T GROUP BY ID,Dated ORDER BY ID

Of course alter the FROM #T to FROM substitue your tables name

My resutl:

12012-02-03 00:00:00.000250.00

22012-02-04 00:00:00.00065.00

32012-02-07 00:00:00.000500.00

Roy Ernest (2/10/2012)

---

Couple of weeks back I told you all that I got a great review from work. Now they have changed my role. They want me to manage more...