2010-03-29 (first published: 2010-03-24)
1,837 reads
Scripts
Finding rows count in a table without Select...
Here is a one more very quick way to find row count for a table.
2010-03-26 (first published: 2010-03-23)
5,383 reads
Credit Card Number Validation Escalar Function
Evaluate credit card numbers based on ISO 2894 algorithm.
2010-03-24 (first published: 2010-03-17)
1,922 reads
Script to get Phonetic Pronunciation of a given password
This script displays Phonetic Pronunciation of a given password
2010-03-22 (first published: 2010-03-12)
1,390 reads
2010-03-17 (first published: 2010-03-04)
1,531 reads
EXECute SQL Commands over entire sets of parameters!
A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.
2010-03-16 (first published: 2010-03-04)
2,925 reads
Unused Objects in the Server
This Script is used to List out the objects lying in the box which were un used from the day of the sql server recycled.
2010-03-09 (first published: 2010-02-18)
1,922 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
2010-03-08 (first published: 2010-02-18)
1,372 reads
Fix users for SQL 7 thru 2008
This script will either reoprt or 'fix' lost or orphaned users after restore for all versions of SQL.
2010-02-24 (first published: 2010-02-04)
2,253 reads
See the compile time
Useful if you think a SQL statement, Function, or SPROC is taking too long to compile.
2010-02-23 (first published: 2010-02-04)
971 reads
Blogs
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
When growing companies outgrow Excel
By ChrisJenkins
There are some telltale signs that your growing business has outgrown Excel for your...
Forums
BCA KCP Pakuwon City Telpon/WA:083179431313
WhatsApp:083179431313 Pakuwon Town Square Blok AA2/3, Jl. Kejawan Putih Tambak, Kejawaan Putih Tamba, Mulyorejo,...
BCA KCP Kertajaya Indah Telpon/WA:083179431313
WhatsApp:083179431313 Jl. Manyar Kertoarjo No.95, Mojo, Kec. Gubeng, Surabaya, Jawa Timur 60285
Alamat kontak resmi BCA KCU BLITAR Telp:0817866887
Tlp/Wa_Cs:0817-866-887 Jl. Cempaka No.17, Sukorejo, Kec. Sukorejo, Kota Blitar, Jawa Timur 66111
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers