How to Drop Unused Empty Redundant columns
Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns
2008-11-27 (first published: 2008-10-22)
1,191 reads
Scripts
Get the all the SQL Server related services information
Get the all the SQL Server related services information,
2008-11-26 (first published: 2008-10-13)
1,283 reads
2008-11-25 (first published: 2008-10-20)
1,335 reads
AUTOGENERATE Stored procedures example
This is related to my other autogenerate code. this is just an example of how to use it.
2008-11-21
767 reads
AUTOGENERATE INSERT UPDATE SELECT STATEMENTS
use metadata to generate basic create procedure statements for insert update and select
2008-11-21 (first published: 2008-10-10)
3,851 reads
2008-11-20 (first published: 2008-10-06)
993 reads
random randomise randomize data query
this is a MUCH simpler method of random randomize randomise rand data from a table
2008-11-19
305 reads
Queries, Plans, and Indexes
Find indexes associated with queries and vice versa. Helps figure out what procedures are using indexes.
2008-11-18 (first published: 2008-07-31)
1,720 reads
Backup And Restore Remain Time
Script to found out how much time before Restore or Backup Process remain
2008-11-17 (first published: 2008-09-30)
1,069 reads
Data extrapolation on the fly
Sometimes we need to generate the data based on a given date, to an end date (data extrapolation).
This is a easy way to do that without any temporary storage.
2008-11-14 (first published: 2008-09-25)
922 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Alamat Kontak Bank Central Asia Telp Cs 0817781222
Jl. Raya Pasar Minggu No.64, RT.6/RW.8, Kalibata, Kec. Pancoran, Kota Jakarta Selatan, Daerah Khusus...
Alamat BCA KCP Blok M Telp Cs 0817781222
Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah Khusus...
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers