Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
6 reads
Si vis pacem, para sql
Target Recovery Interval and Indirect Checkpoint
Introduction
The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
296 reads
Target Recovery Interval and Indirect Checkpoint
IntroductionThe process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
560 reads
Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
335 reads
Two new authentication options in SSMS 2016
Until SSMS 2014 there were the two standard authentication options for connecting to a SQL Server instance: Windows Authentication and...
2016-06-14
4,744 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
13 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...
2016-06-13
5 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
275 reads
The CHECK constraints unlike behaviours
The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create...
2016-06-13
320 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
8 reads
Blogs
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
Forums
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers