DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

l2d2 Subscribe to this feed
l2d2
Profile Kicked Submitted Comments Tags Friends Kicked By Friends Submitted By Friends

Stories kicked by l2d2
15
kicks
Does order matter in a JOIN clause?
published 8 months, 20 days ago, submitted by kprernn 8 months, 24 days ago

weblogs.sqlteam.com — Does the order of tables referenced in a JOIN clause affect query performance. In this post, Joe addresses this question by examining the query execution plans created for sample queries. read more...

Add a comment add a comment | category: | Views: 1
tags: | tag it

13
kicks
Using CROSS JOIN to generate test data
published 9 months, 15 days ago, submitted by kprernn 9 months, 16 days ago

weblogs.sqlteam.com — In this blog, Joe demonstrates the power of the CROSS JOIN and how it can be harnessed to create lots of test data very quickly. read more...

Add a comment add a comment | category: | Views: 9
tags: , , , , | tag it

3
kicks
SQL Server Notification Services Resources
submitted by kprernn 9 months, 30 days ago

weblogs.sqlteam.com — Good SQL Server Notification Services (SSNS) articles and resources. read more...

Add a comment add a comment | category: | Views: 0
tags: | tag it

5
kicks
Reclaiming unused space from a table
submitted by kprernn 10 months, 7 days ago

weblogs.sqlteam.com — Did you know that SQL Server doesn't automatically reuse space from variable length columns that have been dropped from a table? This blog shows you how to reclaim that space using the DBCC CLEANTABLE command. read more...

Add a comment add a comment | category: | Views: 1
tags: | tag it

4
kicks
Creating a Notification Services Instance
submitted by kprernn 10 months, 13 days ago

weblogs.sqlteam.com — Great tutorial for using SQL Server Management Studio to create a Notification Services instance. read more...

Add a comment add a comment | category: | Views: 1
tags: | tag it

33
kicks
Copying and pasting rectangular blocks of code in Visual Studio and Ma
published 1 year ago, submitted by kprernn 1 year ago

weblogs.sqlteam.com — Did you know that the Visual Studio and Management Studio editors allow you to copy and paste rectangular areas of code (not just lines of code)? This blog demonstrates how. Very handy when copying and pasting variable names! read more...

Add a comment 4 comments | category: | Views: 3
tags: | tag it

7
kicks
When was a SQL Server table or view last altered?
submitted by kprernn 1 year, 1 month ago

weblogs.sqlteam.com — A very handy little script to determine the last time a SQL Server table or view was altered. read more...

Add a comment add a comment | category: | Views: 7
tags: , , , , | tag it

3
kicks
How to tell when the SQL Server service was started
submitted by kprernn 1 year, 1 month ago

weblogs.sqlteam.com — Neat little post that shows how to use T-SQL to determine with the SQL Server service was last started. read more...

Add a comment add a comment | category: | Views: 0
tags: , , , , | tag it

3
kicks
Error 15401 when creating a new Login
submitted by kprernn 1 year, 2 months ago

weblogs.sqlteam.com — This blog describes what to do when you receive an error while attempting to create a new SQL Server Login. It contains a link to a helpful KB article, too. read more...

Add a comment add a comment | category: | Views: 3
tags: , , | tag it

9
kicks
SQL Server 2000: when were the statistics updated?
published 1 year, 2 months ago, submitted by kprernn 1 year, 2 months ago

weblogs.sqlteam.com — A SQL script to determine when the statistics were updated for all indexes on all user tables in SQL Server 2000. read more...

Add a comment add a comment | category: | Views: 0
tags: , , , | tag it

23
kicks
"Nothing has changed" - Determining when a procedure has been altered
published 1 year, 2 months ago, submitted by kprernn 1 year, 2 months ago

weblogs.sqlteam.com — Cool little script to determine when a stored procedure was last updated. read more...

Add a comment add a comment | category: | Views: 0
tags: , , , | tag it

 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge