SQL Server – CTP is now available for SQL Server 2008 Service Pack 3
CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog...
2011-08-25
728 reads
CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog...
2011-08-25
728 reads
sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...
2011-08-24
2,479 reads
You can browse available SQL Instances on network by choosing "<Browse for More..>" from Server Name drop-down list in "Connect...
2011-08-23
2,069 reads
sys.dm_db_persisted_sku_features lists all features which are utilized by the database. Features specific to Enterprise/Developer edition are:
- Compression,
- Partitioning,
- TDE and...
2011-08-22
1,347 reads
PERCENT_RANK() returns the position of a row within the result set. In contrast to RANK() function, PERCENT_RANK() ranks rows between...
2011-08-19
1,040 reads
CUME_DIST() calculates relative position of a value relative to a group of values. The value returned by CUME_DIST() is > 0...
2011-08-18
654 reads
Parameter Sensitive Plan (PSP) optimization is a new feature in SQL Server 2022 that...
By Arun Sirpal
Chaos engineering is fun but especially important when building solutions in the cloud. It...
By DataOnWheels
I am proud to announce the launch of a new book, centered around the...
Our IT department contacted me recently and asked if they should change the default...
Hi there, I'm on a team developing an enterprise data warehouse for our organization....
Comments posted to this topic are about the item PostgreSQL Copy