One line to drop a (temp) table if it exists
It is very common to want to drop a table, if it exists, before creating it. This script does so, and it works well with temp tables (where the system views are harder to query).
2008-10-06
2,677 reads
Mike Arney
Java's String.hashCode() function in T-SQL
T-SQL function to takes a string and produce an integer hashcode matching what is produced by the Java String.hashCode() method.
2008-08-04 (first published: 2008-06-11)
1,099 reads
Blogs
Probing Columnstore Indexes
In this article, our focus will be to test, the performance benefits of columnstore...
Understanding Disk Performance and IOPS in cloud platform
By nelsonaloor
In the past many years, apart from working as DBA, I was working with...
COVID-19, a wake-up call
COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...
Forums
How to make join to teams display without join all teams ?
problem How to make left join to only teams displayed dynamically depend on fields...
sql server memory buffer cache building up question
question for DB Gurus when sql server is restarted, it will be slow at...
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Ask SSC