An Overview of Memory Architecture - Oracle for the SQL Server Guy
A look at the memory architecture of SQL Server and Oracle, for those of you that may need to provide support for Oracle databases.
2012-02-13
3,316 reads
Blogs
Viewing the Statistics Objects Used to Create an Execution Plan
Use trace flag 8666 to view the statistics objects that the optimizer used to...
A Biography Template for New Presenters
By DesertDBA
Presenting is difficult, and you already know that. It is also incredibly rewarding and...
Goal Progress–Feb 2021
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
Forums
Problem with creating quri for alocating amount
good day i came a cross of a problem So i have a quri...
Problem with Logic for new column
Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...
pivot on 2 fields
I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a...
Ask SSC