Experiment: Does sp_recompile on a table update associated views.
tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the ... Continue reading
2021-09-01 (first published: 2021-08-17)
319 reads
Pure Storage Links
SQL Server Pure Storage SQL Server Platform Guides Pure Storage SQL Server Best Practices Pure Storage SQL Server Scripts on GitHub Pure Storage ActiveCluster with SQL Server Azure...
2021-08-17
47 reads
Meet the Customers We’re Featuring at the WordPress.com Growth Summit
We are proud to feature Jessica Petrie of Yoga Next Door, HBCU Gameday, and other inspiring customers at the second Official WordPress.com Growth Summit, on Tuesday, August 17.
2021-08-16
38 reads
Become a Beginner at Data Science with the WIT
I’m a beginner in data science. I know a lot of general things about the field, but I’m really a beginner in most ways. This Friday, 20 Aug 2021,...
2021-08-16
36 reads
Daily Coping 16 Aug 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-16
27 reads
Divide the rows in equals batches
Here is the simple and practical use case of NTILE function. We’ve used it to divide the rows of sys.columns into N batches. N is the batch size. We’ve...
2021-08-25 (first published: 2021-08-15)
2,142 reads
SSMS and SQLCMD: Prevent T-SQL Batch From Not Only Executing, but Also From Parsing (Cruel Joke #3)
(last updated: 2021-08-13 @ 19:50 ET / 2021-08-13 @ 23:50 UTC ) In a previous post, Prevent Full Script Execution (Understanding and Using PARSEONLY and NOEXEC), I explained how...
2021-08-25 (first published: 2021-08-13)
533 reads
How I carved up 18TB of Storage
In a previous post I told you about how I got a Synology DS920+ on loan to play around with. The device comes with 4 drive bays so there...
2021-08-13
18 reads
How I carved up 18TB of Storage
In a previous post I told you about how I got a Synology DS920+ on loan to play around with. The device comes with 4 drive bays so there...
2021-08-30 (first published: 2021-08-13)
420 reads
Daily Coping 13 Aug 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-08-13
22 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
Alamat Kontak Bank BCA KCP Ciawi Telp:08218154393
WA:08218154393 Jl. Raya Ciawi No.151, Pakemitan, Kec. Ciawi, Kabupaten Tasikmalaya, Jawa Barat 46156
Alamat Kontak Bank BCA KCP Pati Telp:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.74, Pati Kidul, Kec. Pati, Kabupaten Pati, Jawa Tengah 59114
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers