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
323 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
715 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
151 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,531 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
130 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
155 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,689 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,571 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
203 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
188 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers