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

Archives: January 2013

How to Remove (Undo) Table Partitioning

I have seen plenty of articles and blog posts out there for how to setup and implement table partitioning, but very few for removing or undoing it.  So I thought I would cover a few ways to accomplish this while still preserving the data.

There could be many reasons for…

Read more

3 comments, 4,203 reads

Posted in Everyday SQL on 29 January 2013

Are You A Technical Expert or Manager?

Expert or Manager? Why not both.

Are you a Technical Expert or a Manager? You certainly cannot be both.

At least that’s the consensus that I frequently encounter. A belief that you can only be one or the other but definitely not both.

This is outdated thinking. It sounds to… Read more

0 comments, 894 reads

Posted in John Sansom - SQL Server DBA in the UK on 29 January 2013

SQL Server Silent unattended installation using configuration file

1) Open Installation Wizard

Open Installation Wizard

2) Select Feature You want to install

Select Feature You want to install

3) Provide installation configuration

Provide installation configuration

4) Now that you have the configuration file, copy it to your own folder or network share where you want to start the… Read more

5 comments, 2,781 reads

Posted in MSSQLFUN on 29 January 2013

Day 23 of 31 Days of Disaster Recovery: Restoring Differential Backups With New Files

It’s day 23 of my 31 Days of Disaster Recovery series, and today’s blog post is inspired from an email i received in response to day 20′s blog post The Case of the Backups That Wouldn’t Restore. A friend shared a story with me via email about a partial restore…

Read more

SQL Server

What is SQL Server?
Microsoft SQL Server is Relational database management system (RDBMS) developed and owned by Microsoft. It is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another…

Read more

0 comments, 357 reads

Posted in Querying Microsoft SQL Server on 28 January 2013

Granting Permission to Grant Permissions

I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a view and you wanted to allow a user to grant permissions to this view to other users.

It’s not a weird edge case, but it’s just not one I’ve normally… Read more

0 comments, 2,422 reads

Posted in The Voice of the DBA on 28 January 2013

"Auto update statistics" option on tempdb

"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some case.Today when I tested script, I found the index created on the temp table didn't work because of "Auto update statistics" disabled.

here is the script.

USE [master]

Read more

0 comments, 1,890 reads

Posted in James' SQL Footprint on 28 January 2013

New Year Aspirations – Annette Allen – WiT

Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be really hectic. I really do appreciate your time!

Before we start on the main part of the interview, tell us all a little about yourself.

I’m married to Jonathan Allen… Read more

0 comments, 834 reads

Posted in Richard Douglas on 28 January 2013

Last Weeks Top 10 “Reading” Links #17

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

  1. The Other Person is Never…

Read more

0 comments, 899 reads

Posted in StrateSQL on 28 January 2013


Last month I mentioned that I’d like to start including Oracle stuff on this blog.  I’m getting back into that world again as part of the new job, and this blog has always been, first and foremost, a way for me to document and share what I’m learning.  Now I… Read more

0 comments, 641 reads

Posted in Cleveland DBA on 28 January 2013

I’ll Meet You Half Way–Compromising To Win

Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it. It takes practice and more practice, listening deeply to what the other side says and doesn’t say, and looking inward to separate pride from what matters. That led, for me,… Read more

0 comments, 731 reads

Posted in SQLAndy on 28 January 2013

Model database

Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins, msdb is jobs and backups, tempdb is for temp tables and sorting. Obviously there is a lot more to each of these, but that is the absolute basics, and… Read more

0 comments, 865 reads

Posted in SQLStudies on 28 January 2013

SSIS 6 Million Rows in 60 Seconds using standard laptop

SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could be improved by making several simple changes or minor hardware upgrades.

There are many factors that need to be taken into consideration and it would be nice to do a…

Read more

0 comments, 4,665 reads

Posted in Katie and Emil on 28 January 2013

How to find and install common IFilters||For Search||Crawl

Friends, As covered in one of my previous blog:

How crawl works in SharePoint ||How indexing work||Basic concept .

We were discussing about ifilters , so How to get these ifilters and what are the various steps need to be taken in the configuration of ifilters? I will work with… Read more

6 comments, 989 reads

Posted in AshishSharePointBlog on 28 January 2013

Consider All the Possibilities When Troubleshooting

When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's time to expand to the unlikely ones. This is true even if the evidence would seem to rule out a possibility or if what you have for facts seem to… Read more

1 comments, 1,587 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 28 January 2013

Currency Conversion in Tabular Model Using DAX

Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the Leaves function in MDX).  I documented the implementation in a few blog posts:

I have now also implemented currency… Read more

0 comments, 2,804 reads

Posted in Salvo(z) SQL on 28 January 2013

DBCC Commands for SQL Server

DBCC Commands:
DBCC commands are most useful for performance and troubleshooting.
The DBCC Commands are used in Maintenance, Informational use, Validation on a database, index, or file group. Theses commands are helpful to check physical and logical consistency of database. Some DBCC statements fix errors automatically. Here I am showing…

Read more

0 comments, 1,021 reads

Posted in Querying Microsoft SQL Server on 28 January 2013

Central Subscriber Model Explained

The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single publisher replicating to one or more subscribers.  Another replication model, which is sometimes overlooked, is the Central Subscriber model, which is comprised of multiple publishers replicating to one subscriber using… Read more

5 comments, 1,629 reads

Posted in SQLREPL on 28 January 2013

Bananas For SQLSaturday

I was catching up on reading today and saw that Instructables had a how-to on “tattooing” a banana, also called banana oxidation art. I had bananas available, so I printed SQLSaturday on some paper, taped it to the banana, and starting punching holes with a straight pin. It… Read more

0 comments, 839 reads

Posted in SQLAndy on 28 January 2013

Day 22 of 31 Days of Disaster Recovery: Which DBCC CHECK Commands Update Last Known Good DBCC

The end of the day is quickly approaching as I finish this blog post. This is day 22 in my series 31 Days of Disaster Recovery, and I want to examine which DBCC CHECK commands update the last known good DBCC check that is tracked in the header of the…

Read more

Newer posts

Older posts