Viewing 15 posts - 661 through 675 (of 3,221 total)
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',...
February 13, 2012 at 2:21 pm
Steve Jones - SSC Editor (2/13/2012)
Jeff Moden (2/12/2012)
February 13, 2012 at 10:21 am
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 ...
February 13, 2012 at 6:21 am
Jeff Moden (2/12/2012)
February 12, 2012 at 3:41 pm
Assuming it is T-SQL procedure
CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ]
[ { @parameter [ type_schema_name. ] data_type }
...
February 12, 2012 at 10:13 am
LutzM (2/12/2012)
Digs (2/11/2012)
Sir, I am an old fart working on a private project...just needed a little help !Thanks 🙂
"A little help" in the meaning of "Give me some fish" or...
February 12, 2012 at 7:29 am
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...
February 11, 2012 at 1:28 pm
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...
February 11, 2012 at 12:44 pm
Using SSMS:
On any forum page
1. Welcome banner - Clikc on "My Account"
2.My account
Profile
...
February 11, 2012 at 11:02 am
LutzM (2/11/2012)
shahgols (2/10/2012)
And thanks for your response Burninator. Are you guys allowed to use USB or connect your cell phones to your...
February 11, 2012 at 5:17 am
shahgols (2/10/2012)
February 10, 2012 at 3:52 pm
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...
February 10, 2012 at 2:21 pm
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...
February 10, 2012 at 2:09 pm
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
February 10, 2012 at 11:09 am
Roy Ernest (2/10/2012)
February 10, 2012 at 6:55 am
Viewing 15 posts - 661 through 675 (of 3,221 total)