I wanted to know which tables contains the most populated records in db. So I wrote this script.
2005-01-02 (first published: 2004-11-18)
94 reads
The Script outputs all the indexes in the Database.I have used the sp_helpIndex system stored procedure here to retrieve all the indexes available for the Table . This is extremely useful in identifying all the indexes in a database in a single query
2004-12-22 (first published: 2004-11-18)
331 reads
The Query will enable you to retrieve all the Tables in the Database .The Output of the Query will list all the User Tables along with the Column Names and the Sort order of the Columns .The Query will also return as to whether the Columns in the table are with allow null option or […]
2006-07-06 (first published: 2004-11-18)
436 reads
This script creates a table named DATELOOKUP which is used for looking up date related values. Each record represents date related info about the date in the column dtDate. For example the iMonth column stores the integer value of the month of dtDate and sShortMonth stores the abbreviated name of that same month. Use this […]
2004-12-13 (first published: 2004-11-17)
215 reads
This is BASE64 Encoding/Decoding in a T-SQL procedure. This code is provided as is, and is free to use and modify. Version 2 June 2005
2006-01-23 (first published: 2004-11-17)
4,827 reads
Add this procedure to the master database, it can then be executed from any DB to fix orphaned users (very useful when moving back to development). Using sp_msforeachdb with the proc allows you to resolve orphaned users in all databases in a single command: SP_MSFOREACHDB "USE ?; EXEC SP_AUTOFIX_USERS;"
2004-12-15 (first published: 2004-11-12)
2,881 reads
Recently, I answered a question by a person on Experts Exchange.com on how to find the # of weekdays between two dates. This question was simplified greatly by the fact that the dates given would always be from Monday to Friday, and so the calculations needed were very simple.Then, while looking at the recent scripts […]
2004-11-22 (first published: 2004-11-10)
134 reads
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?