Dynamic SQL vs. Static SQL Part 2, Code
Robert Marda continues his series on dynamic SQL and shows you how to rewrite some queries that you may think need dynamic SQL.
2002-03-07
12,792 reads
Articles
Freeware DBEzze 1.0 Released
DBEzze is a freeware product that can look into a database and generate XML structural or data output. It can also generate INSERT statements from a table, view or stored procedure. This freeware product is available for download from SQLServerCentral.com members only.
2002-03-06
92 reads
SQL Mail Resources
As I work with a particular topic or problem, I often research on the Internet
different opinions, white papers, etc. Here is a list of resources that are located both
on SQL Server Central and other sites that I have found useful.
2002-03-04
11,033 reads
Microsoft Tunes Windows
Microsoft Corp. is considering bundling in the next version of Windows a pared-down version of its next-generation SQL Server database and the relational file system that goes with it.
2002-03-04
3,283 reads
2002-03-01
2,214 reads
Performance Comparison: Data Access Techniques
Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.
2002-03-01
2,857 reads
How to Fix Inconsistent Metadata Errors
Why does changing a table on a SQL Server 7.0 server cause "OLE DB provider 'SQLOLEDB' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time." to occur when query the table from a SQL Server 2000 server via link to other. In this article by James Travis, he shows you what the problem is and how to fix it.
2002-02-28
15,120 reads
How to track database file growth over a period of time?
This stored procedure shows you the growth patterns of your SQL Server database files and enables you to plan ahead for your future storage needs!
2002-02-28
105 reads
Technical Chat: Inside with Jim Gray--The Search for Petabyte Storage
Please join Jim Gray, Distinguished Engineer at Microsoft Research, for this Q&A Session. Jim, the father of Structured Query Language, has been looking at LARGE databases like Google, Hotmail, BarBar, CERN, EOS/DIS, Internet Archive, and others that are either at a Petabyte or will grow to a petabyte scale in the next year or so.
2002-02-28
3,353 reads
Dynamic SQL vs. Static SQL Part 1 - Security
Sooner or later everyone who works with SQL Server hears that it is better to avoid dynamic SQL at all cost. Dynamic SQL will force you to give out more permissions than static SQL. This article by Robert Marda shows you some of the security issues with dynamic SQL.
2002-02-27
12,735 reads
Blogs
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Building a Docker image with Docker Build Cloud
In a previous blog post we went through how to build a Docker container...
Top 8 Courses to Learn SQL for Data Science in 2024 & Beyond
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
Forums
SQL server native CDC
Have anyone implemented CDC, and if so, what has been your experience with it?...
Import and Export wizard stuck on Guest user
I'm getting a error when using the Import and Export wizard to copy tables...
Aligning Compatibility Version Strategy
I have joined a new project, where the business uses Azure SQL Hyperscale for...
Question of the Day
Initial Config of tempdb
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers