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

Stories recently tagged with 'SqlServer2005' Subscribe to this feed
3
kicks
Working with tempdb
submitted by kprernn 17 days, 11 hours ago

weblogs.sqlteam.com — Link to a good TechNet article that thoroughly discusses tempdb in SQL Server 2005. A good read. read more...

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

13
kicks
Ease your SSMS experience: SSMS Tools PACK 1.0 is out!
published 1 month, 17 days ago, submitted by spirit1 1 month, 28 days ago

weblogs.sqlteam.com — A popular free add-in for SQL Server Management Studio (SSMS) is now in release version 1.0. With many new and improved features it speeds up your SSMS development. read more...

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

14
kicks
SQL Server 2005: Get full information about transaction locks
published 2 months ago, submitted by spirit1 2 months, 7 days ago

weblogs.sqlteam.com — Get information about what locks are being held by the transaction, what SPID owns the transaction, on which objects the locks are being held, what SQL statement caused the locks, etc... read more...

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

18
kicks
SQL Server in One Page - Download it Now
published 2 months, 7 days ago, submitted by pinaldave pinaldave 2 months, 8 days ago

blog.sqlauthority.com — One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page. Let me know your opinion and suggestion. Download SQL Server FAQ Sheet in PDF format read more...

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

1
kicks
Switching from Non-IDENTITY to IDENTITY and vise versa
submitted by ssuniverse 4 months, 10 days ago

sqlserveruniverse.com — There may arise situations where it is necessary to switch a field from IDENTITY to non-IDENTITY, and sometimes the other way round. This article discusses these situations on how you were able to do it using SQL Server 2000, and how it can be done now in SQL Server 2005. read more...

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

11
kicks
How SQL Server short-circuits WHERE condition evaluation
published 4 months, 9 days ago, submitted by spirit1 4 months, 11 days ago

weblogs.sqlteam.com — As a developer you must be aware that SQL Server does not do short-circuiting like it is done in other programming languages and there's nothing you can do to force it to. read more...

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

4
kicks
Does the order of criteria the WHERE clause matter?
submitted by kprernn 4 months, 14 days ago

weblogs.sqlteam.com — Does the order of the search criteria make any difference in Microsoft SQL Server's ability to use indexes or resolve a query? In this post, Joe provides a demonstration of how SQL Server can optimize the WHERE clause to its benefit. read more...

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

2
kicks
Moving a Notification Services database
submitted by kprernn 4 months, 22 days ago

weblogs.sqlteam.com — Moving a SQL Server Notification Services database can be a bit tricky. This blog steps you through the required steps to move the instance and application databases to new locations. read more...

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

4
kicks
Does the order of columns in an index matter?
submitted by kprernn 4 months, 23 days ago

weblogs.sqlteam.com — In this blog Joe answers the question, 'does the order of columns in an index really matter?' He provides several examples and shows the results of the Query Execution Plan. read more...

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

13
kicks
Using CROSS JOIN to generate test data
published 4 months, 29 days ago, submitted by kprernn 5 months 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: 4
tags: , , , , | tag it

2
kicks
Using the SSNS Management.SMO NameSpace
submitted by kprernn 5 months, 5 days ago

weblogs.sqlteam.com — In this posting, Joe demonstrates how the Management.SMO namespace may be used to manage an SSNS instance. The soucecode to a brief C# application is provided as an example. read more...

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

2
kicks
Do I need to compact my SQL Server database?
submitted by kprernn 5 months, 26 days ago

weblogs.sqlteam.com — This is a question frequently asked by those who have used Microsoft Access. This blog posting goes through some great examples to prove that SQL Server can and does automatically reuse space, even after you delete rows. read more...

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

2
kicks
SQL Server error messages
submitted by kprernn 6 months, 29 days ago

weblogs.sqlteam.com — Ever needed to find the text associated with an error number in SQL Server? This blog shows you how to retrieve it from SQL Server's metadata using T-SQL. read more...

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

2
kicks
SQL Server 2005: Synonyms in T-SQL (analogous to Aliases in .Net)
submitted by spirit1 7 months, 10 days ago

weblogs.sqlteam.com — If you're a .Net developer aliases should be very familiar to you. SQL Server 2005 added a similar functionality to T-SQL called Synonyms. read more...

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

49
kicks
Free SQL Server tools that might make your life a little easier
published 7 months, 16 days ago, submitted by spirit1 7 months, 16 days ago

weblogs.sqlteam.com — Free MS and non MS tools for easoer work with SQL Server 2005 and 2000 read more...

Add a comment 1 comment | category: | Views: 14
tags: , , , , | tag it

2
kicks
SQL Server 2005 evil DBA prank
submitted by spirit1 7 months, 21 days ago

weblogs.sqlteam.com — Today I feel a bit evil minded so I thought I'd share this little prank-friendly function. If you put this into a .Net Assembly you import to SQL Server as a function or a stored procedure you can wreck some real havoc read more...

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

 

Sponsored Link: www.carlist.ie

Search:

Ads via The Lounge