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 Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Every organization I talk to has the same problem dressed up in different clothes....
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item Creating a Simple and Flexible...
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers