|
|
Stories recently tagged with '2000'
|
|
submitted by
spirit1
9 months, 19 days ago weblogs.sqlteam.com — There are at least 4 ways you can COUNT in SQL Server: COUNT(*), COUNT(ColumnName), COUNT(DISTINCT ColumnName) AND SUM()
All 4 combined can be used to speed up queries especially for reporting. read more...
add a comment
|
category:  Database | Views: 6
| 
|
tags:
2000, 2005, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
spirit1
1 year, 1 month ago weblogs.sqlteam.com — Until recently i've been sure that there are 2 date formats that are completly locale insensitive.
Those 2 i are yyyy-mm-dd HH:mm:ss.fff and yyyymmdd HH:mm:ss.fff.
And i was proven wrong a few days ago!
read more...
2 comments
|
category: Database | Views: 2
| 
|
tags:
2005, DateTime, 2000, Database, SQLServer | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
published 1 year, 2 months ago, submitted by
spirit1
1 year, 2 months ago weblogs.sqlteam.com — SSMS Tools Pack is an Add-In (Add-On) for Microsoft SQL Server Management Studio 2005 and Microsoft SQL Server Management Studio Express 2005.
It contains a few upgrades to the IDE that I thought were missing from Management Studio.
read more...
2 comments
|
category: Database | Views: 24
| 
|
tags:
2005, SSMS, Add-on, 2000, Database | tag it
Everyones tags: | Your tags: | |
|
|
|
|
|
submitted by
 j.monty
1 year, 8 months ago choosing-a-blog-url-sucks.blogspot.com — After hardening a Production SQL Server Cluster, and reviewing the Secuirty Logs to make sure all was well, among many other strange things I saw SQL Server trying to do, I ran across this gem. read more...
add a comment
|
category: Database | Views: 0
| 
|
tags:
SQLServer, funny, wtf, 2000, Security | tag it
Everyones tags: | Your tags: | |
|
|
|
|
Sponsored Link: www.carlist.ie
Ads via The Lounge
|