negative-barometer.info

the-sql-server-man.blogspot.com

The SQL Server Man: CPD

http://the-sql-server-man.blogspot.com/p/cpd.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. I really need to log CPD (Continuous Professional Development for those wondering) somewhere so I thought I would log online, it gives me somewhere I can easily find and might give other people some ideas. 07 Apr 2013 : Bad SQL Server Advice, Brent Ozar, .5 hours. 6 Apr 2013 : DBA Diary, Chris Page, 10 hours. 12 Mar 2013 : Logshipping Part 2 When Disaster Strikes, Brent Ozar, .5 hours. Subscribe to: Posts (Atom). The Page Family Blog.

the-sql-server-man.blogspot.com

The SQL Server Man: December 2013

http://the-sql-server-man.blogspot.com/2013_12_01_archive.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Tuesday, 31 December 2013. I have been struggling with poor performance on my laptop for sometime, I had realised that the problem was a regular stoppage of everything but couldn't figure out what it was. Back to the topic, what I am missing is how to set the location of the auto-recovery files - I did search all the locations that are listed on line and my files were in none of them, I even manually created the folders in My Docume...

the-sql-server-man.blogspot.com

The SQL Server Man: May 2009

http://the-sql-server-man.blogspot.com/2009_05_01_archive.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Friday, 1 May 2009. Using Sql Server Management Studio Offline. First post, a tip I desperately needed today. I have been using my laptop offline and occasionally find myself faced with a "cannot generate sspi context" error message. Now I can logon to the expected instance name and work with no problems. 5 minute fix. Click here for a discussion of the SSPI problem on SQL Server Central. Links to this post. I will credit the author...

the-sql-server-man.blogspot.com

The SQL Server Man: April 2013

http://the-sql-server-man.blogspot.com/2013_04_01_archive.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Friday, 19 April 2013. I was trying to figure out how much space storage of nulls takes. There are any number of articles online (SQL Server 2012 and prior versions) saying that nulls take no space except for the 2 byte row overhead for having any number of nullable columns. However, I am convinced I read somewhere that null columns only take no space when they are not subsequently followed by non null data. I have a document called...

the-sql-server-man.blogspot.com

The SQL Server Man: SQL Server To Do List

http://the-sql-server-man.blogspot.com/p/sql-server-to-do-list.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. SQL Server To Do List. This is my SQL Server to do list, I suspect I'll never get to the end, in fact let's start with that thought in mind :. Tinker with the latest version. Read the blogs of the DBA greats, current favourites (alphabetical order, no favouritism) are Brent Ozar and associates. Feel free to suggest more! Read the enormous pile of manuals that is ever growing, remember to be thankful for PDFs. Modify the Check State ...

the-sql-server-man.blogspot.com

The SQL Server Man: Null storage

http://the-sql-server-man.blogspot.com/2013/04/null-storage.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Friday, 19 April 2013. I was trying to figure out how much space storage of nulls takes. There are any number of articles online (SQL Server 2012 and prior versions) saying that nulls take no space except for the 2 byte row overhead for having any number of nullable columns. However, I am convinced I read somewhere that null columns only take no space when they are not subsequently followed by non null data. I have a document called...

the-sql-server-man.blogspot.com

The SQL Server Man: SSMS Auto Recovery

http://the-sql-server-man.blogspot.com/2013/12/ssms-auto-recovery.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Tuesday, 31 December 2013. I have been struggling with poor performance on my laptop for sometime, I had realised that the problem was a regular stoppage of everything but couldn't figure out what it was. Back to the topic, what I am missing is how to set the location of the auto-recovery files - I did search all the locations that are listed on line and my files were in none of them, I even manually created the folders in My Docume...

the-sql-server-man.blogspot.com

The SQL Server Man: Tempdb

http://the-sql-server-man.blogspot.com/2013/02/tempdb.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Tuesday, 19 February 2013. Useful article on tempdb and the numbers of files required : tempdb article. I tend to start with just two files and extend if experiencing performance problems simply because I've had a number of cases where tempdb activity is slower spread across lots of small files than running everything against fewer, large files. Subscribe to: Post Comments (Atom). Adventures with Powershell, finally some code.

the-sql-server-man.blogspot.com

The SQL Server Man: February 2013

http://the-sql-server-man.blogspot.com/2013_02_01_archive.html

The SQL Server Man. Microsoft sql server musings. SQL Server To Do List. Thursday, 28 February 2013. With more than a singe TempDB data file it is critical to ensure that all data files stay in the same proportion in order that proportional fill algorithms can operate. To check for uneven tempdb run the following :. We need to check all of the datafiles ( type desc='ROWS'. And a simple method of deciding if there is an issue is to compare the average file size logged in sys.master files. Is not a valid o...