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,482 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,074 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,350 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,041 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
655 reads
By DataOnWheels
Picture this, your data ingestion team has created a table that has the sales...
By Brian Kelley
I did a post last month titled RTO and RPO are myths unless you've...
By Steve Jones
ioia – n.the wish that you could see statistics overlaid on every person you...
First off, my apologies for what could potentially be a bad title! I am...
I've inherited a couple of rather large databases from my ex-colleague when I join...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I have marked a few transactions in my code. How can I find out which marks were stored in a transaction log?
See possible answers