blogs.lessthandot.com
Less Than Dot - Blog - Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action
http://blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/interview-with-rod-colledge-about-the-bo
To become a member! A Technical Community for IT Professionals. Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account. You will have immediate access to the forums and all past articles and commentaries. Sql server 2008 r2. Architecture, Design and Strategy. It’s interesting...
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: April 2006
http://sqlservercode.blogspot.com/2006_04_01_archive.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Friday, April 28, 2006. Splitting City, State and Zipcode From One Column (Or Flat file). Sometimes you deal with vendors, customers or agencies and you have to do a file exchange. City ,st 12223'. New York City,NY 10028'. Princeton , NJ 08536'. Princeton,NJ 08536 '. Long Island City, NY 10013'. Long Island City, NY 10013 '. Long Island City , NY 10013'. One of the ...
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: March 2006
http://sqlservercode.blogspot.com/2006_03_01_archive.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Friday, March 31, 2006. SQL Server Podcast With Bill Graziano. SQL Down Under has announced their latest podcast with guest Bill Graziano. In this show, Bill Graziano is discussing things he wishes developers knew about SQL Server, agile development, build environments and unit testing of SQL Server along with the recent PASS conference and baseball. So let's get st...
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: 6 new SQL Server Denali CTP3 posts
http://sqlservercode.blogspot.com/2011/07/6-new-sql-server-denali-ctp3-posts.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Friday, July 15, 2011. 6 new SQL Server Denali CTP3 posts. I have created 6 new SQL Server Denali CTP3 posts. These posts are about the new things introduced in SQL Server Denali CTP3, below is a list of the posts. A Quick look at the new IIF function in Denali CTP3. A Quick look at the new EOMONTH function in SQL Server Denali CTP3. View my complete profile. Your f...
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: May 2006
http://sqlservercode.blogspot.com/2006_05_01_archive.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Wednesday, May 31, 2006. Unit Testing For The DB, Visual Studio Team Edition for Database Professionals Is Here. Bringing Database Professionals Into the Application Life Cycle. Read the press-release: Microsoft Enhances Collaboration for Database Professionals With New Addition to Visual Studio Product Line. Links to this post. Here is the query. FakeDate) = 1 THEN.
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: Win A Copy Of SQL Server 2008 Administration in Action
http://sqlservercode.blogspot.com/2009/10/win-copy-of-sql-server-2008.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Tuesday, October 13, 2009. Win A Copy Of SQL Server 2008 Administration in Action. Rod Colledge was kind to give the readers of Less Than Dot. A chance to win a pdf copy of his book SQL Server 2008 Administration in Action. Here is how you can win this book, first read the Interview With Rod Colledge About The Book SQL Server 2008 Administration in Action. This ques...
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: SQL Advent 2012 has started
http://sqlservercode.blogspot.com/2012/12/sql-advent-2012-has-started.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Wednesday, December 05, 2012. SQL Advent 2012 has started. Just like last year, I decided to do a SQL Advent this year. There are 4 posts up so far. Data types storage differences. Triggers, what to do, what not to do. Don’t trust the designers. In case you are interested in last year's posts, all of them are listed here: SQL Advent 2011 Recap. SQL Advent 2012: Recap.
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: 10 must read SQL Server posts by Ted Krueger
http://sqlservercode.blogspot.com/2009/09/10-must-read-sql-server-posts-by-ted.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Monday, September 28, 2009. 10 must read SQL Server posts by Ted Krueger. A buddy of mine Ted Krueger writes some really interesting SQL Server posts. Most of these posts focus more on administration than on developer stuff but still stuff that is useful to a developer. Here are 10 of my favorites, I liked these and you will too! 6 ways to import data into SQL Server.
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: September 2005
http://sqlservercode.blogspot.com/2005_09_01_archive.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Wednesday, September 28, 2005. Split a comma delimited string fast! Create our Pivot table * do this only once- populate it with 1000 rows. String manipulation with a pivot table. ChvGroupNumbers = '1,4,77,88,4546,234,2,3,54,87,9,6,4,36,6,9,9,6,4,4,68,9,0,5,3,2,'. ChvGroupNumbers ',', NumberID 1,. ChvGroupNumbers ',', NumberID 1) - NumberID -1) AS. Links to this post.
sqlservercode.blogspot.com
SQL Server Code,Tips and Tricks, Performance Tuning: November 2005
http://sqlservercode.blogspot.com/2005_11_01_archive.html
SQL Server Code,Tips and Tricks, Performance Tuning. A blog about SQL Server, Books, Movies and life in general. Microsoft SQL Server Books. Tuesday, November 29, 2005. SQL Server 2000 Undocumented Procedures For Files, Drives and Directories. Below are some undocumented SQL Server 2000 procedures for information about files, drives and directories. Returns the network name of the server. Master. xp getnetname. Returns 1 if a file exists, 1 if the file is a directory and 1 if a parent directory exists.
SOCIAL ENGAGEMENT