When more than one numeric SQL Server data type may be suitable for a field in a project, which data type should you choose and what are the implications for SQL Server performance?
2014-09-16
9,167 reads
What is completed datatypes in sqlserver and how it works in Real time.
2014-10-10 (first published: 2014-09-06)
1,461 reads
Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums. Rob Sheldon continues in his mission to answer all those questions that we hesitate to ask.
2014-07-21
17,910 reads
Comparing columns of different data types can be a drain on resources, as well as our sanity. This is a look into a few strategies for dealing with implicit conversions.
2014-05-19
9,517 reads
2014-05-06
2,138 reads
Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.
2014-04-07 (first published: 2014-03-12)
1,540 reads
I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more.
2013-07-12
3,682 reads
Eliminate pesky legacy TEXT, NTEXT and IMAGE data types with this handy script.
2013-05-14
4,756 reads
A brief look at the Varbinary data type and its uses in SQL Server for beginners.
2013-02-07
10,102 reads
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
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Comments posted to this topic are about the item The Fake Speakers
Comments posted to this topic are about the item Stairway to Database DevOps Level...
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Ask SSC