T-SQL for UDFs
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...
2016-01-15
109 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for...
2016-01-15
109 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
3 reads
SQL Server has plenty of built-in functions, but sometimes we just have to combine some of them to create functions for our purposes. Such one, for example, is the function...
2016-01-15
7 reads
Once it happend quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...
2015-12-25
129 reads
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and...
2015-12-25
100 reads
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....
2015-12-25
5 reads
Once it happened quite a black Friday for my environment after a deployment. The application got sucked so that becoming worst and worst. The average CPU raised over 80% (Figure 1)....
2015-12-25
3 reads
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
110 reads
Recently I had the chance to take a look at a problematic query in an application. I caught the query...
2015-11-11
3,242 reads
Recently I had the chance to take a look at a problematic query in an application. I caught the query in profiler and it’s the following: [crayon-5e81b52edda2c602772598/] The query...
2015-11-11
5 reads
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers