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
UDT
Do SQL Server User Defined Datatypes (UDT) affect performance?
There is a legend among SQL Server developers and DBAs saying that UDTs may degrade performance. In this article I prove whether this believe is right or wrong.
2009-04-20
3,361 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: Stored Procedure
Typically you only add additional parens to make the logic correct. Don't know there is a best practice here. I work to solve the problem - write a query that returns the data correctly - then look to see if performance is adequate. The ugly part of query tuning is you cant really optimize bits […]
2003-06-14
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