Why is SQL Server 2008 blocking SELECT?

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5483

If you have problem with your SQL Server, like it locks table, or your select statement takes too long, or executes never, tham try something like:

 

ALTER DATABASE MyTableName
SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE MyTableName
SET READ_COMMITTED_SNAPSHOT ON

Solution I found here, also you can read this article from Microsoft.

Data source name not found and no default driver specified

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5443

If you are using Microsoft drivers for connection to MS SQL 2008, and receiving this kind of error, then, you will need to download new drivers from here. After that you will need to download sqlncli.msi (you will get the link in sqlsrv_errors())

Alt + F1

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5928

If you want to see table properties (sp_help) than in query editor just select a table you want to see properties and pres on the keyboard Alt + F1

List all tables in a database.

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5882

How to get list of all tables in MS SQL Server?

 SELECT * FROM information_schema.Tables where table_type = 'BASE TABLE'

From here.

  1. Limit aka Paging

Page 4 of 5