2002-05-01
395 reads
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 […]
2002-05-01
365 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 […]
2002-03-27
186 reads
Blogs
Storage Tiers What SQL Server DBAs Need to Know
“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server...
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what...
Daily Coping 19 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Get local server's alias in T-SQL
Hello, I'm trying to get the server name programmatically. Even after I do this:...
Get local server's alias in T-SQL
Hello, I'm trying to determine if there's a way to get a server's alias...
Issues with multiple SSAS tabular instances on same server
I have created a second instance of a tabular server on the same server...
Ask SSC