When users migrate from SQL Server 2000 to SQL Server 2005, not all databases are set to Compatibility Level 90 which is required to make use of the newly available functions There are many methods to know the Compatibility Level of a database using queries...(read more)
A
New
Internet
Library: Add Your Website/Blog
or Suggest A Website/Blog to our Free Web Directory
http://anil.myfunda.net.
Its very simple, free and SEO Friendly. Submit Now....
Its very simple, free and SEO Friendly. Submit Now....
Blog Archive
-
▼
2009
(102)
-
▼
March
(23)
- Filling random passwords - Set based approach
- SQLBits IV
- SQL Solutions OLAP Heartbeat and OLAP Performance ...
- Splitting delimited data to columns - Set based ap...
- Return TOP N rows
- Export to EXCEL with column names
- SQL_VARIANT_PROPERTY function
- Time Calculation on Numbers
- Row_number() Function with no specific order
- Script of DDL triggers
- NULL on joined columns
- Happy New Year
- Compatibility Level of a database
- Find Alphanumerals only
- SQL_VARIANT datatype and behaviour changes
- Beware of the Usage of SET ROWCOUNT
- Which columns uniquely identify a row?
- Behavior Changes to Database Engine Features in SQ...
- BI Survey 8
- Query behaviour when you cross the LowMemoryLimit
- Analysis Services and the System File Cache
- Updated Wiki: Home
- Updated Wiki: Home
-
▼
March
(23)