Scripts

Technical Article

Dynamically Alter all your Tables.....

This script allows you to dynamically alter all the tables in your database.  In the script i am building up an alter statement that adds a 'TimeStamp' column a table.If anyone knows a better way to do this kind of thing, feel free to drop me a mail (jamie.moffat@infographics.co.uk)

You rated this post out of 5. Change rating

2002-07-04

755 reads

Technical Article

Index Locking Strategy

This script returns the index locking strategy informationfor all user tables in a database. It also generates the required TSQL statement to alter locking strategies if required. These statements require CTRL-C and CTRL-V individually into query analyser for execution. Results are best viewed in text only. This TSQL can be wrapped in a stored procedure […]

4 (1)

You rated this post out of 5. Change rating

2002-07-04

1,385 reads

Technical Article

VB6/ADO Stored Procedure Call Generator

Generates a VB6/ADO procedure prototype, procedure call, and ADO Command Object Parameters.Append calls.  To use, simply set the @spname variable equal to the name of your stored procedure, run, and cut and paste the output into you VB program.  The generated code may require some slight modifications, but this should save you a lot of […]

5 (1)

You rated this post out of 5. Change rating

2002-07-04

1,068 reads

Technical Article

Concatenate Rows without a cursor

You might come accross a situation where you want to retrieve the values of all the rows concatenated and stored in one variable. Here is the solution. Lets say you have a table called tblCustomerOrders which has CustID and OrderID. You now want all the OrderIDs for a particular Customer to be stored in one […]

5 (1)

You rated this post out of 5. Change rating

2002-07-02

1,084 reads

Technical Article

GetFileInfo2

An Improved version of GetFileInfo that now includes the space utilization of each datafile.  Provides more detail per file.  Predict when your files are going to grow!! Both data and log files. This script organizes information about the database files on the server.   A cursor is used to get the information from each database.  The […]

You rated this post out of 5. Change rating

2002-06-28

562 reads

Blogs

From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO

By

There was a time when the Chief Data Officer lived in the shadows of...

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

By

I saw some good reviews of the small gemma3 model in a few places...

Read the latest Blogs

Forums

Parameter sniffing issue with different minutes as opposed to using midnight

By mikael_ljunghorn

Hej, I'm not facing this issue but as I was working another parameter sniffing...

Some query values change when query is run but not others. Why?

By water490

Hi everyone I have a 1000 line SQL query that is too long to...

using different credentials when debugging ssis

By stan

hi, now and then i want one connection in my ssis pkgs to use...

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers