Delimited String Parsing Functions - Basic Set
Feed it delimited horizontal data and it returns it back as a vertical table.
2008-10-20 (first published: 2008-08-05)
2,669 reads
Feed it delimited horizontal data and it returns it back as a vertical table.
2008-10-20 (first published: 2008-08-05)
2,669 reads
This one line DOS script fetches Hardware Make and Model
OS Name, Edition (for 2003) and version
System Uptime
Processors,
RAM etc.
2008-10-20
349 reads
This small script help u to find the column exists in the list of tables in a database.
2008-10-17
878 reads
Searches database-wide for multiple indexes in the same table which has the same column as the first seek key. Optionally limits to LIKE wildcard patterns of table and schema names.
2008-10-17 (first published: 2008-08-01)
3,103 reads
2008-10-16 (first published: 2008-08-12)
1,422 reads
This Proc is written for either SQL 2000 or SQL 2005 to return a list of objects that are dependent on Linked Servers. This proc checks all Databases and Objects on a Server.
2008-10-15 (first published: 2008-09-05)
1,708 reads
Feed it double-delimited horizontal data and it returns it back as a non-pivoted vertical table with a 2-diemensional star schema.
2008-10-14 (first published: 2008-08-05)
1,033 reads
in this scripts there are two methods of creating sample data for a gambling application.
i have used both cursors and loops.
2008-10-10
683 reads
2008-10-10 (first published: 2008-07-20)
1,852 reads
This script was designed to 'pivot' data that couldnt easily be pivoted in any other way. i used temporary tables to eventually achieve the result i was looking for 🙂
2008-10-10
1,010 reads
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
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