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

Archives: December 2012

Test Hadoop cluster on vmware

SQL Server MVP Jeremiah Peschka posted 2 articles about Hadoop, which makes me be interested on the nosql skill.

I don't have much knowledge on Nosql and Linux system, so I am going to setup a testing environment on my laptop in holidays

1. download CentOS Linux setup iso file
http://www.centos.org/

2. download java jdk 1.6

Read more

4 comments, 1,487 reads

Posted in James' SQL Footprint on 29 December 2012

TempDB Destroyer

One of my previous posts, I covered how to create a really big database with just garbage data in it. Recently, I was given a task to blow up tempdb. I thought about using a similar script and tried it out. Of course it worked and it blew up…

Read more

0 comments, 514 reads

Posted in SQL Sandwiches on 29 December 2012

SQL Server 2012 Standard Edition Licensing Limits

As you might be aware, SQL Server 2012 Standard Edition has some hardware-related licensing limits that I think should be adjusted in light of the capabilities of modern, commodity server hardware.

As a DBA and consultant, I would like to see everyone running SQL Server 2012 Enterprise Edition. It has… Read more

10 comments, 3,725 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2012

SQL Server 2012 Diagnostic Information Queries (Dec 2012)

Here is the December 2012 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to a couple of the existing queries. There is also one new query at the very end, adapted from my colleague, Erin Stellato.

To go with it is…

Read more

0 comments, 566 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2012

Reblog: December 21 to December 27

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 524 reads

Posted in StrateSQL on 28 December 2012

PASSMN Presentation Materials

Last week, I presented on extended events at the Minnesota SQL Server user group (PASSMN).  The turnout was quite excellent and I expect at least a few people will be interested in the materials that were presented.

So… here they are Extended Events - Work Smarter, Not Harder -… Read more

0 comments, 445 reads

Posted in StrateSQL on 28 December 2012

Index Analysis Post Christmas Update

Last week I mentioned that I had put up a few new versions of my index analysis script.  Turns out a few people downloaded it and found some issues.  I also have been playing with it some more and noticed some quirks that were a bit irritating to me, so… Read more

0 comments, 373 reads

Posted in StrateSQL on 28 December 2012

My RSS Reader…The Great Clean Up

If you blog and call yourself a blogger then you probably have a pretty full RSS reader. Mine has been added to considerably over the years. Well I signed into my Google reader account today and I realised that there is a lot of blogs that either I don’t read… Read more

0 comments, 488 reads

Posted in The SQL DBA in the UK on 28 December 2012

SQL Server Cumulative Update

Microsoft today announced the latest round of SQL Server Cumulative Updates

SQL Server 2012 CU 5 – You can get more information here

SQL Server 2008 SP2 CU 4 – You can get more information here

SQL Server 2008 SP1 CU10 – You can get more information here

This might… Read more

0 comments, 495 reads

Posted in The SQL DBA in the UK on 28 December 2012

Closing the Results Window in SSMS

This is a guest post by David Postlethwaite.

I’ve been wondering how to do this for years. At SQL Bits and SQL Saturday the presenters make the results window disappear with a keyboard click but I could never work it out.

Well today I was working on a query and…

Read more

0 comments, 436 reads

Posted in The SQL DBA in the UK on 28 December 2012

It’s Another 24 Hours of PASS

With the upcoming PASS Business Analytics Conference, it only makes sense for there to be a 24 Hours of PASS to go a long with it.  And have no fear, that is what is coming your way on January 30, 2013.

In a bit of a departure from previous… Read more

0 comments, 534 reads

Posted in StrateSQL on 27 December 2012

I Pulled a Forest Gump

Last Friday I went for a quick run before we packed up and headed to Steamboat Springs for a week’s vacation skiing with the family. Saturday I snowboarded, came back to the condo, found no treadmill, slippery, icy conditions on the roads, and just stopped running.

No fanfare, no complaints,… Read more

2 comments, 1,143 reads

Posted in The Voice of the DBA on 27 December 2012

PASS Summit 2012 session videos online

If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash drive or view them online.  You can purchase the Regular Summit Sessions as well as the Pre-Conference Sessions.  However, if you are interested in the sessions from 2011… Read more

0 comments, 999 reads

Posted in James Serra's Blog on 27 December 2012

Predictions for 2013

I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little notice in hopes that a few of you might join in to the meme and make a few predictions for 2013.

Database related, technology related, car related, write a few… Read more

2 comments, 474 reads

Posted in The Voice of the DBA on 27 December 2012

NULL Values Impact the Performance of MAX() and MIN()

We know that we need to take special attention about NULL values while writing queries because they may lead us into writing incorrect query logics. NULLs may also affect the performance of aggregation function MAX() and MIN(). I have submitted this issue to Microsoft Connect. There are number of… Read more

3 comments, 709 reads

Posted in John Huang’s Blog on 26 December 2012

Querying the Procedural Cache: Just in Time for the New Years’


I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for peace, happiness and health for 2013.

The goal of this post is to aid in the understanding of the procedure cache and execution plans to ensure we use fewer resources,… Read more

0 comments, 836 reads

Posted in The Database Hive for SQL Server DBAs on 26 December 2012

FOR XML Clause


FOR XML CLAUSE:  Sometimes we need to data in form of XML from Database.SQL Server provide FOR XML Clause. For XML clause returns result of query as XML.There are some options with FOR XML clause
  • Raw
  • Path
·         Auto
  • Elements(can be used with raw,auto,path)
  • Explicit

You will find…

Read more

0 comments, 141 reads

Posted in Querying Microsoft SQL Server on 26 December 2012

On the Twelfth Day…

Bacon wrapped frog legs (twelve of them) for Christmas.  No more drumming for these guys!!

What could be better than bacon wrapped frog legs?  Oh yeah, more Virtual lab setup.

We will delve into setting up a SQL Cluster today.  We will also cover some high level tips for dealing… Read more

0 comments, 554 reads

Posted in SQL RNNR on 25 December 2012

Merry Christmas to all of you…

Merry Christmas to all of you….


Read more

4 comments, 462 reads

Posted in MSSQLFUN on 25 December 2012

Last Weeks Top 10 “Reading” Links #12

Happy holidays, seems this post missed coming out this morning as typically scheduled.  Thus, a late afternoon post on this Christmas Eve.

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… Read more

0 comments, 438 reads

Posted in StrateSQL on 25 December 2012

Newer posts

Older posts