Exploring the Varbinary Type
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
2013-02-07
10,978 reads
DataTypes
SQL Server Data Type Precedence
I am executing a simple query/stored procedure from my application against a large table and it's taking a long time to execute. The column I'm using in my WHERE clause is indexed and it's very selective. The search column is not wrapped in a function so that's not the issue. What could be going wrong?
2012-09-04
2,480 reads
2012-01-03
2,524 reads
2010-11-17
3,185 reads
2010-02-25
3,901 reads
2009-12-01
3,962 reads
2009-08-24
3,821 reads
2009-08-19
4,143 reads
2009-07-02
4,828 reads
2009-07-01
5,017 reads
Blogs
Using T-SQL Snapshot Backup - Are Snapshots Backups?
Introduction Traditional SQL Server backups can struggle with large databases, resulting in longer backup...
Developer Q&A: Dika Fei of Jelly Pixel Studio
By Rob Sewell
"Let me know where you get your magic pixie dust from!"
A New Word: Flashover
By Steve Jones
flashover – n. the moment a conversation becomes alive and real, when a spark...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Call Dates Effective Range
Hi Everyone, I have the data in the below form : Desired output: Here...
Question of the Day
Synapse Analytics History III
What was the originally name of the appliance that eventually became Azure Synapse Analyics?
See possible answers