DataTypes

Identify Column Data Types

  • Script

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.

2.67 (3)

2014-04-07 (first published: )

1,231 reads

SQL Server Data Type Precedence

  • Article

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

Blogs

Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

By

How to read execution plan to improve poorly... [[ This is a content summary only....

VSCode Tips–Remove the Highlighted Line

By

VSCode was making me crazy as I was writing a script. I like a...

Use T-SQL, not the GUI

By

There’s a very good reason to do most of your DBA work using T-SQL,...

Read the latest Blogs

Forums

business intelligence development studio(Bids)

By Nivs719

Hello, I have a SQL 2017 and I want to use business intelligence development...

MEMORY CONSUMPTION SQL 2012

By sharon-472085

hi all, as you can see in attachment sql take 122  giga memory. and...

Issue with max() and aggregate, missunderstanding

By insomnius

Hi all, this is my first post here and I've been looking and trying...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers