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,555 reads
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,555 reads
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,646 reads
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,717 reads
When we shrink a SQL database through GUI we usually find the database never releases all the free space, It...
2012-08-02
12,532 reads
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,280 reads
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,317 reads
By Brian Kelley
I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...
By Steve Jones
I had a customer recently reach out to ask if SQL Clone would work...
Ollama SQL FastStart kit just works out of the box. It makes it easy...
Comments posted to this topic are about the item Create an HTML Report on...
How important to SQL Server is the speed of the SSD and network latency?...
In SQL Server 2022, how many backup files can I have in a striped backup?
See possible answers