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
11,345 reads
xSQL blog
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 other things, I had do implement logic in the...
2017-04-19
3 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
2,055 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 that is frequently discussed in popular forums is a...
2017-02-06
2 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
205 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 Atom or RSS feeds containing any data that you...
2017-01-18
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
173 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 the messages on the output window show something like [16:08:11]...
2017-01-11
Documenting databases
Open any book or article about database development and administration, and I can all but guarantee that you will find a section for database documentation that describes its importance,...
2017-01-11
2 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
806 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...