Re-blog – January 13 – January 19
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-20
564 reads
Blog Posts
Rename an Analysis Services Instance
This is just a short post for Friday. I have been working a fair amount with SSAS and the rest...
2012-01-20
5,386 reads
S3OLV – Jan 2012 Meeting Recap
Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a...
2012-01-20
626 reads
S3OLV – Jan 2012 Meeting Recap
Last week (Jan 12, 2012), we held the user group meeting for the SQL Server Society of Las Vegas (a.k.a S3OLV or SSSOLV). Presenting at that meeting was Josh...
2012-01-20
SQL Cachestore flush
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,153 reads
The top 5 reasons to speak at SQL Rally
Have you been thinking about speaking at the upcoming SQL Rally in Dallas? If so, remember that the deadline for...
2012-01-20
736 reads
Unlimited Vacation
Unlimited Vacation sounds good, and maybe it works, but I wonder how much vacation people really take at Red Frog....
2012-01-20 (first published: 2012-01-12)
2,285 reads
Case Sensitive searches in T-SQL
I just ran into an issue with one of my applications where a SQL statement had updated a status code...
2012-01-19
2,681 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that...
2012-01-19
966 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that those functions were in some DMOs and that you...
2012-01-19
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
Python with SQL 2022 Enterprise doesn’t work
I have installed Machine Learning with SQL 2022 Enterprise Edition and installed and configured...
A Guide to SQL Security in Django
Comments posted to this topic are about the item A Guide to SQL Security...
I Need a CS Degree. I Don't Need a CS Degree
Comments posted to this topic are about the item I Need a CS Degree....
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers