Comparing some differences of SQL Server to SQLite
What are some of the differences in the way that Microsoft SQL Server and SQLite implement the SQL Language? Read this tip to learn about some of the differences.
Tim Wiseman is a SQL Server DBA and developer in Las Vegas with over 6 years of database experience. He holds a BS in mathematics along with MCDBA and MCITP certifications. In his nearly nonexistent free time, he attends grad school, plays Go, enjoys time with his wonderful wife and kids, and writes about technical topics. His LinkedIn profile is available here. And his new blog is on Wordpress.
Introduction to Subqueries in SQL Server
How and when should I use subqueries while working with Microsoft SQL Server? Under what circumstances should I use subqueries in SQL Server? In this tip we look at the best way to use subqueries.
Using a SQL Server Case Statement for IF/Else Logic
Learn different ways of using the SQL Server CASE statement to simulate if/else logic.
Max, Min, and Avg SQL Server Functions
How do I find some of the basic descriptive statistics of a column such as the maximum, minimum, and average values in SQL Server with T-SQL code? Can you provide some examples?
Different Methods to Sort SQL Server Result Sets
I have a need to get more creative with the way my SQL Server results sets are returned based on user needs. Read this tip to learn about other ways to use the ORDER BY clause to control how data is returned.
Count of rows with the SQL Server COUNT Function
What is the best way to find the number of rows in a SQL Server table? What are various options in SQL Server to get a count of rows? Can you provide any examples?
SQL Server Performance Considerations – Fetching Rows One By One or All At Once
When accessing a SQL Server database from within a programming environment, some tools allow the option of retrieving the results of a query one row at a time or fetching all rows at once. When is each option a better choice?
Programmatically changing SQL Server linked tables in Microsoft Access
Read this to tip to learn how to programmatically change SQL Server linked tables for an MS Access database.
Merge parent and child SQL Server tables that use identity keys
Merge two similar tables from different SQL Server databases and also merge child tables that are connected by foreign key relationships without causing foreign key constraint issues.
Python and Regex for SQL Server ETL with Non-Standard Text Files
SSIS is a remarkably efficient and powerful tool for importing data into SQL Server, but there are times when it is more convenient to use Python to handle non-standard text files due to familiarity with Python or compatibility with preexisting code. In t
Getting SQL Server Metadata With Python
Metadata is invaluable when dealing with SQL Server and in this tip we look at how to bring SQL Server metadata into a Python based Program.
Comparing SQL Server Datatypes, Size and Performance for Storing Numbers
When more than one numeric datatype may be suitable for a field in a project, which data type should I choose? What implications might the choice of datatype have for storage and performance? In this tip, we look at the impact of datatypes for storing num
SQL Server Operations from Set Theory
SQL Server provides the UNION, EXCEPT, and INTERSECT set operations. How do they work and how can they be used in SQL Server? Can you provide any examples? Check out this tip to learn more.
When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes
SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs t
Using Parameters for SQL Server Queries and Stored Procedures
This tip examines ways to build a parameter query and how to use SQL parameters in SQL Server for queries and stored procedures.
Silent Truncation of SQL Server Data Inserts
There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.
Plotting SQL Server Data for Data Visualization
The best way to understand data is often to visualize it through a graph or chart. While SQL Server includes SSRS as a Business Intelligence tool, SSRS is not always the best option for providing data visualization nor is it always avaialble to use. This