Tags » SQL

List all the databases in SQL Server in the order they were created

If you have a MS SQL server with many databases and you want to find out

  • When each database was created
  • Or which was the latest one created…
  • 28 more words
SQL

What is a Tally Table? How can it help me query data?

A Tally Table is a single columned table of integers with sequential values from 1 to N. Where N is the upper limit.

Having this known data available allows you to perform some cool tricks with SQL queries. 394 more words

Datamart

Script for renaming a database in SQL Server

Script :

ALTER DATABASE
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE
MODIFY NAME =
GO
ALTER DATABASE
SET MULTI_USER
GO 8 more words

SQL

SQL SERVER - SSMS: Index Usage Statistics, Physical Statistics & User Statistics

When I used to be in the consulting business, the most request session or topics always revolved around Performance Tuning. And whenever I talk to folks around what they want to get covered, they often get to a point of when and how to create efficient indexes in my database. 1,115 more words

SQL Authority

Maximum and Minimum values that DATETIME data type can store…

Maximum value:
9999-12-31 23:59:59.997

Minimum value:
1753-01-01 00:00:00.000

Yes, I am referring to SQL Server 

-Vijred

SQL

Why can't my business users see what they want?

Business data consumers have varying levels of ability with data.

They all know what they want, but their methods for getting it vary; from the highly skilled “Just give me the data (GMTD) and I’ll crunch it” to the “I need to know (NTK) how many customers did this, with that while it was snowing”. 264 more words

Datamart