2009-12-09 (first published: 2009-11-18)
2,096 reads
Scripts
2009-12-07 (first published: 2009-11-12)
3,097 reads
Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
2009-12-04 (first published: 2009-11-10)
2,100 reads
2009-12-02 (first published: 2009-11-11)
876 reads
t-sql first last day date of the month
Returns the First or last day date of the month for a given date.
2009-12-01 (first published: 2009-11-11)
2,865 reads
usp_ShrinkAllLogs
Replacement script for usp_ShrinkDBLogs, updates for SQL 2008 deprecating the WITH TRUNCATE_ONLY method.
2009-11-27 (first published: 2009-10-30)
989 reads
Display COUNT(*) but ONLY TOP 100
Let’s say you have a result set with 5000 records but you want to display only 100 of them and in the same time to display the count of ALL records (5000).
2009-11-20 (first published: 2009-11-05)
2,474 reads
Split string into table, separator can be more than 1 char
Split string like ('123,43,5465,6788,1231,111', ',') into table, separator (,) can be more than 1 char
2009-11-19 (first published: 2009-11-05)
1,381 reads
Scripts for Full DB Compression at partition level
Data compression is a key feature with SQL 2008. This script, can compress all DB objects (partition/non-partitioned) according to Partition Range you specifiy.
2009-11-18 (first published: 2009-11-05)
1,171 reads
2009-11-17 (first published: 2009-11-06)
1,010 reads
Blogs
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...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Alamat BCA KCP Sambas Telp Cs 0817781222
WhatsApp:0817781222 Jl. Gusti Hamzah No.85, RT.02/RW.01, Pendawan, Kec. Sambas, Kabupaten Sambas, Kalimantan Barat 79465
Alamat BCA KCP Antasari Telp Cs 0817781222
WhatsApp:0817781222 Jl. P Antasari No.21, Tlk. Lerong Ulu, Kec. Sungai Kunjang, Kota Samarinda, Kalimantan...
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