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,648 reads
Eduardo Pivaral
- Website: http://www.sqlguatemala.com
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
228 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
201 reads
Add a custom report to SSMS
Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use...
2018-05-25
618 reads
Query to determine last statistics update for a database
Statistics are a vital part of SQL Server database engine, these are used for the query optimizer to create query...
2018-05-16
119 reads
Quick charts in SQL Server Operations Studio
Sample chart for quick insightsSQL Server Operations Studio will be a new tool for managing SQL Server, Azure SQL Database,...
2018-05-14
120 reads
Quick tip: Refresh IntelliSense cache in SSMS
If you work with multiple windows or make a change using SSMS to an object, sometimes IntelliSense does not reflect...
2018-05-08
283 reads
Security: Create and view Audit Logs
It is important to have a secure environment, enforcing the least privilege principle in your servers and databases, but this...
2018-04-30
5,414 reads
Quick tip: format source code in html
I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...
2018-04-25
100 reads
Configure Min and Max memory in Reporting Services
As any of the available SQL Server services, Reporting Services will use all of the server memory if needed, in...
2018-04-23
15,282 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers