360sqldba.com

rutherfordtx.com

Rutherford's SQL Blog: September 2011

http://www.rutherfordtx.com/2011_09_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Wednesday, September 7, 2011. Beginning SQL #4 - Data Recovery. Last time I said I was going to talk about Creating and Modifying databases. Well, I lied. I re-read the chapter of my book and just wasn't feeling it. Instead I decided to skip ahead to data recovery. Today we are going to talk about the recovery model in SQL Server and your options for backing up your database. Using the full recovery model, SQL server logs all database transa...

rutherfordtx.com

Rutherford's SQL Blog: June 2011

http://www.rutherfordtx.com/2011_06_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Wednesday, June 15, 2011. Beginning SQL #1 - SQL Server. SQL 2008 Server Services. SQL Server 2008 is made of seven main services. Not all of these services are required and some aren't even installed unless you do a full install. Below is a list of these services and a brief description of each one. SQL Server Database Engine Service. SQL Server Agent Service. SQL Server Analysis Service. The Analysis Service (SSAS) adds data mining and OLA...

rutherfordtx.com

Rutherford's SQL Blog: April 2011

http://www.rutherfordtx.com/2011_04_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Thursday, April 28, 2011. Finding The Top One Value Per Group. I ran into an issue the other day where I had a table like this:. SELECT TOP(1) id, name. ORDER BY comment time desc. But you get the following error:. Msg 8120, Level 16, State 1, Line 63. Column 'dbo.table1.id' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. SELECT MAX(comment time) as comment time, name. Nobody ...

rutherfordtx.com

Rutherford's SQL Blog: TempDB - Round Robin and Proportional Fill

http://www.rutherfordtx.com/2015/07/tempdb-round-robin-and-proportional-fill.html

My lessons in moving from a Procedural to a Set Based Attitude. Wednesday, July 1, 2015. TempDB - Round Robin and Proportional Fill. The discussions ended up in two different camps. TempDB would allocate pages in the first larger file until the free space was equal to the three smaller files then the round robin would continue. The allocations would still be handled in a round robin fashion with the larger file just getting more so that they would fill up evenly (from a percentage standpoint). SET @x = 1.

rutherfordtx.com

Rutherford's SQL Blog: August 2011

http://www.rutherfordtx.com/2011_08_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Monday, August 15, 2011. Back to Basics - ACID Properties. I was reading the Editorial from my DatabaseWeekly.com. Newsletter by Steve Jones ( Blog. The gist of the article was how knowledge is use-it-or-lose-it, the longer you go without using a skill the less of it you remember. One of his links was to an excellent article by Michael Swart ( Blog. ACID Properties by Example. Labels: Back to Basics. Friday, August 5, 2011. The answer is tha...

rutherfordtx.com

Rutherford's SQL Blog: October 2012

http://www.rutherfordtx.com/2012_10_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Monday, October 29, 2012. PowerShell and SQL: Presentation Materials. I gave my first SQL Presentation this month at our local SQL user group here in Austin, CACTUSS. I had a great time giving the presentation and I want to thank everyone who came out to see me. Below are the files from my presentation. Regular blog posts will resume next week. Friday, October 12, 2012. PowerShell and SQL - Getting Data in and out. NOTE: I am assuming that y...

rutherfordtx.com

Rutherford's SQL Blog: September 2012

http://www.rutherfordtx.com/2012_09_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Wednesday, September 26, 2012. PowerShell and SQL - SQLPSX. You can download the modules for SQLPSX from the codeplex website: http:/ sqlpsx.codeplex.com/. Once you download the file and run it, the SQLPSX modules will be added to your modules sub-directory of your Windows PowerShell folder (usually located under My Documents). In order to use the modules you have to import them into PowerShell. You will get a result that looks like this:.

rutherfordtx.com

Rutherford's SQL Blog: July 2015

http://www.rutherfordtx.com/2015_07_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Thursday, July 16, 2015. Replication - To init or not to init that is the question. First Test: Adding an article to a publication. I created a new table in the publisher database. I added the table as an article in the publication. I checked replication status on the Subscriber and it says "The initial snapshot for article 'JohnReplTest' is not yet available.". Ran the Replication Snapshot Agent for the publication on the publisher. I didn'...

rutherfordtx.com

Rutherford's SQL Blog: July 2011

http://www.rutherfordtx.com/2011_07_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Thursday, July 14, 2011. Beginning SQL #2 - The System Databases. There are five main system databases that are created automatically when you install SQL server. They are master, model, tempdb, msdb, and resource. There is a sixth system database, distribution, that is only created when you configure replication on the server. As I heard SQLSoldier. Say in a recent webinar. "tempdb is the junk drawer of SQL Server". Tempdb is a shar...This ...

rutherfordtx.com

Rutherford's SQL Blog: June 2015

http://www.rutherfordtx.com/2015_06_01_archive.html

My lessons in moving from a Procedural to a Set Based Attitude. Tuesday, June 16, 2015. Resetting TempDB data files. Have you ever missed a personal deadline for something (like a making a doctor's or dentist appointment) and the further you get past it, the harder it it is to do it? Demystify Tempdb Performance and Management - Robert Davis. TempDB Performance and Configuration - Kendra Little. Building Perfect SQL Servers, Every Time - Joey D'Antoni. Correctly Adding data Files to TempDB - Paul Randall.