An empty password on sa is a serious security failure. I stopped an e-commerce consultation after noticing passwordless administrator sign-ins.
WITH NORECOMPUTE: Stop Auto Updates on One Table
WITH NORECOMPUTE tells SQL Server to stop updating the statistics of one table automatically. This post sets it with UPDATE STATISTICS, proves that the modification counter keeps growing while nothing refreshes, and shows how to turn it off again. It also shows a safer option for the same problem, a persisted sample percent.
Connections by Protocol: Shared Memory, TCP and Named Pipes
Connections by protocol tell you whether a client reaches SQL Server through shared memory, TCP or a named pipe, and from which address. This post reads the connection view for your own session, connects three ways to see each protocol, lists every connection with its host and program, and counts them by protocol.
Execution Plan Wait Stats: Read Them in SSMS and XML
Execution plan wait stats list what one execution of a query waited for, so you don’t have to guess from server-wide totals. This post shows where to find them in SSMS and in the plan XML, reproduces a lock wait with two query windows, and explains the common wait types. It ends with Query Store, which keeps wait totals for many queries.
Does BIT Datatype Equal to 1 or TRUE in SQL Server? – Interview Question of the Week #282
Question: Does BIT Datatype Equal to 1 or TRUE in SQL Server?
Answer: Very interesting question. Let us learn about it today.
Multiple Aggregates in One Query: Read the Table Once
Multiple aggregates in one query read a table once, where separate subqueries read it again and again. This post measures the logical reads of two subqueries against one SELECT, uses CASE inside SUM for different filters, and shows two cases where the rewrite gains nothing or loses to an index.
SQL Puzzle – IN and IS NOT NULL – Strange Results
Today, let us see a very simple puzzle where we are getting strange results when using NOT IN and IS NULL in a T-SQL query.