Should You Use Index Hints?
Watch this week's video on YouTube
One of the things that the SQL Server query optimizer does is determine how to retrieve the data requested by your query.
Usually it does...
2018-07-31
8 reads
Blog Posts
SQL Operations Studio: Keyboard Shortcuts, Actual Plans, & More
Last week I posted a quiz on SQL Operations Studio, a free, multi-platform tool from Microsoft. This tool is under active development and the features are improving by the day...
2018-07-31
27 reads
SQL Server – Blocking a Truncate
The truncate option is fast and efficient but did you know that it takes a certain lock where you could...
2018-07-31
557 reads
The need for having both a DW and cubes
I have heard some people say if you have a data warehouse, there is no need for cubes (when I...
2018-07-31 (first published: 2018-07-20)
3,229 reads
Are you a morning or evening person?
I am not a morning person. I’ve really tried but there’s something in me that just stops me from getting...
2018-07-30
313 reads
Coming Back After complete 3 Years
Friends/My Readers,
Its been a long i have been away from my blogging.When i see back Its exactly 3 yrs Today(30/July/2015...
2018-07-30
317 reads
Forcing Execution Plan
Very rarely there is a need to force an execution plan and even more rarely we should be doing it....
2018-07-30 (first published: 2018-07-20)
13,332 reads
SQL Server Availability Group Auto Seeding Error
SQL Server Availability Group Auto Seeding is a wonderful thing, it saves database administrators time when setting up availability groups. ...
2018-07-30
703 reads
The Failed One Laptop Per Child Project
I wrote about OLPC back in 2010 (and before that, somewhere back on a post I didnt port over here...
2018-07-30
341 reads
ArcGIS Maps for Power BI: Plus subscription (2nd part); What's in it for me?
(2018-July-29) My initial attempt to explore and test the ArcGIS Map paid version continued after receiving a response from the...
2018-07-29
397 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