Data Manipulation Language
In this blog post we describe what is Data Manipulation Language (DML) and include this article in our exam guide...
2012-07-07
307 reads
In this blog post we describe what is Data Manipulation Language (DML) and include this article in our exam guide...
2012-07-07
307 reads
I thought I will share my experience how you can get identity value after insert using SQL Server. I have...
2012-07-03
619 reads
Today I had to write T-SQL code to convert date into very specific date format (Mon, 02 Jul 2012 19:24:05...
2012-07-02
369 reads
In this article we cover three reasons for normalization (from our point of view). We created the article and included...
2012-07-02
277 reads
I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.
2012-07-01
953 reads
In this blog article I will give an overview of performance tuning based on common situation that occur on small...
2012-07-01
452 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
This is one I haven't seen before. I'm trying to drop a database user...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers