Explanation of my winninig solution to TSQL Challenge 17(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 9 months ago

Naomi explains her winning solution to TSQL Challenge 17 read more...

add a comment |category: Database |Views: 275

tags: TSQL beyondrelational Database SQLServer another

XQuery Lab 55 – Extracting values from XML elements that matches a str(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 10 months ago

Here is another XQuery exercise that uses the contains() function to match a string pattern against an XML element and retrieves values from a sibling element. read more...

add a comment |category: Database |Views: 145

tags: TSQL beyondrelational xquery Database SQLServer another

Cannot resolve collation conflict for column 1 in SELECT statement(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 10 months ago

This post explains how to fix the SQL Server error message "Msg 468, Level 16, State 9, Line 1 Cannot resolve the collation conflict between "Arabic_CI_AS" and "SQL_Latin1_General_CP1_CI_AI" in the equal to operation". read more...

add a comment |category: Database |Views: 31

tags: beyondrelational collation TSQL Database SQLServer another

TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 10 months ago

This challenge is related to a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules. read more...

add a comment |category: Database |Views: 142

tags: beyondrelational TSQLChallenges jacobsebastian Puzzle Database another

A T-SQL Holiday Message(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 10 months ago

Have fun with this TSQL Holiday Message. Run the code given in the story and you will be surprised to see the output. read more...

add a comment |category: Database |Views: 7

tags: SQLServer beyondrelational jacobsebastian Database TSQL another

Michael DeFehr explains his winning solution to TSQL Challenge 14(beyondrelational.com)

submitted by jacobsebastian(3639) 1 year, 10 months ago

Michael DeFehr has written an excellent explanation of his winning solution to TSQL Challenge 14. read more...

add a comment |category: Database |Views: 17

tags: TSQL beyondrelational TSQLChallenges Server Database another

How to copy, cut and paste column names from tables (dink.no-ip.info)

submitted by hughesdo(59) 3 years, 5 months ago

How to copy, cut and paste column names from tables while in the SQL 2000 Query Analyzer. read more...

add a comment |category: Tips & Tricks |Views: 28

tags: TSQL SQL Tips another

How To: Create Dynamic File System Directory in TSQL(dbalink.wordpress.com)

submitted by Marlonr(694) 3 years, 6 months ago

I have created a Backup Script to backup all the databases in our SQL Server 2005. I want to keep old backups for sometime for some reason; so I want to create subdirectory with the run date as the name of the folder to separate the set of backups by date. read more...

add a comment |category: Database |Views: 16

tags: TSQL Database another

How To: Rename SQL Server 2005 Database Using TSQL (dbalink.wordpress.com)

submitted by Marlonr(694) 3 years, 7 months ago

For some reasons, DBA’s need to rename their Databases. One of the reasons might be to comply to Best Practices Policy changes. Here we are going to rename our Database named “Bad_Ass_DB” into “Best_Practice_DB”. This is how Database renaming with TSQL is done in SQL Server 2005.... read more...

add a comment |category: Database |Views: 58

tags: SQLServer TSQL 2005 Database SQL another

SQL Server 2005/2008 Upcoming Events Near You!(dbalink.wordpress.com)

submitted by Marlonr(694) 3 years, 9 months ago

Watch out for these events! read more...

add a comment |category: Database |Views: 5

tags: 2008 TSQL DBA ssas SSRS another

Tips & tricks for writing better queries presentation(weblogs.sqlteam.com)

submitted by kprernn(1445) 3 years, 10 months ago

Link to the "Writing Better Queries" presentation that Joe Webb gave at the Nashville SQL Server User Group meeting on 4 April 2008. read more...

add a comment |category: Database |Views: 16

tags: TSQL SQLServer Database another

Does the order of criteria the WHERE clause matter?(weblogs.sqlteam.com)

submitted by kprernn(1445) 3 years, 11 months ago

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 |category: Database |Views: 38

tags: SqlServer2005 TSQL Database another

Build a complete Stored Procedure based Data Access Layer ... Part 2(blog.zacksfiasco.com)

submitted by ormico(150) 4 years ago

Build a complete Stored Procedure based Data Access Layer using Code Generation - Part 2 read more...

add a comment |category: Database |Views: 35

tags: TSQL DAL ORM Database ADO.NET another

Build a complete Stored Procedure based Data Access Layer ... Part 1(blog.zacksfiasco.com)

submitted by ormico(150) 4 years ago

Build a complete Stored Procedure based Data Access Layer using Code Generation Part 1 read more...

add a comment |category: Database |Views: 65

tags: TSQL DAL ORM Database ADO.NET another

SQL - Cursors(techahead.wordpress.com)

submitted by prashantvictory(605) 4 years, 3 months ago

This article give you the detailed explaination about cursors used in sql.... read more...

add a comment |category: Database |Views: 9

tags: TSQL TechAhead SQLServer Database SQL another

The undocumented sp_MSforeachtable procedure(weblogs.sqlteam.com)

submitted by kprernn(1445) 4 years, 3 months ago

This posting demonstrates how to use the undocumented sp_MSforeachtable stored procedure in the SQL Server master database to execute a SQL script against each table in the database. Great for disabling check constraints before loading data. read more...

add a comment |category: Database |Views: 29

tags: TSQL SqlServer2005 Database SQLServer another