SQL Server – Temporary Tables

SQL Server temp tables are very useful for temporary modifications or transformations to data that we do not need to keep rather than manipulate or work with permanent tables. Let’s say you want full DDL or DML access to a table, but don’t have it. You can use your existing read access to pull the data into a SQL Server temporary table and make adjustments from there. Read More …

SQL Server – Creating linked server in SQL Server Management Studio

In SQL Server environments the linked server functionality is commonly used to connect to another (remote) database or file (Xls, CVX) using SQL Server Management Studio (SSMS) and access and use the remote data and objects. Read More …

SQL Server – Performance Best Practices

Talking about SQL Server optimization, query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level Read More …

SQL Server Management Studio – Exporting CSV

Microsoft SQL Server Management Studio is a commonly-used bit of the Microsoft SQL Server installation, and a decent enough tool for browsing, querying and managing the data. Read More …

Exporting Data From SQL Server to Script File

SQL Server provides the ability to generate scripts for creating databases, tables, stored procedures, functions, views and inserting data. For Read More …