SQL Server

SQL Server Community

SQL Server Blogs

prashanthjayaram
Follow /26 Jan 2015 at 8:03pm / SQL Server

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...
24 0 /
Basit A. Farooq
Follow /26 Jan 2015 at 5:54pm / SQL Server

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...
27 0 /
Kenneth Fisher
Follow /26 Jan 2015 at 1:00pm / SQL Server

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 example...
78 0 /
Kevin Kline
Follow /26 Jan 2015 at 1:00pm / SQL Server

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...
66 0 /
derekewilson
Follow /26 Jan 2015 at 12:35pm / SQL Server

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...
27 0 /
Nakul Vachhrajani
Follow /25 Jan 2015 at 8:45pm / SQL Server

#0352 – SQL Server – Working with Temporary Tables (L100) – Scope

In this post, I provide a Level 100 primer on the scope related considerations for local temporary tables. While I have written about temporary tables a lot in the past (and the same has also been done by other writers), there are some questions that...
36 0 /
Jen Stirrup
Follow /24 Jan 2015 at 12:19am / SQL Server

Free PASS Business Analytics Conference webinars on 3rd Feb. Join our BA Marathon!

Free PASS Business Analytics training folks! PASS are holding a BA Marathon in the lead up to our Business Analytics conference in April in Santa Clara, CA. Top Business Analytics speakers free online event for our ‪#‎ PASSBAMarathon‬ include: Jen...
262 0 /
Jen McCown
Follow /23 Jan 2015 at 8:48pm / SQL Server

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.
58 0 /
Tracy McKibben
Follow /23 Jan 2015 at 1:00pm / SQL Server

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...
53 0 /
NickyvV
Follow /23 Jan 2015 at 7:30am / SQL Server

NetFx3 Error While Installing SQL Server 2012 SP1 on Windows 8 VM

A while ago I was looking for a VM with SQL 2012 installed on it (and all the other BIDS and pieces :) because I was about to start learning for my MCSE and needed some serious SSAS training. Because I couldn't find one I decided to create one myself...
47 0 /
prashanthjayaram
Follow /22 Jan 2015 at 8:59pm / SQL Server

SQL- Querying XML attributes from XML Column

Read XML column attributes in to two columns DimType and Dimvalue  from the below example ‘<dimensions> <dimension name=”width”  value=”12.77″/> <dimension name=”height”  value=”0.14″...
64 0 /
Thomas LaRock
Follow /22 Jan 2015 at 6:39pm / SQL Server

Using Templates With SQL Server Management Studio

I love learning new things. I feel like a kid again at times, my eyes get wide as I imagine new possibilities using whatever things it is I have found. This is how I felt last week when I came across a feature of SQL Server Management Studio (SSMS) that...
71 0 /
Colleen Morrow
Follow /22 Jan 2015 at 3:00pm / SQL Server

Exam Prep 70-463: Data Flow Destination Adapters

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012.  So far, we’ve covered: Tables and Schemas in the data warehouse Dimensions and...
68 0 /
Stuart Ainsworth
Follow /22 Jan 2015 at 12:29pm / SQL Server

New blog post on SQL Authority!

Very honored to be today’s guest blogger at Pinal Dave’s blog Journey to SQL Authority; check out my post here: http://blog.sqlauthority.com/2015/01/22/sql-server-the-dba-goes-to-mars-maintenance-architecture-research-and-support-notes-from...
530 0 /
Rohit Garg
Follow /22 Jan 2015 at 12:24pm / SQL Server

How to install standalone SQL Server 2012 instance ?

Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition from right 2) Click Ok to cont., In case of any failure, you need to fix that...
128 0 /