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

SQLStudies

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.

Archives: April 2014

DBA Myths: TRUNCATE TABLE deletes all the rows of a table instantly.

Most DBAs and developers I’ve talked to over the years have felt that TRUNCATE TABLE is an instant DELETE. However would you believe that it doesn’t actually delete the data from the pages at all? Here is an example:

-- Setup code
CREATE DATABASE TruncateTest
GO
USE TruncateTest
GO
CREATE…

Read more

7 comments, 930 reads

Posted in SQLStudies on 30 April 2014

The default autogrowth settings do NOT come from the Model database.

I recently saw a question about How to inherit autogrowth settings. They commented that while the new database GUI seemed to inherit the autogrowth settings from the model DB the CREATE DATABASE command did not. Now my initial reaction was “Of course the autogrowth settings are pulled from model.… Read more

1 comments, 208 reads

Posted in SQLStudies on 28 April 2014

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

In Europe, Canada and… Read more

0 comments, 1,584 reads

Posted in SQLStudies on 23 April 2014

Collation: Confusion

I started reading about collations after I had a recent run in with them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

In Europe, Canada and… Read more

0 comments, 81 reads

Posted in SQLStudies on 23 April 2014

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

I’ve… Read more

0 comments, 31 reads

Posted in SQLStudies on 21 April 2014

Collation: Temporary objects and variables: Demonstration

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

I’ve… Read more

4 comments, 934 reads

Posted in SQLStudies on 21 April 2014

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more

9 comments, 173 reads

Posted in SQLStudies on 16 April 2014

Who is an expert?

Recently Paul Randal had a brief rant on twitter where he complained about the fact that there are no stupid questions. This lead to a discussion on and how experts should and should not react to said questions. I’ve been thinking about what makes up a stupid question and what… Read more

9 comments, 30 reads

Posted in SQLStudies on 16 April 2014

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 35 reads

Posted in SQLStudies on 14 April 2014

Collation: Correction -> Instance

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 105 reads

Posted in SQLStudies on 14 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 164 reads

Posted in SQLStudies on 10 April 2014

Collation: Correction -> Expression, Column, Database

I had a recent run in with collation problems and it got me started reading about them. As I read I started to realize that for a seemingly simple subject there was a lot to it. So I thought I would go over some of what I found out.

You’ve… Read more

0 comments, 30 reads

Posted in SQLStudies on 10 April 2014

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. Add that to the comment “Mess with your co-workers” and I was hooked on this one. T-SQL Tuesday this month is hosted by Matt Velic (b/t)… Read more

4 comments, 34 reads

Posted in SQLStudies on 8 April 2014

T-SQL Tuesday #53: Why so serious

Why so serious? If you ask anyone who knows me they will tell you I’m not a terribly serious person. Add that to the comment “Mess with your co-workers” and I was hooked on this one. T-SQL Tuesday this month is hosted by Matt Velic (b/t)… Read more

4 comments, 884 reads

Posted in SQLStudies on 8 April 2014

Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move even farther into the cloud. Microsoft’s new CEO Satya Nadella announced this morning

“We felt that by creating such an elaborate prank it would soften the blow. Microsoft will no…

Read more

4 comments, 299 reads

Posted in SQLStudies on 1 April 2014

Microsoft announces that it will no longer support SQL Server and that SQL 2014 was an April Fools Joke!

Microsoft has announced that SQL 2014 was in fact an elaborate April Fool’s joke and that Microsoft intends to move even farther into the cloud. Microsoft’s new CEO Satya Nadella announced this morning

“We felt that by creating such an elaborate prank it would soften the blow. Microsoft will no…

Read more

4 comments, 28 reads

Posted in SQLStudies on 1 April 2014