Skip to content

SQL Canada (SQLCAN)

Data – Analytics – AI – Random Thoughts

  • Home
  • About
  • DBA Queries
  • Acclaim Badges

Category: SQL 2000

How to find out what is causing page splits?

March 30, 2012 Mohit

Client was noticing high number of Page Splits/sec in relation to Batch Request/sec; however could not figure out why.  They were not have performance issue but

Continue reading

Rate this:

OSQL and Code Page Settings

March 6, 2009 Mohit

Credit: Carl B. (SQL Server Central, Link) In SQL Server 2000, when using OSQL it is difficult to work with import files that are in

Continue reading

Rate this:

Error 14274: Cannot add, update, or delete a job (or its steps or schedule) that originated from an MSX server.

January 20, 2009 Mohit

You can get this error when trying to modify the properties of a Job after the SQL Server has been renamed or cloned into another

Continue reading

Rate this:

Granting Execute Permissions

November 10, 2008 Mohit

Following code can be used to Grant Execute Permissions to a Database Role, in a database. This is for SQL Server 2000; because in 2000

Continue reading

Rate this:

Status Column in Sysusers

October 3, 2008 Mohit

I have encountered issues after adding logins to the SQL Server 2000 databases where even though the servers show up in the user list they

Continue reading

Rate this:

Contact Me

mohitkgupta@msn.com
Contact me if you need assistance with PTO, HADR, Automation, etc. :)
MCC 2012

Categories

  • Administration (30)
  • Announcement (17)
  • Azure (1)
    • Azure Storage (1)
  • Best Practices (3)
  • Database Mirroring (5)
  • Disaster Recovery (5)
  • Documentation (1)
  • Dynamic Management Views/Functions (11)
  • Full Text Search (2)
  • High Availability and Disaster Recovery (18)
    • AlwaysOn Availability Groups (3)
    • Cluster Errors (1)
    • SQL Failover Cluster (2)
    • Windows 2003 Clustering (3)
    • Windows 2008 Clustering (9)
    • Windows 2008 R2 Clustering (3)
  • Interesting Reads (11)
  • Maintenance Plans (2)
  • Operating System Errors (2)
  • Performance Tuning (21)
  • Published Article (2)
  • Reporting (7)
    • Power BI (2)
    • Power BI Desktop (2)
    • Report Builder (1)
    • SSRS 2000 (1)
    • SSRS 2008 (1)
  • Security (10)
  • Smart Index Management (3)
  • SQL 2000 (5)
  • SQL 2005 (29)
  • SQL 2008 (18)
  • SQL 2008 R2 (11)
  • SQL 2012 (16)
  • SQL 2014 (11)
  • SQL 2016 (15)
  • SQL Bootstrap Errors (1)
  • SQL Embedded Edition (1)
  • SQL Errors (15)
  • SQL Internals (2)
  • SQL Protocols (1)
  • SQL Replication Errors (1)
  • SQL Server Tools (1)
    • SQL Server Configuration Manager (1)
  • T-SQL Reference (4)
  • Tinkering (1)
  • Tools (14)
  • Troubleshooting (30)
  • Windows 2008 (1)
  • Windows 2008 R2 (2)

Tags

ApexSQL Tools Authentication Central Management Server CMS Computed Columns CTE CTP Database Corruption DBA Queries DBCC CHECKDB Distributed Transactions DMF - sys.dm_exec_query_plan DMF - sys.dm_exec_sql_text DMF - sys.dm_io_virtual_file_stats DMV - sys.dm_exec_query_stats DMV - sys.dm_exec_requests DMV - sys.dm_os_waiting_tasks File Header Corruption fn_dblog Hekaton in-doubt xact resolution In-Memory OLTP Index Management Jan 2019 Update KB Articles Kerberos KILL Lazy Writer Maintenance Plans Microsoft Forever Modeling mofcomp M Query Language Multi-Server Management Named Pipes Negative Session IDs NOLOCK Hint Non-Technical NUMA Configuration OBJECT_NAME Operating System Error 5 PAL perfmon Performance Counters Power Query Language PowerShell Presentation Processor Imbalance References Security Service Principal Names (SETSPN) Slicer Pane Smart Guides SQL Error 3117 SQL Error 5172 SQL Error 6101 SQL Error 18456 SQLPASS SQL Patches & Hotfixes SQL Server Disaster Recovery SSIS SSMS SSMS 2008 SSPI Error Suspect Database Syntax Highlight sys.database_mirroring_endpoints sys.dm_tran_active_transactions sys.dm_tran_locks sys.indexes sys.sysprocesses sys.tables sys.tcp_endpoints Undocumented Functions Wait Types

Archives

Administration Links

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com

Blog Stats

  • 135,712 hits
Website Powered by WordPress.com.
  • Follow Following
    • SQL Canada (SQLCAN)
    • Join 162 other followers
    • Already have a WordPress.com account? Log in now.
    • SQL Canada (SQLCAN)
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar