Scott on Writing

Musings on technical writing...

SQL

Deleting All Records In a Table EXCEPT For the N Most Recently Added Records

posted @ Thursday, October 01, 2009 8:50 AM | Feedback (6)

Ruminations on Multi-Tenant Data Architectures

posted @ Wednesday, August 19, 2009 4:09 PM | Feedback (10)

New T-SQL 2008 Syntax

posted @ Tuesday, February 03, 2009 7:40 AM | Feedback (4)

SQL Tip: Displaying a Padded Number

posted @ Sunday, January 18, 2009 8:10 AM | Feedback (8)

Running the Same Query Against Multiple Databases

posted @ Monday, November 17, 2008 8:00 AM | Feedback (8)

OUTPUTing Data from the Just-Inserted, Updated, or Deleted Row(s)

posted @ Saturday, October 11, 2008 12:00 PM | Feedback (3)

Returning the First Day of the Month from a Given Date/Time value in SQL Server

posted @ Tuesday, December 05, 2006 9:19 PM | Feedback (6)

SQL Prompt - IntelliSense for SQL

posted @ Monday, May 22, 2006 8:41 AM | Feedback (7)

Esoteric Connection String Parsing Problem When Ending the Password with an Apostrophe

posted @ Monday, May 08, 2006 1:11 PM | Feedback (3)

Generating a List of Unattached Databases

posted @ Wednesday, April 26, 2006 6:37 PM | Feedback (1)

My Links

Ads Via DevMavens

Archives

Post Categories

 

I am a Microsoft MVP for ASP.NET.
I am an ASPInsider.
<March 2010>
SMTWTFS
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910

Comment Stats

DayTotal% of Total
Sunday 2056.8%
Monday 42514.1%
Tuesday 51917.2%
Wednesday 55618.4%
Thursday 58019.2%
Friday 54718.1%
Saturday 1886.2%
Total 3020100.0%

Hour1Total% of Total
12:00 AM 782.6%
1:00 AM 812.7%
2:00 AM 682.3%
3:00 AM 822.7%
4:00 AM 692.3%
5:00 AM 1264.2%
6:00 AM 1193.9%
7:00 AM 1816.0%
8:00 AM 1926.4%
9:00 AM 1585.2%
10:00 AM 1886.2%
11:00 AM 1936.4%
12:00 PM 2016.7%
1:00 PM 1846.1%
2:00 PM 1695.6%
3:00 PM 1354.5%
4:00 PM 1153.8%
5:00 PM 1073.5%
6:00 PM 1013.3%
7:00 PM 1073.5%
8:00 PM 923.0%
9:00 PM 882.9%
10:00 PM 913.0%
11:00 PM 953.1%
Total 3020100.0%

Comments by Blog Entry Date/Time

Day Entry MadeAvg.Total
Sunday 5.00160
Monday 4.80384
Tuesday 4.04477
Wednesday 7.39680
Thursday 6.26676
Friday 5.07466
Saturday 4.78177
Total 5.403020

Hour1 Entry MadeAvg.Total
12:00 AM 5.2937
1:00 AM 1.002
5:00 AM 0.000
7:00 AM 3.8550
8:00 AM 3.72134
9:00 AM 6.06297
10:00 AM 5.63276
11:00 AM 4.22194
12:00 PM 6.16351
1:00 PM 3.09133
2:00 PM 4.89230
3:00 PM 7.67322
4:00 PM 4.00108
5:00 PM 6.07170
6:00 PM 4.64116
7:00 PM 8.95188
8:00 PM 8.63164
9:00 PM 5.00115
10:00 PM 6.31101
11:00 PM 4.5732
Total 5.403020

Learn More About Comment Stats
1 - All times GMT -8...


Blog Stats

Favorite Web Sites

My Books

My MSDN Articles