You Are a Professional, So Speak Up
You are hired for your ideas so share them, it can only help your career.
2008-07-30
71 reads
Articles
Creating Stored Procedures - SQL School Video
MVP Brian Knight covers the basics of creating stored procedures in SQL Server. Stored Procedures are ways of encapsulating a section of code inside of a function, and this video shows how you to convert your queries to stored procedures.
2008-07-29
11,363 reads
Rebuilding Stats: Twice or Not At All
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,157 reads
Iterating through tables and databases in SQL Server
This tip presents two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on.
2008-07-29
4,102 reads
SQLBits III - Registration Now Open!
Registration for SQLBits III, to be held at Hatfield in the UK on September 13th, is now open! SQLBits is the UK's finest SQL Server technical conference, and it's 100% free to attend!
2008-07-29 (first published: 2008-07-23)
1,837 reads
Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-29
72 reads
Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-29
63 reads
Stored Procedures Reconsidered
A guest editorial from Scott White that looks at the use of stored procedures from a developer's point of view.
2008-07-29
76 reads
Finding and Listing ALL Procedures, Functions, and Views in SQL Server 2005
James Rea brings us another great article that shows you how to keep on top of the code that's stored in each of your databases.
2008-07-28
24,723 reads
Loading XML data into SQL Server 2008
This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data
2008-07-28
2,854 reads
Blogs
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Deploying an Updated Model with SQL Compare 16
By Steve Jones
In a previous post, I deployed a model to a database using SQL Compare...
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Forums
Automating Database Cleanup for PostgreSQL Using Python
Comments posted to this topic are about the item Automating Database Cleanup for PostgreSQL...
The Query Optimizer and Page Density
Comments posted to this topic are about the item The Query Optimizer and Page...
There Are a Lot of Databases
Comments posted to this topic are about the item There Are a Lot of...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers