New T-SQL Fixed Width "Splitter"
A brand new tally table based, fixed width "splitter" that can be used for much more than just string splitting
2016-06-22 (first published: 2016-05-14)
1,698 reads
String Splitter
Splitting Strings in SQL Server 2016
Comparison of the new methods of splitting strings in SQL Server 2016 to the tried and true methods
2018-06-15 (first published: 2016-04-12)
8,449 reads
Simple and efficient way to split string with seperator
Split a string with separator without looping. Can be efficiently used with joins if necessary.
2013-07-12 (first published: 2013-06-15)
1,976 reads
RE: Partition Manager
You should try to get the newer version (I think called Aggregation Utility) which comes with SSABI (sql server accelerator for BI), avail on the downloads site (msdn).Alternatively, have you tried creating the partitions manually and when doing this chosing a different table/view as the source?Lastly, Mosha (Posumansky?) has a link to yet another partition […]
2004-10-13
BACKUP PROBLEM
I', having a problem in my backup.This is the message:BackupDiskFile::CreateMedia: Backup device 'S:\Backup\Terca-Feira\BACKUP-TERCA-FEIRA.BAK' failed to create. Operating system error = 32(The process cannot access the file because it is being used by another process.). Dos someone knows what kind of error is this?? Regards,Felipe
2004-09-29
4 reads
RE: An Introduction to Database Models
I would like to add a little bit of personal opionion on the OODB topic.The concept of an Object-Oriented Database just seems wacky to me. Objects imply action. If you're thinking in terms of Object-Oriented programming, the really important stuff is the behavior of the objects. The data storage is irrelevant. In reality, a relational DBMS is […]
2004-02-12
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers