Miscellaneous

Technical Article

Get record count for every table in a database

  • Script

I wrote this code to make it easier to compare record counts between a live database and a restored copy to test my backups, I thought people might find it useful. You need to run it against your live side when you do the backup that you're going to restore and compare against.Copy the output […]

5 (1)

You rated this post out of 5. Change rating

2007-05-24 (first published: )

2,742 reads

Technical Article

Return comma seperated values from multiple record

  • Script

It helps you in situaions whenever you wish to create commm seperated values actually originating from multiple records. Say, your query return three records in folloing patter:Student_Name=============RickyAdamMathewBut, say you wish to have records in following patter:Student_Name============Ricky, Adam, MathewThat is how it works. Try it...I beleive it will help you  a lot

You rated this post out of 5. Change rating

2007-09-07 (first published: )

475 reads

SQLServerCentral Article

My Projects Have Never Failed

  • Article

As a SQL Server DBA or developer, how do you measure the success of your projects? What about your users? Here is an interesting look by Janet Wong at a few of her projects and how their success was perceived. See if any of your experiences are similar.

3.38 (16)

You rated this post out of 5. Change rating

2008-02-28 (first published: )

8,366 reads

Blogs

Expanding Your DBA Horizons: Installing PostgreSQL in a Home Lab

By

Are you diversifying your DBA skillset? My recent job search made one thing clear:...

Back in the EU

By

I flew to Amsterdam last night and hopefully by the time this publishes I’ll...

The Feedback Multiplier: How Leaders Can Turn Input into Innovation

By

In every organization there is a hidden currency more valuable than capital, more enduring...

Read the latest Blogs

Forums

RESTORE DATABASE command internal timeout

By MikeDBA

I have run into a very strange issue restoring a large, partitioned database. I...

how to use a variable in a CASE statement?

By water490

hi everyone I am getting an error when I add a variable to a...

How to Use SQL Server Features to Cut Web App Latency in Half

By Muhammad Adnan

Comments posted to this topic are about the item How to Use SQL Server...

Visit the forum

Question of the Day

The New SQL Server 2025 Data type

In SQL Server 2025, there is a new data type designed to support similarity search and machine learning applications for AI applications. What is this new data type?

See possible answers