Using sysforeignkeys to discover SQL Server circular relationships. Have you ever tried this? Most of us probably haven't, but Jeffrey Yao often needs to reverse engineer databases for his clients. Here's a followup to his first article where he presents another of his techniques for doing a little detective work in your databases.
2004-06-30
7,102 reads
SQL Server has a great backup and recovery architecture, but you have to know how to properly configure and use the server to ensure that you will not be seeking new employment anytime soon. A few of the Sonasoft team have written this short piece on strategies for setting up your backup jobs to ensure recovery in the event of a disaster. Welcome new authors Bilal Ahmed, Kiran Kumar, and Vas Srinivasan.
2004-06-29
19,277 reads
SQL Server has an abundance of third party tools, more being developed everyday. Indepth for SQL Server allows you to monitor the performance and activity on your SQL Server. New author Hiram Khakharia looks at this product from Veritas.
2004-06-25
5,011 reads
A key service pack has now been released for Microsoft SQL Server Reporting Services. This one adds key enhancements and fixes many bugs.
2004-06-25
1,937 reads
The Unique Identifier datatype in SQL Server has tremendous potential to solve many of the issues one finds with Identity fields, other primary keys, etc. However it also has some drawbacks and limitations. Author Sharad Nandwani looks at some of the pros and cons of this datatype.
2004-06-24
14,016 reads
How many of you dig into Windows XP extensively? Working with hardware and the OS isn't something that many DBAs deal with these days. Most companies have an admin to work on servers, hardware, workstations, etc. But sometimes you need to help yourself out. Steve Jones had to work to get his laptop back after an XP disaster. Read on and hopefully this will help you one day recover your system.
2004-06-23
5,898 reads
In this follow up Andy looks into some of the options available when you're dealing with situations where you're joining a case sensitive column to a case insensitive column. We think after reading this you'll be ready to just say no!
2004-06-22
8,355 reads
SQL Server backups are rock solid. But checking them is another matter and something that every DBA is responsible for doing. Another followup article by new Author Kevin O'Donovan to the issue of looking at which database
2004-06-21
6,791 reads
The SQL Server ports 1433, was blocked recently by an ISP. New Author Denny Figuerres read our release and decided to bring you some comments about why this isn't such a bad idea. Read on and see if you agree that blocking the SQL Server ports shouldn't present you any problems.
2004-06-18
9,226 reads
See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.
2004-06-15
7,379 reads
By Steve Jones
Next week is the 2024 PASS Data Community Summit in Seattle. I’ll be traveling...
By Steve Jones
bye-over – n. the sheepish casual vibe between two people who’ve shred an emotional...
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Comments posted to this topic are about the item PASS Summit Time
I have a backup of full, differential and transaction log setup for our database....
Hello everyone, I hope you can help me. I have a table with measurement...
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers