sqlserver-tips.blogspot.com
SQL Server Tips: November 2006
http://sqlserver-tips.blogspot.com/2006_11_01_archive.html
Friday, November 03, 2006. Starting concurrency tests simultaneously could be tricky, especially they need to start at the same time from different workstations. One way to do it:. CREATE TABLE WhistleSound(i INT). SET @cnt = 0. WHILE (@cnt = 0) BEGIN. SELECT @cnt = COUNT(*) FROM WhistleSound WITH(NOLOCK). IF @cnt = 0. From one connection run. From another connection run. From third connection run. Posted by Alex Kuznetsov @ 2:56 PM. When Snapshot Isolation Helps and When It Hurts. Matija Lah's Blog (MVP).
weblogs.sqlteam.com
A bit about sql server's local temp tables
http://weblogs.sqlteam.com/mladenp/archive/2006/11/03/17197.aspx
I want some Moore. Blog about stuff and things and stuff. Mostly about SQL server and .Net. Posts - 223, comments - 2294, trackbacks - 33. And I'm currently working as a .Net (C#) and SQL Server developer. I also speak at local user group meetings and conferences like SQLBits and NT Conference. Welcome to my blog. June, 2016 (1). March, 2016 (1). October, 2015 (1). May, 2015 (1). May, 2014 (1). January, 2014 (1). July, 2013 (1). March, 2013 (1). February, 2013 (1). December, 2012 (1). September, 2012 (1).
sqlserver-tips.blogspot.com
SQL Server Tips: October 2006
http://sqlserver-tips.blogspot.com/2006_10_01_archive.html
Friday, October 27, 2006. Child Intervals Of Time Inside Parent Ones - Enforced By RI. I needed to enforce a business rule that appointments fit into shifts. The only one watertight way of doing it that i know about is to use RI, as follows:. CREATE Table Shifts(ShiftID INT NOT NULL PRIMARY KEY,. StartedAt DATETIME NOT NULL,. FinishedAt DATETIME NOT NULL,. CONSTRAINT UK Shifts UNIQUE(ShiftID, StartedAt, FinishedAt). INSERT Shifts VALUES(1, '20061025 08:00AM', '20061025 05:00PM'). These updates succeed: a...
sqlserver-tips.blogspot.com
SQL Server Tips: July 2007
http://sqlserver-tips.blogspot.com/2007_07_01_archive.html
Monday, July 23, 2007. All Permutations For A String. Suppose you have a auxiliary Numbers table with integer numbers. DECLARE @s VARCHAR(5);. SET @s = 'ABCDE';. WITH Subsets AS (. SELECT CAST(SUBSTRING(@s, Number, 1) AS VARCHAR(5) AS Token,. CAST('.' CAST(Number AS CHAR(1) '.' AS VARCHAR(11) AS Permutation,. CAST(1 AS INT) AS Iteration. FROM dbo.Numbers WHERE Number BETWEEN 1 AND 5. SELECT CAST(Token SUBSTRING(@s, Number, 1) AS VARCHAR(5) AS Token,. SIteration 1 AS Iteration. BETWEEN 1 AND 5. Matija Lah...
sqlserver-tips.blogspot.com
SQL Server Tips: June 2007
http://sqlserver-tips.blogspot.com/2007_06_01_archive.html
Friday, June 22, 2007. One More Article on Devx.com. Enforce Business Rules for All Your Data with Constraints". Http:/ www.devx.com/dbzone/Article/34479. This article is a reply to Paul Nielsen's post on sqlblog.com. Http:/ sqlblog.com/blogs/paul nielsen/archive/2006/12/18/430.aspx#comments. Posted by Alex Kuznetsov @ 11:35 AM. Thursday, June 21, 2007. Materialized Path: Making Sure a Tree has No Cycles. The following DDL guarantees no cycles for Materialized Path:. ParentPath VARCHAR(900) NULL,. INSERT...
sqlpointers.com
SQL Garbage Collector: February 2013
http://www.sqlpointers.com/2013_02_01_archive.html
Collecting SQL pointers . . . Feb 27, 2013. SQL to ECL - Metamorphosis. As the old saying goes, it can be figured out whether you are a data guy or not just by the way you solve the problem:. An imperative programmer goes: for each order in the orders table, find the corresponding order details. . . And the SQL programmer goes: take the orders table and join with the order details on the order ID key. . . Now, ECL is not SQL but has the SQL programming style. Something that produces an output. By signing...
sqlpointers.com
SQL Garbage Collector: April 2010
http://www.sqlpointers.com/2010_04_01_archive.html
Collecting SQL pointers . . . Apr 16, 2010. Custom SQL Stored Procedure Best Practices Analyzer - SQL Cop, Maybe? Recently, I moved to Seattle as a Data Architect for a product our company was developing. I also started taking up most of the DBX roles in that project. Pass time with SQL. Subscribe to: Posts (Atom). View my complete profile. FAQs and not so FAQs. Pass time with SQL. Fun with SQL - Puzzles. 01 - Get Random Records. 02 - Find Maximum Value. 03 - Find Intermediate Value.
sqlpointers.com
SQL Garbage Collector: November 2009
http://www.sqlpointers.com/2009_11_01_archive.html
Collecting SQL pointers . . . Nov 14, 2009. Solving Sudoku using SQL Server 2005 - Step by Step - Part #6. This is the last post in this series. Is the last one that tries to solve the puzzle logically. This one will take the latest unsolved sudoku board that we get after running through the first three algorithms and use brute force to solve the puzzle. I am not going to reinvent the wheel here. Labels: Pass time with SQL. Solving Sudoku using SQL Server 2005 - Step by Step - Part #5. Nov 12, 2009.
SOCIAL ENGAGEMENT