Filegroup Restoring and Join Elimination
This article is just a short follow up of previous article on filegroup restoring that describes one issue with join elimination optimization.
2017-08-10
960 reads
FileGroup
Filegroup Restoring and Database Consistency
In this article, we'll explore a less used feature of SQL Server: filegroup restoring, feature that has an interesting consequence because database can become inconsistent without any warning and standard checks don't reveal any issue.
2017-06-27
2,778 reads
RE: UPDATE not working
Ross,You still need a Primary Key to be able to determine which of the duplicates gets the First id or the second or the thrid ...For example:person_ididentification_idid_codeclass_codestatus_codegood_flagproc_typeid_number279864 MC# P039619 390500 MC# 487968314814 MC# 272614354545 MC# 389499354545 MC# 389499365062 MC# 417392316109 MC# 227649340139 MC# 227649317049 MC# 278249348927 MC# 374367 of the two higlighted rows how would you tell which gets 1 and which gets 2 ?
2005-04-28
RE: Which Query is Right?
After some additional testing, it looks like query 1 is correct:select s.suiteid, s.buildingid, s.SuiteName, b.buildingnumber, g.suitename, g.buildingID from suites s inner join buildings b on s.buildingid=b.buildingid LEFT JOIN RealmStageSuites g on g.buildingid=b.buildingnumber AND g.suitename=s.suitename WHERE g.suitename IS NULL AND g.buildingID is NULLAnyone know what's wrong with Q2?
2005-02-04
RE: SQL to trigger an ASP file
Hi,I've implemented something similar to what you're asking for. I use the Windows Scheduler on our server to launch internet explorer with the URL of an ASP page every day.That ASP page looks in our database to see if anything needs doing, then does it!Good luck!- Chris
2005-01-27
Blogs
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
T-SQL Tuesday #176: That Piece of Technical Advice for the Past Me
By DataOnWheels
DIVERSIFY! We devote a lot of time to mastering the technology that we are...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers