Tags » SQL Server

How to Point in time Restore Azure SQL Database after deleting the database

Azure SQL Database has feature to restore the database to point in time when the database is live. When we have to move the database to different Server we end up deleting the database from old server, we can not perform point in time restore! 104 more words

SQL

SQL, M or Dax? - part 2

This is a post about a post about a post.  Thanks to those of you who are entering comments in the original May 12 post titled… 673 more words

Microsoft BI Platform

How to pass data between procedures using temp tables.

Problem statement. I once heard from Steven Feuerstein, an Oracle evangelist, that any given code should not be more than ten lines for easy readability and maintainability. 1,107 more words

Database Codding

SQL Server Concurrency Effects

Lost Update

Happens when one transaction update overwrites another, causing the update to be lost.

Dirty Reads

Reading uncommitted records.

Phantom Reads

Reading while another transaction is adding new record, result in different number of rows being returned. 18 more words

General

SQL Server :- Error - "Cannot resolve the collation conflict between "Latin1_General_100_BIN2" and "Latin1_General_CI_AS" in the equal to operation"

Background

Error during SQL Server Upgrade; specifically upgrade from MS SQL Server 2016 SP1 to Sp2.

Error


2018-05-18 22:27:31.36 spid4s      Creating procedure sp_sqlagent_get_perf_counters...
2018-05-18 22:27:31.37 spid4s      Error: 468, Severity: 16, State: 9. 666 more words
Microsoft

Azure SQL Database / SQL Server – Paused Index Rebuild

I was creating some demo non-clustered indexes in one of my Azure SQL Databases and received the following warning when I executed this code: 196 more words

SQL SERVER

SQL OUTPUT PUZZLE | The Assignment Puzzle - I | Advanced SQL

SQL OUTPUT PUZZLE | The Assignment Puzzle – ? | Advanced SQL

In this puzzle you have to go through the SQL statement given below and provide us the output without executing the SQL on SSMS or any other onsite SQL tool. 257 more words

T SQL Puzzles