Coding By The Sea
An interesting experiment at Red Gate, Coding By the Sea, produced results, and Steve Jones thinks this could be a great idea for other companies.
Easy Error Trapping When Using xp_cmdshell
Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.
13 Things You Should Know About Statistics and the Query Optimizer
Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a mention of Brazilian Soccer stars and young ladies on Copacabana beach. You'll never quite think of statistics, execution plans, and the query optimiser the same way again after reading this, but we think you'll understand them better.
But We Have Always Done It That Way
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
How to use sys.fn_PhysLocFormatter undocumented function
It would be nice if we could use the DBCC PAGE command to see exactly what it is stored at the page level, however, in order to do this we need to find a way to correlate the results returned from a SELECT statement with the physical data location. Is that possible? The answer is: YES. All we need to do is use the sys.fn_physLocFormatter function. In this tip, I will cover how to use this undocumented function.
PASS AppDev Presents: SQL Server Indexing
While indexing traditionally has been the concern of the DBA, it's important for developers to understand both the usefulness and the impact of indexes in your relational database. With the right indexes your application will perform like a Formula One racer, without them performance will better resemble a Model T. This presentation will explain how indexes work, what options are available to you in SQL Server 2008, and how to tune your application and your database for the best performance.By Allen White, 2/9/2010, 1:00EST
SQL Server DMV Green Paper
Get a free green paper, an early access look at a new DMV book from longtime author Ian Stirk.
Generating charts in SQL Server Reporting Services
This article displays how we can place charts in reports created using SSRS.
Get In a Line
Steve Jones talks a little about disk alignment for your SQL Server instances. This is something that you might to check on your systems and see if you can improve performance.
Keeping It All In Memory
With the release of an in-memory database from Sybase, is it time for SQL Server to join the fray?
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat Kantor BCA KCP Kepa Duri Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Mangga Raya No.20, Duri Kepa, Kec. Kb. Jeruk, Kota Jakarta Barat,...
BCA KCP Tmn. Harapan Indah Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Komp. Taman Harapan Indah Blok EE No.1, Jelambar Baru, Daerah Khusus Ibukota Jakarta...
Alamat Kantor BCA KCU PURI INDAH Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, Kec....
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers