ACID Rules in Sql Server
ACID Rules
ACID Rules:- It is a concept for evaluation of databases and their architecture.
A:- (Atomicity) – Atomicity states the principle of All...
2011-05-28
4,191 reads
Blog Posts
DML, DDL, DCL, TCL in SQL Server
Different Types of Sql Statements:-
DMLDML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert...
2011-05-28
11,722 reads
Restoring a database from higher version to lower version SQL server
AdvertisementsRestoring a database from higher version to lower version SQL server
How to downgrade a database from higher version to lower version?
There...
2011-05-28
3,035 reads
Using Views for Faster SQL Query Development
A discussion of how views give a more denormalized means for querying against normalized tables.
Ad-hoc reports are frequently requested at...
2011-05-28
844 reads
Re-blog – May 20-26
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-27
833 reads
Search Active Directory (AD) from your desktop
Ever see a Windows group and want to know all the users in that group without having to ask your...
2011-05-27
685 reads
SQL University Troubleshooting Week: Having a Plan for Every Situation
Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals...
2011-05-27
723 reads
Endpoints Need Privileges Too
Yesterday I delivered a session for the PASS DBA Virtual Chapter on Service Broker. In preparing for the session I...
2011-05-26
1,275 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I...
2011-05-26
585 reads
MCITP: 2 Down 2 to go
It’s time for the weekly update. Much like last week, we had more issues with taking this exam today. I scheduled exam 70-433 for first thing in the morning...
2011-05-26
4 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers