Miscellaneous

Technical Article

Delivering on SQL Server

  • Article

Having been at the sharp end of many successful SQL Server solutions, I believe there are some fundamental principles that all successful SQL Server installations have in common. Whilst the challenges in delivering an enterprise-scale database-intensive application can be wide and varied, there are a few basic practises that will give you the best possible chance of success.

2007-04-05

2,570 reads

Technical Article

Find the database by table name

  • Script

Here's the scenario: 1.  You have been given a script to run.2.  You do not know the database name.3.  You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer.  This query will check every database on the server and return the name of the database with […]

2 (1)

You rated this post out of 5. Change rating

2007-04-26 (first published: )

478 reads

SQLServerCentral Article

A Common Architecture for Loading Data

  • Article

Importing data files is always a challenge for a DBA, especially when the files might vary in format. Having one codebase is important and new author Mark Balasundram brings us the template for a high performance application to do just that.

4.5 (4)

You rated this post out of 5. Change rating

2008-03-13 (first published: )

17,527 reads

External Article

Use SQLIOSIM to simulate SQL Server disk activity

  • Article

I regularly use SQLIO.EXE to gauge the maximum throughput a disk subsystem can sustain. Recently Microsoft released SQLIOSIM.EXE to provide better results for this type of test. However they didn't release any documentation on the tool and I could never figure out what it was trying to tell me. It looks like they finally did release a Knowledge Base article on SQLIOSIM. Give it a spin. I'd be curious to hear what you think of the tool.

2007-03-30

2,768 reads

Technical Article

Dynamic SQL inside User defined functions

  • Script

The script details about the workaround for using Dynamic SQL inside T-SQL user defined functions. Basically, T-SQL doesn't allow developers to perform/write any actions/statments which would affect the database's state. As a key note factor for any migration process from oracle to sql server developers need to do a work around on using execute immediate(for […]

3 (2)

You rated this post out of 5. Change rating

2007-04-18 (first published: )

4,068 reads

SQLServerCentral Article

Saving a Sales Order Part 1

  • Article

How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.

4.67 (3)

You rated this post out of 5. Change rating

2007-03-27

12,895 reads

Blogs

Come See Me at the PASS Data Community Summit

By

I'm speaking on Quantum Computing at the PASS Data Community Summit. It's scheduled for...

SQL Clone at Scale with Striped Backups

By

I had a customer recently reach out to ask if SQL Clone would work...

How to Set Up SQL Server 2025, Ollama and NGINX in Docker Without the Headaches

By

Ollama SQL FastStart kit just works out of the box. It makes it easy...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Holistic Approaches to Overcoming Erectile Dysfunction

By marksmith9698

Erectile dysfunction (ED) affects millions of men and arises from a combination of physical,...

Managing unused indexes

By JasonO

While doing some housekeeping activity on several old but large production databases, I come...

Visit the forum

Question of the Day

Striped Backup File Limits

In SQL Server 2022, how many backup files can I have in a striped backup?

See possible answers