This week I was reading Pinal Daves post about Autogrowth Events
http://blog.sqlauthority.com/2015/02/03/sql-server-script-whenwho-did-auto-grow-for-the-database/
as it happened I had a requirement to make use...
2015-02-25 (first published: 2015-02-15)
6,270 reads
It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting....
2015-02-25
1,297 reads
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to change things dramatically. In-Memory OLTP (Hekaton) is one...
2015-02-24
15 reads
In-Memory OLTP – a potential game changing technology
Every once in a while a technology comes out that has the potential to...
2015-02-24
621 reads
Here are my unedited chapter notes:
Chapter 1 Chapter 2 Collation – current version requires BIN2 on character index columns. Best to do...
2015-02-24
18 reads
Here are my unedited chapter notes:
Chapter 1Chapter 2Collation – current version requires BIN2 on character index columns. Best to do so...
2015-02-24
768 reads
I would like to introduce a “new” blogger to you. Joshuha Owen has restarted his blog and will be covering...
2015-02-24
752 reads
Determine the table dependencies is challenging sometime but we can easily resolve this by using a simple stored procedure which ...
2015-02-24
532 reads
Security is always a concern for every database developer. How to secure valuable information is one of the major and...
2015-02-24
432 reads
There are a number of ways that you can identify blocking that is occurring in your SQL instance. You can...
2015-02-24
373 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers