Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2013

Disaster Recovery Planning

As a SQL Server DBA it is absolutely vital you regularly take backups of the databases you look after. If something goes wrong, a restore is required and there is no (valid) backup, guess who will get the blame? You really don’t want to be sitting in a meeting with… Read more

0 comments, 81 reads

Posted in The DBA Who Came In From The Cold on 26 November 2013

SQL Server Data Tools (SSDT) – October 2013 update

Since my last post about the SSDT update for August, there have been two updates, each containing one fix:

The September 2013 release has a targeted fix for the Schema Compare error when working with large display text or high DPI.

The October 2013 release contains an updated installer that… Read more

0 comments, 425 reads

Posted in James Serra's Blog on 26 November 2013

SQL Cruise competition, and the winner is …

Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win a free place on the next SQL Cruise which is taking place on the 25th January 2014 in Miami, returning on 2nd February.

In between… Read more

0 comments, 215 reads

Posted in Richard Douglas on 26 November 2013

The World Needs More A/B Testing

Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to fail? Are you ok with other people trying and failing? Or do we look at them and think, they didn’t try hard enough, they didn’t ask the right questions, I… Read more

0 comments, 95 reads

Posted in SQLAndy on 26 November 2013

Review: The Year Without Pants

The Year Without Pants by Scott Berkun is about a former manager/now speaker and writer going to work for WordPress for a year. It was a must-read for me; I’m a fan of the authors writing as well as WordPress.

It’s supposed to about the future of work and maybe… Read more

0 comments, 150 reads

Posted in SQLAndy on 26 November 2013

Setting your predicate arguments at run time Part: 2 MultiSelect

 

Introduction

A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access Layers. The user obtained his or her data by submitting an argument to a parameter. In our case, there were three of these parameters, thus requiring 3 different… Read more

0 comments, 252 reads

Posted in Simon Says on 26 November 2013

Things I've Learned In Regards To Fill Factor:Quick Tips

I don't have much today... It's been a good week so far. I think I'm becoming a bit obsessed with this Fill Factor thing. This will be short... I swear. ^.^

Negatives to changing Fill Factor from 100 (also known as 0 )

1) Backups are bigger and take longer…

Read more

0 comments, 185 reads

Posted in DBA On The Go on 26 November 2013

SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004

Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from the Field series. While installing SQL Server many DBA takes pride that they were able to install SQL Server without…

Read more

0 comments, 306 reads

Posted in Coffee and SQL on 26 November 2013

How Hekaton will impact the RTO of your database

(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)

Over the weekend I have encountered a very interesting side effect of Hekaton in SQL Server 2014, which unfortunately impacts your RTO (Recovery Time Objective) of your database in a negative… Read more

0 comments, 229 reads

Posted in Klaus Aschenbrenner on 25 November 2013

Skills I Used Last Week #2

Back in September I wrote the first version of Skills I Used Last Week, so I thought I’d loop back to see if I was doing anything new lately. The window is really the last few weeks, but I thought I’d stick with the title for now, for continuity! Read more

0 comments, 198 reads

Posted in SQLAndy on 25 November 2013

Last Weeks Top “Reading” Links #59

Monday morning and it’s time for weekly round-up.  If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting.  While these links aren’t the answer to life, the universe, and everything, they do share a few… Read more

0 comments, 318 reads

Posted in StrateSQL on 25 November 2013

What Are Your Servers Doing While You’re Sleeping?

Well, do you know? You’re the DBA, the guy in charge, the guy who gets pounced on first thing in the morning with complaints of “my report took FOREVER to run last night, why?”, or “customers are saying the web site was really slow at 3:00am this morning, why?”. You’re… Read more

6 comments, 303 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 25 November 2013

Finding the metadata for a query

You know I occasionally find it interesting how I learn new things. I was running through a practice test for the 70-461 and one of the questions had an odd command as one of the possible answers.

SET FMTONLY ON

Not something I had ever seen before, and as I… Read more

0 comments, 267 reads

Posted in SQLStudies on 25 November 2013

Reverse or Mirrored Bar Chart in SSRS

There are some pretty charts out there and most of them can be done in Reporting Services. There is one type of chart I had someone ask for that is not natively built in to SSRS. But with a little manipulation you can get the look you want. Here is…

Read more

0 comments, 226 reads

Posted in Mike Davis SQL on 25 November 2013

SQL Server – Kill all sessions using database

Before an existing database can be restored, there should be connections using the database in question. If the database is currently in use the RESTORE command fails with below error:

Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in use.
Read more

2 comments, 336 reads

Posted in SQL and Me on 25 November 2013

Stuff VS Replace function in SQL Server



Stuff function: - This function is used to replace string from the given start position, passed as 2nd argument with string passed as last argument. In Stuff function, 3rd argument defines the number of characters which are going to be replaced.

 
Syntax:-

STUFF ( character_expression , start , length…

Read more

3 comments, 6,317 reads

Posted in Vivek's SQL Notes on 25 November 2013

Case Statement/ Expression in SQL Server


Case Statement/ Expression in SQL server 
 
Sometimes we need to get one result output from multiple possible outcomes based on the evaluation of some expression. This expression can be a simple case expression which compares an expression with a set of Expression/Values to determine the result or it can…

Read more

1 comments, 565 reads

Posted in Vivek's SQL Notes on 25 November 2013

Usage grouped by Database: Quick Tips

Quick script just to give you an idea of how your databases are being used. Mainly useful for exploring.

select db.name as DatabaseName,
sum(usage.user_seeks) as UserSeeks,
sum(usage.user_scans)as UserScans,
sum(usage.user_lookups) as UserLookups,
sum(usage.user_updates) as UserUpdates
from sys.dm_db_index_usage_stats usage
inner join sys.databases as db on db.database_id = usage.database_id
group by db.name

Hey…

Read more

0 comments, 188 reads

Posted in DBA On The Go on 25 November 2013

An application error occurred on the server running on SQL server

Recently one of my application website went down.

 

I checked all the basic connectivity troubleshooting and seem everything was looking and working fine. Finally, I found the problem with the browser service but that’s also in running state.

Error from the event viewer:

 

 

The quick solution is… Read more

0 comments, 267 reads

Posted in SQL Server Blog Forum on 25 November 2013

Setting your predicate arguments at run time

 

Introduction

A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access Layers. The user obtained his or her data by submitting an argument to a parameter. In our case, there were three of these parameters, thus requiring 3 different… Read more

0 comments, 237 reads

Posted in Simon Says on 24 November 2013

Newer posts

Older posts