Happy New Year Friends
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
4 reads
Wishing all of you a very Happy New Year. May GOD bless all of you with lots of Success and Happiness.
2016-01-01
4 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some...
2015-12-31
1,397 reads
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server,...
2015-12-31
12 reads
Wishingyoua very
HappyIndependenceDay
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific...
2015-08-15
738 reads
Wishing you a very
Happy Independence Day
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made....
2015-08-15
6 reads
Sometime we need to find all the triggers defined on the database. So in this case, we can use the...
2015-08-14
1,675 reads
Sometime we need to find all the triggers defined on the database. So in this case, we can use the below SQL Query:-SELECT tbl.name as [Table Name] ...
2015-08-14
10 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we...
2015-08-13
6,971 reads
Through this article, we are going to discuss three important interview questions of SQL which are given below:-
1) Can we create clustered index on a column containing duplicate values?
2) Can we create...
2015-08-13
9 reads
Suppose we have a table emp_plan which contains 4 columns "Empid" (employeeid), Planid (Projectid), Startdate(Allocation Start date) and Enddate (Allocation Enddate)....
2015-08-03
668 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The Samsung Galaxy A37 is gaining attention among smartphone users who are interested in...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers