zoggblog.com
SQL Server 2016 | TF3604 Blog
http://zoggblog.com/category/sql-server-2016
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. Category Archives: SQL Server 2016. Always Encrypted Storage Overhead. January 15, 2016. After creating a database along with a column master key and the column encryption key, I created four tables to store the encrypted data. Null, CharData varchar. Latin1 General B IN. Column encryp...
zoggblog.com
November | 2013 | TF3604 Blog
http://zoggblog.com/2013/11
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. Monthly Archives: November 2013. Hekaton concurrent updates: Large vs. small transactions. November 15, 2013. Here is another experiment that I performed with In-Memory OLTP (Hekaton) on CTP2 of SQL Server 2014. I started by creating a table and a sequence:. Schema only ). I then fired...
zoggblog.com
COUNT DISTINCT not supported in a windowing context (not documented) | TF3604 Blog
http://zoggblog.com/2014/01/07/count-distinct-not-supported-in-a-windowing-context-not-documented
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. COUNT DISTINCT not supported in a windowing context (not documented). January 7, 2014. As a trivial example, consider the following dataset:. Suppose we need to determine the number of customers associated to employee, and we need this result for each row. As the second error message m...
zoggblog.com
Hekaton concurrent updates: Large vs. small transactions | TF3604 Blog
http://zoggblog.com/2013/11/15/hekaton-concurrent-updates-large-vs-small-transactions
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. Hekaton concurrent updates: Large vs. small transactions. November 15, 2013. Here is another experiment that I performed with In-Memory OLTP (Hekaton) on CTP2 of SQL Server 2014. I started by creating a table and a sequence:. Schema only ). EmployeeId, Salary ). I then fired off the qu...
humblesql.com
Archives for November 2015 | Humble SQL Blog
http://humblesql.com/2015/11
Not as humble as I should be. But I now have you to hold me accountable. Create or Organize Your Script Library. SQL Agent – Powershell Task Appears To Do Nothing? SQL Express – How do I back this up? On Who Am I? Great Coworkers – Humble SQL Blog. FreeCon 2015 Humble SQL Blog. On My Favorite SQL Bloggers. Or Brent Ozar’s sp askBrent. But to me it works better for me than sp who. Or the undocumented sp who2. I am betting that there are some enhancements that would make this better, so please share them i...
humblesql.com
Work Environment | Humble SQL Blog
http://humblesql.com/category/work-environment
Not as humble as I should be. But I now have you to hold me accountable. Create or Organize Your Script Library. SQL Agent – Powershell Task Appears To Do Nothing? SQL Express – How do I back this up? On Who Am I? Great Coworkers – Humble SQL Blog. FreeCon 2015 Humble SQL Blog. On My Favorite SQL Bloggers. Since I put out a blog on Great Bosses. Last week, I felt like a good follow-on to that would be to talk about the other side of the coin….great coworkers. What makes a great coworker? February 3, 2016.
zoggblog.com
T-SQL | TF3604 Blog
http://www.zoggblog.com/category/t-sql
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. How I Create a Nums Table. March 15, 2016. You need a Nums or Tally table. You really do. OK, you can make do without, but having one really makes a lot of operations easier. My preferred way to create and populate a Nums tables is:. Not null, constraint. L0 a, l0 ). L1 a, l1 ). Finall...
zoggblog.com
SQL Server 2014 | TF3604 Blog
http://www.zoggblog.com/category/sql-server-2014
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. Category Archives: SQL Server 2014. Hekaton concurrent updates: Large vs. small transactions. November 15, 2013. Here is another experiment that I performed with In-Memory OLTP (Hekaton) on CTP2 of SQL Server 2014. I started by creating a table and a sequence:. Schema only ). I then fi...
zoggblog.com
Brian Hansen | TF3604 Blog
http://www.zoggblog.com/author/brian
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. All posts by Brian Hansen. October 31, 2016. Not null, Salary money. Not null, constraint. Ix Employee Salary on. FirstName, Salary ). The task at hand is to give all employees with a salary of less than 25,000 a 10% raise. This can be accomplished with a simple query. Without Hallowee...
zoggblog.com
May | 2015 | TF3604 Blog
http://www.zoggblog.com/2015/05
SQL Server Log File Visualizer. SQL Server Parse Tree Viewer. Presentation: Create a Simple Operational Data Store. Presentation: Get Your Optimizer to Give up All Its Secrets. Presentation: Visualize Your Transaction Log. Monthly Archives: May 2015. SQL Server 2016 CTP2 Initial Impressions: Temporal Table Performance. May 29, 2015. One of the interesting new features that I came across within CTP2 of SQL Server 2016 are the new Temporal Tables. Col2 DATETIME2 ,col3 INT. Col2 DATETIME2 ,col3 INT. If you ...