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,238 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

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Read the latest Blogs

Forums

Stored Procedures Inside Stored Procedures

By chadswt

Comments posted to this topic are about the item Stored Procedures Inside Stored Procedures

same id,ID_SEQ,EID,TS_DT but differetn location id.

By rajesh

Delete first 3 records and last two records as same day two locations should...

RPC:Completed,sp:Stmtcompleted, SQL:BatchCompleted and SQL:stmtCompleted

By 892717952

what are their differences among EventClass of RPC:Completed,sp:Stmtcompleted, SQL:BatchCompleted and SQL:stmtCompleted under SQL Profiler...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers