Find a column in a database with INFORMATION_SCHEMA.COLUMNS — Parv The IT Geek

Have you ever just been given a column name and not known which table it was in? Needed to check whether a column existed within a database?… Well today I was just given a column name and told the information I needed was in there but alas they didn’t know which table it was in.Continue reading “Find a column in a database with INFORMATION_SCHEMA.COLUMNS — Parv The IT Geek”

How to list all SQL DMVs (Dynamic management views) s and DMFs (Dynamic management functions ) in…

Have you ever wondered how many DMVs are in SQL? Wondered whether a DMV exists which help diagnose your problems? Well I am going to show you how to list all the DMVs and DMFs so that you can do a deeper dive into them or await my series where I will be exploring eachContinue reading “How to list all SQL DMVs (Dynamic management views) s and DMFs (Dynamic management functions ) in…”

Use SQL to search a column for a range of values — Parv The IT Geek

Have you ever wanted to search for a column for a range of values? For example if you were searching for Product ID which ranges from 1 to 300, or look for a range of names starting A to D. Well I can show you how to do these quickly and easily by using theContinue reading “Use SQL to search a column for a range of values — Parv The IT Geek”

Search for a list of values using the IN command in SQL — Parv The IT Geek

Have you ever been presented with a list of values which need to be found in a column or wondered how to search for a list of exact names, addresses, numbers without using wildcard searches or ranges. Well SQL has the answer and it is the IN command. USE AdventureWorks GO SELECT * FROM HumanResources.DepartmentContinue reading “Search for a list of values using the IN command in SQL — Parv The IT Geek”

NULL Values — How to filter out NULLS and how to find NULLS using SQL — Parv The IT Geek

Well SQL has the solution and our saviour is the ‘IS NULL’ and ‘IS NOT NULL’ commands. Using them in a ‘WHERE’ clause will allow us to do the filtering out appropriately. USE AdventureWorks GO SELECT COUNT(*) FROM [AdventureWorks].[Person].[Address] The above query bring us a result of 19,614 rows contained within the AddressLine2 where noContinue reading “NULL Values — How to filter out NULLS and how to find NULLS using SQL — Parv The IT Geek”

AS — Use Aliases / Shorthand in SQL to make more readable queries — Parv The IT Geek

Have you ever wondered how I can make my SQL queries look more readable, manageable and simpler? Well the answer is to use the ‘AS’ command as this can alias tables. For example the below query can seem quite daunting with long table names. USE AdventureWorks GO SELECT HumanResources.Department.DepartmentID, HumanResources.Department.Name, HumanResources.Department.GroupName, HumanResources.Department.ModifiedDate FROM HumanResources.Department However,Continue reading “AS — Use Aliases / Shorthand in SQL to make more readable queries — Parv The IT Geek”

Intro to SQL Server Reporting Services 2008 : Report Builder 2.0 — Parv The IT Geek

This shipped after SQL Server Reporting Services 2008 and is available as a separate download. I have always run a search to download the latest installation file. Report Builder 2.0 is a too design to allow the easy and quick development of Reporting Services Reports and was created with the non-developer in mind. This isContinue reading “Intro to SQL Server Reporting Services 2008 : Report Builder 2.0 — Parv The IT Geek”

SQL Server Reporting Services 2008 (SSRS) Databases- ReportServer & ReportServerTempDB.

When reporting service is set up there are two default databases created which are 1. ReportServer 2. ReportServerTempDB. Reportserver database contains a wide range of information which is briefly listed below. 1. Subscriptions 2. Schedules 3. Data sources 4. Folder 5. Keys 6. History 7. Notifications and much much more. I would suggest looking atContinue reading “SQL Server Reporting Services 2008 (SSRS) Databases- ReportServer & ReportServerTempDB.”

Adding SQL Server Reporting Services 2008 — Parv The IT Geek

Adding SQL Server Reporting Services 2008 Before installing SQL Server Reporting Services 2008 it is important that you check whether your operating system is supported ( Windows Server 2003,2008,2012, some editions of XP, Vista, 7 and 8), you have sufficient RAM ( 512mb free), your CPU is powerful enough ( 1.0GHZ ) and if youContinue reading “Adding SQL Server Reporting Services 2008 — Parv The IT Geek”

How to order results in SQL? ORDER BY — Parv The IT Geek

A basic query of the HumanResources.Department table bring s the following results. If you wanted to reverse the order of the DepartmentID then you would need to user the ‘ORDER BY’ clause. The default sort is always ascending ( ASC) but it does not have to be explicitly written. If you want the order toContinue reading “How to order results in SQL? ORDER BY — Parv The IT Geek”