Stairway to U-SQL Level 10: Table-Valued Functions and UDTs
Table-Valued Functions and User-Defined Types can help you write parameterised U-SQL views in an elegant manner. They also aid code reuse.
2016-10-12
2,595 reads
Table-Valued Function
Pros and cons of six SQL table tools
This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.
2011-12-26
9,790 reads
CLR Table-Valued Function Example with Full Streaming (STVF / TVF)
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
11,579 reads
Converting a MySQL query
Hi Guys I'm new to SQL Server 2000 and am trying to convert some of my php code that previously used MySQL. Here's the query I'm having trouble with: SELECT *,UNIX_TIMESTAMP(lastlogin) as lastlogindate from user WHERE confirmed='1' and approved='1' and login = 'blah' AND password = PASSWORD('blah'); SQL Server doesnt like the UNIX_TIMESTAMP conversion, or […]
2005-01-05
2 reads
Run complete backup on Primary Log Shipping Server? Bad?
Sounds like dump question and it may be it.Assume that you have SQLServerA which is production server for logshipping and SQLServerB for standby server. And assume there is Logshiipping running every 1 hour after the initial complete backup is done.So, question would be, if you run seperate daily job to run complete backup on production […]
2004-11-17
RE: Disaster recovery question
I would definitely recommend that you mirror drive 3. But I would also suggest that you mirror drive 1. Why have something like a drive failure take down your production system, drives are cheap.
2003-08-27
RE: Filegroup
I guess, If your default file group is full, it try to expand the files depends on your auto grow property rather using other file group because its not the default one. But if you create another file in the default file group if will use it. Some one correct me if am wrong
2003-07-01
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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