AlwaysOn Availability Groups made their initial appearance in SQL 2012 and have generated a lot of buzz, HA and DR in one! Even with AGs, still integral to your...
2015-04-06
2 reads
Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The...
2015-03-13
391 reads
Today I am excited to announce that I have been accepted into the Friends of Redgate program for 2015. The program targets influential people in their respective technical communities...
2015-03-13
1 reads
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to...
2015-02-24
605 reads
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one...
2015-02-24
3 reads
Here are my unedited chapter notes:
Chapter 1Chapter 2Collation – current version requires BIN2 on character index columns. Best to do so...
2015-02-24
752 reads
Here are my unedited chapter notes:
Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do...
2015-02-24
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions...
2015-02-11
478 reads
Often I’m asked what is the best practice for a single SQL Server installation. Well, that is a tricky questions and the answer is it always depends. Let’s discuss...
2015-02-11
Let’s just start withthe last three years have been fantastic! This blog post is a slight deviation from the technical...
2015-01-30
733 reads
Have you ever wondered where a certain field is used in a report? Or...
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Comments posted to this topic are about the item A Strange Query
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
I am using the following script to import data from a json file. This...
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers