Performance Basics: Indexed views
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
328 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
Announcing new Guatemala SQL Server user group
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
723 reads
Determine SQL Server Network Protocol Information using T-SQL and DMVs
I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...
2018-08-09
174 reads
Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,542 reads
PowerBI: Implement a What If parameter
Our Guinea Pig DashboardPowerBI is focused on creating interactive, analytical reports, from a lot of different data sources and with...
2018-07-17
144 reads
Display SELECT query or table as HTML
This post is part of #tsql2sday event :)For my current job I support a lot of SQL Servers, they come...
2018-07-10
310 reads
Saving disk space by choosing the correct data type
"Database is almost 4 TB in size, user is complaining on long times for DEV data refresh and high storage...
2018-07-03
1,730 reads
Check instant file initialization and lock pages in memory options
Study your server reports do the work for you!
Instant file initialization and lock pages in memory are 2 windows operating...
2018-06-28
2,634 reads
What it is Page Life Expectancy (PLE)
Which cup will you prefer to go the less
number of times to the coffee maker?image was taken from hereLet us...
2018-06-21
214 reads
Collation considerations to create robust queries
Is your code "This" robust?What is Collation? In short words: are the sorting rules, case, and accent sensitivity properties for...
2018-06-11
194 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers