GetPage - paging functionality

All what you need to do is to set the values of a couple of variables; NAME OF the TABLE you want to query (or you can write your own select statement here), NAMES OF COLUMNS you want to display, name of COLUMN for SORTING, define NUMBER OF ROWS on one page, NUMBER OF REQUIRED […]

5 (1)

2002-05-01

361 reads

Detection of Broken Forign Key Relationship

Under special circumstances, it could happen that database contains "orphan" records. Data in dependant table exists without it's "parent" record in a master table. It could be caused by a bulk insert operation without CHECK_CONSTRAINTS option, or by disabling foreign key for a while or adding a foreign key to a table that already contains […]

5 (1)

2002-03-27

183 reads

Blogs

Probing Columnstore Indexes

By

In this article, our focus will be to test, the performance benefits of columnstore...

Understanding Disk Performance and IOPS in cloud platform

By

In the past many years, apart from working as DBA, I was working with...

COVID-19, a wake-up call

By

COVID-19 is the only pandemic I’ve seen in my whole life. It gave me...

Read the latest Blogs

Forums

How to make join to teams display without join all teams ?

By ahmed_elbarbary.2010

problem How to make left join to only teams displayed  dynamically depend on fields...

sql server memory buffer cache building up question

By sqlguy80

question for DB Gurus when sql server is restarted, it will be slow at...

Query Optimization Level

By Grant Fritchey

Comments posted to this topic are about the item Query Optimization Level

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

SQLCMD Output

See possible answers