Blog: Guy Glantser

209 blogs updated: 45 min. ago
How to Update @@SERVERNAME to Actual Machine Name?
The @@SERVERNAME Global Variable The system global variable @@SERVERNAME can be used to return the name of the machine the SQL Server is hos...
07-12-2017 15:18:54 Guy Glantser SQL Server
Why is the job duration a negative number?
About a month ago I noticed, on one of our clients' server, a weird duration time for one of the jobs the job duration was negative. As [ ] ...
02-12-2017 17:33:09 Guy Glantser SQL Server
How to Calculate Running Totals in SQL Server
In show #84 of the SQL Server Radio Hebrew Edition, Matan and I talked about how to calculate running totals in SQL Server. I promised to up...
19-11-2017 11:51:53 Guy Glantser SQL Server
Customer Satisfaction Survey Results
In the last couple of months, we sent our first customer satisfaction survey to all our customers. We collected the responses, analyzed them...
18-11-2017 20:04:11 Guy Glantser SQL Server
What is the Role of the UPDATE Lock in SQL Server?
The most common types of locks in SQL Server are the SHARED (S) lock and the EXCLUSIVE (X) lock. The former is used to lock resources (e.g. ...
18-11-2017 10:49:40 Guy Glantser SQL Server
Something cool we learned today!
We have many customers, and we work on lots of projects. Each project is different in so many ways: the business environment, the system arc...
17-11-2017 06:27:44 Guy Glantser SQL Server
Can I pause or resume an index rebuild operation?
One of the cool new features in SQL Server 2017 (and currently also in public preview in Azure SQL Database) is the option to pause and resu...
16-11-2017 23:50:22 Guy Glantser SQL Server
Why I Believe in the Data Architecture Review
We have a solution called Data Architecture Review. With this solution, we conduct a complete review of the customer's data environment. We ...
23-10-2017 18:03:37 Guy Glantser SQL Server
Customer Satisfaction Survey
We decided to create a customer satisfaction survey and send it to all our customers. The goal of this post is to share the story about our ...
01-09-2017 11:48:56 Guy Glantser SQL Server
The 10 Basic Concepts of T-SQL
For the end of the latest Basic Querying and Programming in SQL Server course, I prepared a list of the basic concepts I recommend the stude...
29-08-2017 17:24:37 Guy Glantser SQL Server

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.