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
736 reads
SQL and Me
SQL Server – sp_help without arguments.
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,490 reads
SQL Server – Hide an Instance of SQL Server
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,087 reads
SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features
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,362 reads
SQL Server – "Denali" – PERCENT_RANK() Analytic Function
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,044 reads
SQL Server – "Denali" – Using Analytic Function CUME_DIST()
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
660 reads
Blogs
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Forums
SQL Server 2025 Unveiled: The AI-Ready Enterprise Database with Microsoft Fabric Integration
Comments posted to this topic are about the item SQL Server 2025 Unveiled: The...
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers