Sql Server Blog
Blog Archive
►
2012
(4)
►
November
(1)
►
June
(1)
►
April
(1)
►
February
(1)
►
2010
(8)
►
January
(8)
▼
2009
(9)
►
November
(1)
▼
October
(8)
Search string in any column in a table
Counting rows in a table for improving performance...
Searching in a column of any table by a substring
Select desired rows from table by IN Keyword
Select top two rows from SQL server database table
Insert rows/records from one table to another table
How to select Duplicate Rows from a table
Create Serial Number Column using SQL Server
Connect
C# DOT NET for Developers
Remove all XML tags from a string
11 years ago
ASP Developer
Read client side IP Address
15 years ago
Followers
ClustrMaps of Visitors
About Me
Amit Pal
Associate Project Manager, HCL Technologies Ltd. Noida
View my complete profile
Friday, October 9, 2009
Counting rows in a table for improving performance of the query
Below is the query for counting rows in a table for improving performance of the query.
SELECT rows FROM sysindexes WHERE id = OBJECT_ID('tbl_xyz') AND indid less than 2
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment