Tags » T-SQL

SQL SERVER - Database Stuck in Restoring State

Here is a one of the very common question I keep on getting via email.

“I just restored all the backup files of my database, however, my database is still stuck in restoring state. 122 more words

SQL Authority

SQL SERVER - The Why of BIML - Notes from the Field #051

: This is a 51th episode of Notes from the Field series. In one of the earlier blog post we discussed about BIML and lots of people asked what is actually BIML and why one should use it.  1,161 more words

SQL Authority

How Can Query Plans Help Us?

In T-SQL Query Plan Analysis Prelude we looked at some common reasons why queries can sometimes go on a snail speed contest and that query plans are one of the ways we can know how to transform those carefree molluscs into caffeinated cheetahs. 848 more words


Force only certain values to be unique

I thought of something rather interesting the other day while answering a question asking for help with some table structures.

In a similar situation to the questioner let’s say we have a Baseball team. 947 more words

Microsoft SQL Server

Temporary Tables and Table Values #1


V tomto clanku jsou jen priklady pouziti:

Temporary Table

IF OBJECT_ID('tempdb..#kreditTemplates') is not null
drop table #kreditTemplates
create table #kreditTemplates (id integer, name varchar(100))
99 more words