Archives: November 2012
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
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
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
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
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
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
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
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
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
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
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
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.
1. CREATE TABLE
Lets create a simple table named tEmployee in a sample database EXPLORE_TLOG
-- Drop…Read more
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.
I already bought this, and I love… Read more
1. Create sample db
CREATE DATABASE [test] ON PRIMARY
( 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 =…
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
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
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.
- Open admin command line.
- cd\Program Files (x86)\IIS Express
- iisexpress /path:c:\YourApplicationRootFolder /port:WhateverPortNumber
Note: You can also specify… Read more
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