SQL Server

More Topics

Excel Macro Creates INSERT Statements for Easy Data Migration

Excel Macro Creates INSERT Statements for Easy Data Migration Excel Macro Creates INSERT Statements for Easy Data Migration

Here’s a solution that lets you migrate data from Excel to SQL Server without having to manually create INSERT statements or use SQL Server Management Studio’s (SSMS’s) Import Data feature.

Mar 21, 2011

|

1 Min Read

ITPro Today logo

Market Watch: Scalable Data Warehousing Market Watch: Scalable Data Warehousing

byDerek Comingore

Mar 18, 2011

1 Min Read

ITPro Today logo

Do You Need a SQL Server Query Hint?Do You Need a SQL Server Query Hint?

byKalen Delaney

Mar 17, 2011

1 Min Read

ITPro Today logo

Fine-Tuning Plan Reuse Fine-Tuning Plan Reuse

Mar 16, 2011

1 Min Read

Simplifying Spatial Data

Early Versions (SQL Server 2000 – 2008)

Simplifying Spatial Data Simplifying Spatial Data

byKurt Survance

Mar 15, 2011

1 Min Read

ITPro Today logo

Parallelism in SQL Server Query Tuning Parallelism in SQL Server Query Tuning

byItzik Ben-Gan

Mar 14, 2011

1 Min Read

OFFSET/FETCH, Part 2

OFFSET/FETCH, Part 2

OFFSET/FETCH, Part 2

byItzik Ben-Gan

Paul Randal and Kimberly L. Tripp Offer an Inside Look at SQL Server Connections

Paul Randal and Kimberly L. Tripp Offer an Inside Look at SQL Server Connections

BI Appliances vs. Standard Servers and Reference Configurations

BI Appliances vs. Standard Servers and Reference Configurations

Early Versions (SQL Server 2000 – 2008)

Q: How can I tell how much memory SQL Server 2008 is using?

Q: How can I tell how much memory SQL Server 2008 is using?

New Products: Altova MissionKit, SQL safe 6.5, WhereScape RED Fast Track 3.0 Edition, WebFOCUS Mobile BI

New Products: Altova MissionKit, SQL safe 6.5, WhereScape RED Fast Track 3.0 Edition, WebFOCUS Mobile BI

byBrian Reinholz

sql server database design drawing

Database Design Essentials

Database Design Essentials

byMichelle A. Poolet

Innovations of the 2010s (SQL Server 2012 – 2019)

SQL Server 2012 T-SQL at a Glance – EXECUTE WITH RESULT SETS

SQL Server 2012 T-SQL at a Glance – EXECUTE WITH RESULT SETS

SQL Server Version Build Numbers

Early Versions (SQL Server 2000 – 2008)

SQL Server Version Build Numbers

SQL Server Version Build Numbers

man throwing javelin

Innovations of the 2010s (SQL Server 2012 – 2019)

SQL Server 2012 T-SQL at a Glance – THROW

SQL Server 2012 T-SQL at a Glance – THROW

exploding computer keyboard

Early Versions (SQL Server 2000 – 2008)

Upgrading to SQL Server 2008 R2

Upgrading to SQL Server 2008 R2

Boxer with red boxing gloves

Dynamic SQL vs. OPTION (RECOMPILE)

Dynamic SQL vs. OPTION (RECOMPILE)

byKimberly L. Tripp

Database Maintenance Scripting Done Right

Database Maintenance Scripting Done Right

byKevin Kline, SolarWinds

Visual Studio 2010 Database Tools

Visual Studio 2010 Database Tools

OFFSET/FETCH, Part 1

OFFSET/FETCH, Part 1

OFFSET/FETCH, Part 1

byItzik Ben-Gan

Microsoft’s David DeWitt on SQL Server Query Optimization

Microsoft’s David DeWitt on SQL Server Query Optimization

byMegan Keller, Michael Otey

Problems with Local Variables

Problems with Local Variables

byKimberly L. Tripp

Managing Multi-Select Parameters in SSRS

Managing Multi-Select Parameters in SSRS

Managing Multi-Select Parameters in SSRS

byWilliam Vaughn

A Practical Approach to Managing Database Size

A Practical Approach to Managing Database Size

byDejan Nakarada-Kordic

The Price of High Availability

The Price of High Availability

The Price of High Availability

What is the Best Value for the Fill Factor? Index, Fill Factor and Performance, Part 2

What is the Best Value for the Fill Factor? Index, Fill Factor and Performance, Part 2

byPinalkumar Dave

Red computer mouse sitting on jigsaw puzzle pieces

Unpivoting Data

Unpivoting Data

byItzik Ben-Gan

SSRS 2008 R2 and SharePoint 2010 Integration

Innovations of the 2010s (SQL Server 2012 – 2019)

SSRS 2008 R2 and SharePoint 2010 Integration

SSRS 2008 R2 and SharePoint 2010 Integration

byStacia Misner

Toad for SQL Server 5.0 Professional Edition

Toad for SQL Server 5.0 Professional Edition

byMichael K. Campbell

Q. I'm trying to install System Center Service Manager, but when it connects to the SQL database it gives a "User does not have permission" error. I'm an Administrator on the SQL box and on the SQL Server instance.

Q. I'm trying to install System Center Service Manager, but when it connects to the SQL database it gives a "User does not have permission" error. I'm an Administrator on the SQL box and on the SQL Server instance.

ITPro Today

What is Fill Factor? Index, Fill Factor and Performance, Part 1

What is Fill Factor? Index, Fill Factor and Performance, Part 1

byPinalkumar Dave

4 Ways to Purge Non-Partitioned Data

4 Ways to Purge Non-Partitioned Data

Software Development

Publishing Third-Party Updates to WSUS

Publishing Third-Party Updates to WSUS

byRussell Smith

Stored Procedure Generates INSERT INTO Statements for Transferring Small Amounts of Data

Stored Procedure Generates INSERT INTO Statements for Transferring Small Amounts of Data

byTomaz Kastrun

Welcome to (SQL Server) 2011

Welcome to (SQL Server) 2011

byKalen Delaney

Sign up for the ITPro Today newsletter

Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

Newsletter Sign-Up