SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2014

Maximum number of rows per data page and minimal record size (SQL Server storage internals)

Maximale Anzahl Zeilen je Datenseite und minimale Datensatzgröße

In einer meiner letzten Master-Classes tauchte die nicht ganz ernste aber dennoch interessante Fragestellung auf:

Wie viele Zeilen passen eigentlich maximal auf eine Datenseite? – wenn die Datensätze/Records so klein wie möglich sind.

Zunächst, Part 1, was ist der kleinstmögliche…

Read more

0 comments, 1,251 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 29 October 2014

Add Database File on Database invloved in DB Mirroring


Database Mirroring works on transaction logs. It applies transaction logs from Principle to Mirror. But Operation like addition of file is no log operation because of that file not be added to Mirror automatically.

Steps to Add Database File on Database involved in DB Mirroring :-

1) Break the…

Read more

1 comments, 550 reads

Posted in MSSQLFUN on 29 October 2014

Introduction To SQL Server Joins with Example

In SQL Server database, if records of two or more tables have to be combined, then the Join clause is used. It is a means that combine same fields of the tables can be combined using their common values. There are five types of join clause available for ANSI standard…

Read more

0 comments, 1,789 reads

Posted in Zora's SQL Tips on 29 October 2014


I am extremely excited to share that the first event of Porto.Data is all set for the 20th of November 2014.
Porto.Data is a new User Group & a Community dedicated to the Microsoft Data Platform that will be operating in the northern Portugal – Oporto area specifically.

We have… Read more

0 comments, 45 reads

Posted in Niko's blog on 29 October 2014

SQL Server – Failed to bring availability group ‘[availability group name]’ online

I have been noticing one very common error that occurs while trying to failover an Availability Group in SQL Server 2012 AlwaysON setup. The Availability Group fails to come online during a fail over process. Here is the snippet of the error message. Failed to bring availability group ‘availability_group‘ online.…

Read more

4 comments, 1,077 reads

Posted in SqlServerZest.com - SQL in simple style on 28 October 2014

How to take differential backup ? TIP #67

We were discussing backup from last few post. Now lets take a look one more feature of backup which is differential backup.
Differential backup  is backup after last full backup. Before taking Differential backup  it is a mandatory condition to take full backup.
Differential backup can speed…

Read more

0 comments, 375 reads

Posted in Rajat Jaiswal-337252 on 28 October 2014

Ghosts – an eXtrasensory Experience

This is the last article in a mini-series diving into the existence of ghosts and how to find them within your database.

So far this has been a fun and rewarding dive into Elysium to see and chat with these entities.  We have unearthed some means to be able to… Read more

5 comments, 573 reads

Posted in SQL RNNR on 28 October 2014

Session: Introduction to Powershell Cmdlets for DBAs

I’ve given my new Powershell Cmdlets for DBAs session a handful of times now, and just realized I haven’t blogged about it! Download the session recording here Download the code file here Abstract: You’ve been hearing about this newfangled craze, and it’s time to learn exactly why it’s called POWERshell.…

Read more

1 comments, 730 reads

Posted in SQL Awesomesauce on 28 October 2014

Im At Summit Now What?

Pass Summit 2011 – Photo Provided by Pat Wright

We are a week out from PASS Summit 2014 and there will be many there attending for the first time. You are in the same boat I was in back in 2011. To be quite honest, I’ve never seen or attended… Read more

1 comments, 455 reads

Posted in The SQL Professor on 28 October 2014

Getting back to basics

I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time, I told myself there’s still a lot… Read more

4 comments, 429 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 28 October 2014

Outlier Detection with SQL Server, part 2.1: Z-Scores

By Steve Bolton

…………Using SQL Server to ferret out those aberrant data points we call outliers may call for some complex T-SQL, Multidimensional Expressions (MDX) or Common Language Runtime (CLR) code. Yet thankfully, the logic and math that underpin the standard means of outlier detection I’ll delve into in… Read more

2 comments, 1,764 reads

Posted in Multidimensional Mayhem on 28 October 2014

Default Framing–Window Functions

I’ve been playing with the window functions in T-SQL a bit, and I find them very interesting. They certainly solve some problems very well, in a way that’s much easier than has been available in T-SQL.

However there are some things you need to understand. One of these things is… Read more

2 comments, 7,075 reads

Posted in The Voice of the DBA on 27 October 2014

Last Weeks Top “Reading” Links #106

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

1 comments, 344 reads

Posted in StrateSQL on 27 October 2014

Minion Reindex is here

We released Minion Reindex by MidnightDBA unto the world, accompanied by a press release on SQLServerCentral.com, and people have responded so incredibly positively. We’re quite literally thrilled. Webinar Today! Before I get to anything else: set up an alert for our Minion Reindex Intro Webinar TODAY (Monday, October 27, 2014)…

Read more

1 comments, 612 reads

Posted in SQL Awesomesauce on 27 October 2014

A script to list the DTS connection information for every package on the instance.

For those of you who have moved completely to SQL 2012 & 2014, Lucky you and don’t judge! For the rest of us who are still dealing with DTS packages I’m going to do a couple of posts on the subject. To start with here’s a script for collecting all… Read more

0 comments, 459 reads

Posted in SQLStudies on 27 October 2014

Cumulative Update – 4 for SQL Server 2014 RTM Is Now Available !

The 4thcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 4 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

Those who are facing severe issues with their environment, they can plan to test… Read more

0 comments, 655 reads

Posted in MSSQLFUN on 27 October 2014

Remove Witness from SQL Server Database Mirroring

1) After connecting to the principal server instance, Right-click the database & go to properties. Select Mirroring from left side option.

2) To remove the witness, delete its server network address from the Witness field.

3) Click Ok to confirm.

You can also perform the same action by below T-SQL. Read more

1 comments, 6,395 reads

Posted in MSSQLFUN on 27 October 2014

Drop and Recreate all Synonyms

Had a quick job the other day restoring a pair of databases under different names which is all straight forward enough, but each database in the pair uses quite a few synonyms to access objects in the other database. So with the pair of databases restored under new names, a… Read more

0 comments, 7,839 reads

Posted in SQL Server Rocks! on 27 October 2014

Drop and Recreate all Synonyms

Had a quick job the other day restoring a pair of databases under different names which is all straight forward enough, but each database in the pair uses quite a few synonyms to access objects in the other database. So with the pair of databases restored under new names, a… Read more

0 comments, 33 reads

Posted in SQL Server Rocks! on 27 October 2014

Newer posts

Older posts