It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.
2014-10-14
9,933 reads
Trying to determine if you have pressure in your buffer allocations can be difficult. This metric reliably indicates if you have a buffer problem using the memory dump from DBCC MEMORYSTATUS() and comparing Target Committed to the Current Committed allocations. If you hit negative numbers you are looking at a buffer issue.
2014-10-14
6,901 reads
As working hours in tech trend upwards, we look at some ways to make life easier.
2014-10-13
133 reads
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
2014-10-13
3,539 reads
Join the world's largest gathering of SQL Server and BI professionals in Seattle on November 4-7. PASS Summit is your conference – planned by and for the SQL Server community. Red Gate will be exhibiting, so drop by their booth and say hello. Register while space is available.
2014-10-13
8,510 reads
Greg Larsen shows you a number of different ways to use the UPDATE statement to modify the data in your SQL Server tables.
2014-10-13
10,280 reads
With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.
2014-10-10 (first published: 2012-08-13)
19,161 reads
With the release of SQL Server 2014 there came a lot of new features, including “In-Memory OLTP”. One would assume that storing a table in memory would most definitely be faster than using the conventional disk-based table storage engine. But just how much faster is it?
2014-10-10
8,756 reads
2014-10-09
30,308 reads
The public perception is that, when something is deleted, it no longer exists. Often that's not really the case; the data you serve up to the cloud can be stored out there indefinitely, no matter how hard to try to delete it. Rob Sheldon investigates, and finds the cloud a worryingly public place.
2014-10-09
8,992 reads
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Comments posted to this topic are about the item Fixing P1 Queries
Comments posted to this topic are about the item Symmetric Key Encryption
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers