SQL Server 2012 brings a new feature called Indirect Checkpoint. You can read more about it here: http://msdn.microsoft.com/en-us/library/ms189573.aspx. With Indirect Checkpoint, you get smaller and too many I/Os Checkpoint...

2013-03-19

23 reads

The end of the Internet, data and the PC

by administrator

The Future Computing Appliances and SQL Server

The Big Data revolution will be more important than the PC or the Internet. While there were many...

2013-03-04

11 reads

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

by administrator

SQLFeatures

2012-10-13

8 reads

Presenting PowerShell: Automating SQL Stats Collection

by administrator

SQLFeatures

2012-10-05

5 reads

All authors

Question of the Day

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)

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 Taylor

See possible answers

PASS SQLSaturday - speaking on -Streamlining SQL Server Implementations across organization-

Presentation DAC SQL Server Implementation Framework From Dev to Prod

SQL Server Implementation Frameworks From Dev to Prod

Presentation DAC -AlwaysOn Multisite Cluster Implementation In The Cloud-

Presenting AlwaysOn Multisite Cluster Implementation In The Cloud

9 resources not to be Skeptic about Big Data

SQL Server 2012: Indirect Checkpoint (Target Recovery Time), get the real scoop

The end of the Internet, data and the PC

Presentation DAC: PowerShell: Automating SQL Stats Collection for Performance Tuning

Presenting PowerShell: Automating SQL Stats Collection

Blogs

Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database

AgentDBA vs Critical SQL Server

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

Forums

Follow Your Hunch

What Happens When You Ask a Local AI to Query Your Database?

Detecting Characters

Question of the Day

Detecting Characters