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
10,746 reads
A while back, I was building the database schema for a web application which had some reporting functionality and among...
2017-04-19
10,746 reads
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,022 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
196 reads
"I am trying to compare two databases and xSQL Data Compare has marked all table pairs with a red X and...
2017-01-11
169 reads
Reading the title, most of you are probably thinking: What does database synchronization have to do with the Software Development...
2016-12-12
798 reads
Open any book or article about database development and administration, and I can all but guarantee that you will find...
2016-12-01
329 reads
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
540 reads
CASE 1: you have direct access to both the SQL Server where the source database is and the SQL Server...
2016-11-11
1,932 reads
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
344 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
184 reads
A couple of days ago I was doing some cleaning on some Azure SQL...
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse....
Have you ever wanted to filter a visual by selecting a range of values...
Not sure if this is the place to ask, but will give it a...
Is there a specific platform or website where I can verify the compatibility between...
Comments posted to this topic are about the item Truncate tables where Referential Integrity...
I backup the Resource database from my SQL Server 2022 instance. I then install CUs 1, 2, 3, and 4. I have an issue and need to restore my Resource database from backup. Is there anything I need to do after restoring this database?
See possible answers