Getting TEXT, NTEXT and IMAGE columns in Database
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
1,914 reads
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
1,914 reads
This Function is used to round to Second, Minute, Hour or Day or to Truncate to Second, Minute, Hour, Day, Month or Year and return Datetime Value
2017-05-31 (first published: 2017-05-23)
2,290 reads
2017-05-25 (first published: 2017-05-15)
1,048 reads
This script provides the day of the month for the standard bank holidays for any given year. This is especially useful for computing the workday after a holiday.
2017-05-24 (first published: 2017-05-10)
476 reads
2017-05-16 (first published: 2017-05-05)
853 reads
An ITVF function that rounds a number to the nearest Power of 10
2017-05-15 (first published: 2017-05-05)
289 reads
2017-05-10 (first published: 2017-05-02)
332 reads
2017-05-09 (first published: 2017-05-03)
1,675 reads
Most comman scenario which we face on everyday basis is to fix the orphan database users at the database level. You need to go to each database and fix the orphan users at the each databases.
2017-05-03 (first published: 2017-04-20)
650 reads
This is quick script to ascertain datafile headroom based on current size of the data in a file against the max size (which needs to be set for this to work!)
2017-05-02 (first published: 2017-04-19)
362 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers