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

Archives: November 2012

Creating an empty table from a SELECT statement

I’m in the middle of reading a good book on DMVs, “SQL Server DMVs in Action” http://www.manning.com/stirk by Ian W. Stirk. In it he points out that you can create a temporary table from a query and use it to store the data from multiple runs of the query. This… Read more

10 comments, 4,482 reads

Posted in SQLStudies on 26 November 2012

Treat Yourself to Knowledge

There’s a one day sale going on at Apress today, 11/26/12. All their eBooks are $15. This means you can start learning about query performance tuning, or get started as a DBA, or explore a whole range of topics by different authors presenting some of the best in… Read more

0 comments, 1,011 reads

Posted in The Scary DBA on 26 November 2012

Free One Week Passes to PluralSight

As you may know, SQLskills has been creating a lot of great new courses about SQL Server for Pluralsight. Nearly half of all of the SQL Server courses on Pluralsight have been produced by the SQLskills team, and more are on the way.

Just in case you would like… Read more

1 comments, 1,153 reads

Posted in Glenn Berry's SQL Server Performance on 26 November 2012

When row estimation goes wrong

Whilst working at a client site, I hit upon one of those issues that you are not sure if that this is something entirely new or a bug or a gap in your knowledge.

The client had a large query that needed optimizing.  The query itself looked pretty good, no… Read more

0 comments, 2,172 reads

Posted in Dave Ballantynes blog on 26 November 2012

Cyber Monday: Performance Indexing Book is $15

Ever thought you could learn a little bit more about indexing?  Now here’s the perfect opportunity.  Today only you can purchase Expert Performance Indexing for SQL Server 2012 for $15 as an e-book directly from APRESS.

That’s right!  Only $15.  This Monday… as in today… the holiday season has… Read more

0 comments, 748 reads

Posted in StrateSQL on 26 November 2012


I like to repost this blog about once a  year, because you really really need to know about windowing functions. So, happy November! Here’s a quick summary of OVER and PARTITION BY (windowing functions, “new” in SQL 2005), for the uninitiated or forgetful… OVER OVER allows you to get aggregate…

Read more

0 comments, 4,458 reads

Posted in SQL Awesomesauce on 26 November 2012

SQLIO Analyzer Latency Divide by Zero Issue Corrected

A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one of the calculations was showing on the SQLIO Analyzer Latency worksheet in the Excel file. The updated analyzer is located here.

Thanks Daniel!  I really appreciate the… Read more

2 comments, 1,135 reads

Posted in Technobabble by Klee from @kleegeek on 26 November 2012

Last Weeks Top 10 “Reading” Links #8

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. PASS Summit 2012 in a…

Read more

0 comments, 604 reads

Posted in StrateSQL on 26 November 2012

Choose specific folders to sync with SkyDrive

Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to your device locally. That is cool because you can still work on your files even when you’re offline.

The thing is I don’t need all the… Read more

0 comments, 900 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 26 November 2012

Ybor City Farmers Market, Dogs, Kids, and Observations

Last weekend I was in Tampa for SQLSaturday #168 and made sure to make some time for family. The most interesting thing we did this time was to go to the Ybor City Saturday Market. Ybor City is on the north side of Tampa, and the market is maybe  a… Read more

0 comments, 861 reads

Posted in SQLAndy on 26 November 2012

Can’t access Operations or Applications tabs from Central Admin WSS 3.0 SP 2

Hey Friends,

Sometime when we try to access central administration and certain tabs like operation and Application management we face issues. Certain probably error messages are:

Error message 401.2.:Unauthorized: Logon failed due to server configuration. ” .

You can resolve these type of error by:

The cool thing… Read more

4 comments, 454 reads

Posted in AshishSharePointBlog on 26 November 2012

Reducing the size of the distribution database & improving transactional replication performance: Part 2

The impact of having data sitting in the distribution database that doesn’t need to be there can be significant.  The aim of this series of articles is show you how to keep the distribution database as small (and efficient) as possible, and to keep the impact of the clean-up job… Read more

4 comments, 2,595 reads

Posted in Chris Jenkins' Blog on 26 November 2012

Time Pass With Transaction Log - Part 4 DDL

In this article,  We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.

Our focus is to observe schema level impacts in lower level.


Lets create a simple table named tEmployee in a sample database EXPLORE_TLOG


-- Drop…

Read more

0 comments, 3,139 reads

Posted in LivingForSqlServer on 26 November 2012

Every ebook from Apress for $15

Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15 on Nov. 26. Here is a list of books I’m purchasing and recommend to you.

SQL Server 2012 Integration Services Design Patterns

I already bought this, and I love… Read more

0 comments, 901 reads

Posted in Sam Vanga on 26 November 2012

Explore file physical structure - IAM

1. Create sample db

use master
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 2048KB , FILEGROWTH = 1024KB )
( NAME = N'test_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test_log.ldf' , SIZE = 1024KB , FILEGROWTH =…

Read more

0 comments, 936 reads

Posted in James' SQL Footprint on 25 November 2012

Getting Nexus 7 Connected To Windows 7

Have trouble getting your new Nexus 7 connected to Windows so you can move some media files over?

Install the drivers first from Asus.

Then, you need to disable USB Debugging in the Nexus by enabling the Developers menu. Where is it? It’s hidden by default. You have to… Read more

0 comments, 718 reads

Posted in Technobabble by Klee from @kleegeek on 24 November 2012

Using REST API in SSIS to Extract Top 100 User Tweets


The growing popularity of the use of social networks by businesses indicate a possible change in ETL requirements. Part of this change is that developers had to revise existing ETL model such that it caters for sourcing of data off the internet in addition to the traditional flat files… Read more

4 comments, 377 reads

Posted in on 24 November 2012

IIS Express Quickie Command-line

This is a reminder to my future self for how to quickly start IIS Express from the command-line on 64-bit Windows 7 or 8 assuming you already have IIS Express installed using the defaults.

  1. Open admin command line.
  2. cd\Program Files (x86)\IIS Express
  3. iisexpress /path:c:\YourApplicationRootFolder /port:WhateverPortNumber

Note: You can also specify… Read more

1 comments, 3,168 reads

Posted in New York City .NET on 24 November 2012

Reblog: November 16 to November 22

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, 622 reads

Posted in StrateSQL on 23 November 2012

Playing with Cython

Intro Recently, I came over Cython and started experimenting with it.  After some basic testing, I found several things of interest. Used properly, Cython is a fantastic way to speed up Python code. It is extremely liberal in what Python … Continue reading

Read more

5 comments, 992 reads

Posted in SQLWise on 23 November 2012

Newer posts

Older posts