SQL and Me

CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog...

2011-08-25

731 reads

SQL Server – sp_help without arguments.

by VishalGajjar

SQL and Me

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,485 reads

SQL Server – Hide an Instance of SQL Server

by VishalGajjar

SQL and Me

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,080 reads

SQL Server – sys.dm_db_persisted_sku_features tells you about edition-specific features

by VishalGajjar

SQL and Me

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,355 reads

SQL Server – "Denali" – PERCENT_RANK() Analytic Function

by VishalGajjar

SQL and Me

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,042 reads

SQL Server – "Denali" – Using Analytic Function CUME_DIST()

by VishalGajjar

SQL and Me

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

656 reads

Blogs

Playing with the Data API Builder

By Steve Jones

I published an article today on the Data API Builder, which is a way...

A New Word: Dolonia

By Steve Jones

dolonia – n. a state of unease prompted by people who seem to like...

Cloudbrew 2024 – Slides

By Koen Verbeeck

You can find the slides for the session Building the €100 data warehouse with...

Read the latest Blogs

Forums

Do As I Say, Not As I Do

By Grant Fritchey

Comments posted to this topic are about the item Do As I Say, Not...

Visit the forum

Question of the Day

I have a detached database from SQL Server 2019, called TDE_Primer. This database had a 100MB data file and a 73MB log file. The log file was lost, so I need to run this code:

USE [master] GO CREATE DATABASE [TDE_Primer] ON ( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\DATA\TDE_Primer.mdf' ) FOR ATTACH_REBUILD_LOG GO

See possible answers