Log Shipping By Abi Chapagai (Revised)
Log Shipping By Abi Chapagai (Revised)
In SQL Server, transaction log provides an ability to recover a database to a point...
2010-07-29
2,379 reads
Justin H-Davies
SQL Bits 7 – Registration is Open !
Registration is now open for SQLBits—The 7 Wonders of SQL Conference !!
This year its in York (Sept 30th till October 2nd).
SQLBits is...
2010-07-29
1,479 reads
SQL Server 2008 Replication: High Availability Solution Part One – by Abi Chapagai
Introduction
Replication is the process of copying data between two databases on the same server or different servers on the same...
2010-07-28
31,934 reads
“One of the Pack to Top Dog”
My first guest editorial published !
http://www.sqlservercentral.com/articles/Editorial/70725/
Would appreciate any comments you have.
2010-07-15
577 reads
Curb those Cursors !
With query performance becoming a constant battle, its often a forgotten fact that cursors should be avoided (in the majority...
2010-07-15
677 reads
Enabling Memory Support for over 4GB of Physical Memory
This is something we had to do again recently and its improved our performance and query speeds on one particular system....
2010-07-12
919 reads
Mix & Match – Day 4
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-12
375 reads
Mix & Match – Day 3
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-08
379 reads
Mix & Match – Day 2
I’ve been scouring my notes (old & new), wading through all my previous research and unearthing advice, tips & tricks that have...
2010-07-06
433 reads
Bin the unwanted to reap the rewards !
Looking through some of my databases this past week, theres a lot of data there which over time has become...
2010-07-04
432 reads
Blogs
What is KTLO? Keep The Lights On vs Project Work in Agile
By Rohit Garg
🔍 Demystifying KTLO: A Deep Dive into Keep The Lights On Work in IT...
The PASS Summit on Tour in Dallas
By Steve Jones
The PASS Summit goes on tour this year, with a September stop in Dallas....
SQL Server Auto-settings: The Good, the Bad, and the Ugly
By Kevin3NF
Settings That Could Be Hurting Your Performance If you’ve ever created a new SQL...
Forums
How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory
Comments posted to this topic are about the item How a Legacy Logic Choked...
Upgrading from 2012 to 2022
Hi, Would it be possible to upgrade from sql server 2012 sp4 to sql...
Has the PK been used --
Comments posted to this topic are about the item Has the PK been used...
Question of the Day
Has the PK been used --
You're analyzing a query execution plan in SQL Server to determine whether the query optimizer chose to use a primary key index. Which Dynamic Management View (DMV) would you use to verify the usage of the primary key in the plan?
See possible answers