THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Search

You searched for the word(s):
Showing page 1 of 5 (49 total posts) < 1 second(s)
  • SQLBits XII

    Back home from SQLBits XII, back to normal life. However, I am already missing the conference. I have spoken with quite a few other speakers, and our conclusion is, as my friend Niko Neugebauer said: this conference is simply second to none. Great content, and very interesting split into three days: seminars if you wish to get more personal touch ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 21, 2014
  • Conferences – 2nd Semester 2014

    I am finishing my plan for conferences in the 2nd half of 2014. I think I will speak in most of them. Here is my list. 1. SQLBits 2014, July 17th-19th: high time to register, pre-conf seminars start in two days. I have an interesting pre-con seminar there Advanced Data Modeling Topics. In addition, I have a session as well. 2. Kulendayz 2014, ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on July 15, 2014
  • re: Data Modeling Resources

    Koen, that's what comments are for:-) Thanks, Dejan
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on June 11, 2014
  • Data Modeling Resources

    You can find many different data modeling resources. It is impossible to list all of them. I selected only the most valuable ones for me, and, of course, the ones I contributed to. Books Chris J. Date: An Introduction to Database Systems IMO a must to understand the relational model correctly. Terry Halpin, Tony Morgan: ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on June 10, 2014
  • Working with Temporal Data in SQL Server

    My third Pluralsight course, Working with Temporal Data in SQL Server, is published. I am really proud on the second part of the course, where I discuss optimization of temporal queries. This was a nearly impossible task for decades. First solutions appeared only lately. I present all together six solutions (and one more that is not a solution), ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on May 29, 2014
  • re: ALTER TABLE SWITCH [PARTITION] – DDL or DML?

    Mark, as I said, by the syntax, it is DDL. But you missed the main point: physical operation is not what defines the Relational Model, it is the logical action. So if there would exist only composable DML syntax and MS would not explain the physical action, this would be a DML for you?
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 6, 2014
  • ALTER TABLE SWITCH [PARTITION] – DDL or DML?

    My previous blog post Truncate Table DDL or DML Statement? got quite a few comments. Now I am continuing with a similar discussion: is the ALTER TABLE SWITCH [PARTITION] DDL (Data Definition Language) or DML (Data Manipulation Language) statement? At least it is clear that this is not a Data Control Language (DCL) statement. Again, I can find ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on April 6, 2014
  • re: Truncate Table – DDL or DML Statement?

    Brian, this is my point - it is a DML because logically, it does a DML operation. However, yes, because of many things it can be treated as a DDL statement as well. My preference is DML, because this is the main idea of the Relational Model &nbsp;- to work on the logical level and don't care what the underlying system is doing on the physical ...
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 31, 2014
  • re: Truncate Table – DDL or DML Statement?

    Koen, thank you for the comment. However, it does not convince me:-) Security is arbitrary selected. For example, in order to use some BULK INSERT options, you need ALTER TABLE permissions (http://technet.microsoft.com/en-us/library/ms188365.aspx). Does this make BULK INSERT a DDL statement?
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 31, 2014
  • re: Truncate Table – DDL or DML Statement?

    Lubor, thank you so much for your comment. I will write a next blog on this topic for the ALTER TABLE SWITCH soon.
    Posted to Dejan Sarka (Weblog) by Dejan Sarka on March 29, 2014
1 2 3 4 5 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement