SQL Server: Functions vs. Stored Procedures to return result sets
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
9,252 reads
SQL Server: DATETIME vs DATETIME2
When it comes to a choice between data types for a field in a SQL Server database's table, an issue...
2017-02-06
1,800 reads
Fastest way to create and distribute a dynamic report from SQL Server
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
177 reads
Tables can't be compared
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
167 reads
Database synchronization in the Software Development Life Cycle
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
741 reads
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
313 reads
Comparing and synchronizing Oracle databases
Applies to: xSQL Oracle Data Compare v1.0 - 2.0
As you may have noticed, most of the articles in this blog focus...
2016-11-22
535 reads
How to deploy your SQL Server database to a remote server
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
1,119 reads
Comparing xSQL Schema Snapshots
Applies to: xSQL Schema Compare v7.0.0 – 9.0.2
Before I develop a scenario where xSQL Schema Compare snapshot comparison is necessary let’s...
2016-11-07
341 reads
Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
180 reads
Blogs
Daily Coping 23 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Cloud Formations – A New MVP Led Training Initiative
By Kamil
Hello, data friends! Let me spread a few words about the new MVP led...
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Call multiple packages based on result set of the query
Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...
LDF is not automatically shrinked with simple recovery mode
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...
Best way to learn T-SQL for MS SQL Server?
Hello Everyone, At work, I've been getting more involved with hosting and database stuff....
Ask SSC