Key Sets, or Inverted Keys - defining a key as a set of tuples
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
448 reads
TL;DR:
I have been doing a lot of thinking about data models for the last couple of weeks. I have, just...
2017-12-19
448 reads
Just a quick one today. TL;DR: Remove yourself from some unnecessary AD groups.
If you've ever received the message "login failed...
2017-11-24 (first published: 2017-11-12)
3,342 reads
If you're seeing this for the second time, my apologies. I wanted to update the title but had to delete...
2017-11-13
2,317 reads
Tricky triggers
In my last entry I noted that the performance of "instead-of" triggers can be tricky.
One of the reasons for...
2017-11-07
552 reads
I'm working on problems of enterprise data integration in the role of enterprise architect, but I am and have been...
2017-11-06 (first published: 2014-11-19)
6,357 reads
Defining the Problem
Imagine I have two different systems - say, a CRM and an ERP - on different SQL Servers. Both systems...
2017-11-05
456 reads
Update:
After all of this SMO stuff failed (changing the permission set to unsafe got around the security exception, but instead...
2011-06-15
1,459 reads
Relation Types
create type type_T(i int primary key clustered, j int check (j > 0)) -- relation type. Includes constraints!
create table T(type_T)
Relvar Assignment
This...
2011-06-15
944 reads
SSMSDeploy version 1.5 is ready. This one has a LOT of GUI tweaks. No database changes in this one, so...
2011-01-22
947 reads
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
704 reads
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
By Steve Jones
It’s that time of the month again, when the T-SQL Tuesday blog party takes...
By alevyinroc
I’m hosting T-SQL Tuesday this month and our topic is Managing SQL Agent Jobs....
Hello everyone! I’m currently looking for professional book publishing services that can help me...
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers