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

Latest Blog Posts

SQL #58–Where are my own templates in SQL Server Management Studio 2012

The secrete SQLFile.sql

We are all so used to clicking on the New Query icon (or the keyboard shortcut Ctrl+N). We know it will open a new query window in SSMS, an empty query window that is, but many of us never knew that something else was designed to happen… Read more

0 comments, 50 reads

Posted in Sherry Li's BI Corner on 27 January 2015

T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable

On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance.  There are many ways to get the result. This post gives you an idea and SQL in which undocumented SP’s being called  “sp_MSforeachdb and sp_MSforeachtable”.

The above undocumented SP’s  iterate through… Read more

0 comments, 48 reads

Posted in PowerSQL By Prashanth Jayaram on 26 January 2015

Clustered Columnstore Indexes – part 47 (“Practical Monitoring with Extended Events”)

Continuation from the previous 46 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/ This post is a continuation from the the post 44, where I have listed different Extended Events. In this post I will go into practical examples with detailed explanations on how…

Read more

2 comments, 70 reads

Posted in Niko's blog on 26 January 2015

Downloading SQL Saturday data

I wanted to find out how many SQL Saturday’s I’d spoken at and how I ranked with others. I got a spreadsheet from Kendal Van Dyke at one point, but it was quickly out of date. However Kendal mentioned that there was an XML document on the site, and I… Read more

0 comments, 87 reads

Posted in The Voice of the DBA on 26 January 2015

An Overview on SQL Server Checkpoints

Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed to perform changes or modifications to databasepages in buffer cache (memory) first and after some processing the modification are written on… Read more

0 comments, 82 reads

Posted in Basit's SQL Server Tips on 26 January 2015

My First Board Meeting

Parents, you know that feeling you get after you’ve brought home that brand new baby (or in my case, babies) where you suddenly say to yourself, “Oh damn. What have I done?” Yeah, that’s my feeling after my first board meeting. But let me give you a run-through of how… Read more

2 comments, 60 reads

Posted in The Scary DBA on 26 January 2015

SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be fun (and good practice) to do them. Another major benefit is that it will force me to move out of my normal comfort zone. For… Read more

0 comments, 59 reads

Posted in SQLStudies on 26 January 2015

DBTA – 6 Reasons to Think About Upgrading to SQL Server 2014

 

If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After… Read more

1 comments, 64 reads

Posted in Kevin E. Kline on 26 January 2015

SSRS Farm to Scale-Out Performance

SSRS Farm Overview

Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and 2014.  SQL Server allows for the deployment of 2 or more servers running SQL Server Reporting Services to increase the performance of your reporting environment.

SSRS stores its data… Read more

0 comments, 61 reads

Posted in Business Intelligence and Enterprise Architecture on 26 January 2015

SQL Script to find the missing indexes

Performance tuning in SQL is important exercise and index creation is an important part of it. Below script will help in finding the missing indexes. Once you create these indexes, it will help in improving the Performance.

SELECT db_name(d.database_id) dbname

, object_name(d.object_id) tablename
, d.equality_columns
, d.inequality_columns
, d.included_columns
,'CREATE INDEX [missing_index_' +…

Read more

0 comments, 72 reads

Posted in Vivek's SQL Notes on 25 January 2015

new LinkedIn article

Hi everyone,

I just published a new LinkedIn article entitled “Let It Go”. Please check it out!

https://www.linkedin.com/pulse/let-go-chuck-boyce


Read more

0 comments, 58 reads

Posted in @chuckboycejr on 25 January 2015

SQL SERVER - Data types

In relational database, we store data in tabular form where data is divided into columns. Each column has a name and a data type which shows what type of data is going to store in that column. Below are the data types which are mostly used in SQL server. 

CHARACTER(n)   

Read more

0 comments, 67 reads

Posted in Vivek's SQL Notes on 25 January 2015

SQL Server - Convert() function

Convert () function in SQL Server to convert an expression from one data type to another data type

Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

Convert functions is usually used with date/time data type to convert a date in different formats. Below examples…

Read more

0 comments, 61 reads

Posted in Vivek's SQL Notes on 24 January 2015

Video: A Better Way to Reindex

Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to download the free Minion Reindex tool.

Read more

1 comments, 1,280 reads

Posted in SQL Awesomesauce on 23 January 2015

I’m A Friend Of Red Gate For 2015

I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate program for 2015. For those of you who are not SQL folk, you can stop reading now – Red Gate is a company who makes top-shelf products for working with… Read more

0 comments, 74 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 23 January 2015

Friday Followup For January 23, 2015

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC To Fix Index Corruption
  • Don’t Get Slimed…

Read more

0 comments, 80 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 23 January 2015

SQLPort’s new image

After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image and with a lot of new projects that we are targeting to develop in the future. For years we have…

Read more

0 comments, 106 reads

Posted in Niko's blog on 22 January 2015

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example also retrieve the data matching values[DimTypes (WIDTH or Height)].

‘<dimensions>

<dimension name=”width”  value=”12.77″/>

<dimension name=”height”  value=”0.14″/>

<dimension name=”depth”      value=”12.92″/>

</dimenstions>’

Download SQL :-  https://gallery.technet.microsoft.com/SQL-Querying-XML-f700bbb0

 SQL:-

DECLARE @xml XML
SELECT @xml = 
'<dimensions>
  <dimension…

Read more

0 comments, 1,029 reads

Posted in PowerSQL By Prashanth Jayaram on 22 January 2015

Looking Out for Others Helps You Lead


I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go to sit down and notice the seat to my left has water on the seat. Not so deep that it is a puddle. 5 to 10 big drops. Enough that…

Read more

0 comments, 87 reads

Posted in SQLBalls on 22 January 2015

Older posts