Here is a challenge that takes you away from those repetitive boring type of queries that you write over and over again, several times a day. All of us, the database people, are familiar with thinking in set based manner as well as row by row style. Here is something that is very interesting where you might need to process records in a 'three-line-at-a-time' fashion.
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
By James Serra
Most enterprise questions do not live neatly in one place. The numbers may be...
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization vs....
Comments posted to this topic are about the item Hyperscale Replicas I
Comments posted to this topic are about the item The End of Summer
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers