2002-05-01
392 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
357 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
183 reads
Blogs
Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting
By Devin-Knight
Check out this new series that I’ve started on Power Platform Quick Tips. This...
The curious case of CHAR(0)
Over the years I’ve seen quite a few strange things with SQL Server. This...
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
repeating block of records
I want to look for blocks of records repeating in a table. pattern...
how can i see the last 100 select statements that were run by any user
how can i see the last 100 select statements that were run by any...
Ask SSC