SQL Server - Oracle Architectural comparison
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,600 reads
Auto Shrink of all T-Log File on a SQL Instance - TSQL
This Script will shrink all the T-Log files of SQL instance if there is no active tracsaction on the database. The...
2012-08-02
2,650 reads
Replace NOT IN with JOIN
Example of how to replace NOT IN clause with JOIN
/*NOT IN query*/
USEAdventureWorks;GOSELECTProductIDFROMProduction.ProductWHEREProductIDNOTIN(SELECTProductIDFROMProduction.WorkOrder);
/*JOIN Query*/:-
SELECTp.ProductIDFROMProduction.ProductpLEFTJOINProduction.WorkOrderwONp.ProductID=w.ProductIDWHEREw.ProductIDISNULL;
2012-08-02
4,734 reads
SQL database Incremental Shrink TSQL
When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...
2012-08-02
12,647 reads
SQL security scripting - TSQL
SQL DBA often needs to script SQL Logins,Server roles,database users and Roles. Although its easy to script login,roles and users with...
2012-08-02
1,284 reads
Set Up SQL Server Mirroring T-SQL Script
T-SQL Script to create a SQL Mirroring:-
The first thing you need to do when setting up Database Mirroring is perform...
2012-08-01
20,328 reads
Blogs
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
The First Steps: Understanding the Basics of FinOps
By HeyMo0sh
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
Forums
would it be so terrible to install ssms on a few user desktops?
Hi, ssms is free here. I can think of other reasons to do this...
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers