Building and executing dynamic sql in a stored procedure - is it the only way to solve problems like supporting a simple search function? Leon offers a couple alternatives that let you continue to provide the functionality in a stored procedure without using dynamic sql. Interesting ideas worth exploring!
SQL Server MVP Mike Hotek and industry expert Kimberly Tripp launch the latest SQL Server educational offering from PASS - one day seminars beginning this June in Chicago and August in Las Vegas. Join Mike and Kim as they demonstrate their expertise on SQL Server replication and tuning high performance SQL Server 2000 databases. Space is limited. Seminar details and convenient, secure online registration is available at http://www.sqlpass.org/events/seminars.
RedGate software has announced their newest product, SQL Server Compare, a new tool for comparing and synchronizing SQL Servers. Read the press release!
Jon Winer further discusses some comparisons using ADO versus the XML DOM to parse shaped recordsets. This article is a supplement to his previous article titled: Converting Shaped Recordsets into XML.
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.
Want to get more productive? Fit more work into normal working hours? Steve Jones found a relatively inexpensive hardware upgrade to help you.
Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization. This paper will inform you about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job.
A list of DTS resources, including bugs, issues, books, and some good programming resources.
From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.
Forgive me for the title. Mentally I’m 12. When I started my current day...
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Wir liefern perfekt reproduziertes Falschgeld mit Hologrammen und allen verfügbaren Sicherheitsmerkmalen, das weder optisch...
Vi levererar perfekt reproducerade förfalskade pengar med hologram och alla tillgängliga säkerhetsfunktioner som är...
Forniamo banconote contraffatte perfettamente riprodotte con ologrammi e tutte le caratteristiche di sicurezza disponibili,...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers