SQLShare SQL Channel

The SQL Channel

Sponsored Ads

This channel is dedicated to SQL Server and the technologies that surround it. You'll find videos about SSIS, Replication, Performance and more. Check back daily for updated content.

Using DatePart and DateName (Watch it later!)

	Featured Video
Date Published: Wednesday, March 10, 2010 Author: Andy Warren Rating: 4.28

Description: Ever want to get the month out of a date as a number, or as literal text? Many people will do it by parsing the date as a string, but we've got some built in functions that will do it cleanly and consistently.

New Releases

	Renaming a Database (Watch it Later!) Date Published: March 09, 2010 Author: Andy Warren Rating: 4.33 Description: You won't do it often, but it's nice to know how, and you're not still using sp_renamedb are you? Join us for a quick look at how to use the alter syntax to change the db name along with a tip on how to quickly disconnect any remaining users from the database.

File Share Subscriptions in Reporting Services (Watch it Later!)

Date Published: February 17, 2010

Author: Devin Knight

Rating: 4.25

Description: Whether you want to generate PDF invoices for customers or do a daily export that will get processed by one of your vendors, the ability to deliver reports to a file share is a useful and simple feature baked in to Reporting Services. In this lesson Devin will show you how to do it and how to set most of the common options.

File Share Subscriptions in Reporting Services (Watch it Later!)

Date Published: February 17, 2010

Author: Devin Knight

Rating: 4.25

Using DB_ID and DB_Name Functions (Watch it Later!)

Date Published: March 03, 2010

Author: Andy Warren

Rating: 4.27

Description: Simple but effective, DB_ID and DB_Name give you a concise way to look up the id of a database from a name, or look up the name of a database from an id. There are times when you'll need to write the join to sys.sysdatabases, but when all you need is a quick conversion, these functions get it done.

Using @@Total_Read and @@Total_Write (Watch it Later!)

Date Published: March 03, 2010

Author: Andy Warren

Rating: 4.05

Description: Ever wondered how many physical reads and writes your SQL service is doing? Yes, it may seek a bit geeky, but it's often useful to have an idea if a server is read or write heavy. @@Total_Read and @@Total_Write show you the number of physical (not logical) reads since the last service restart, and from there we can easily calculate a percentage of reads if needed.