Categories
- .Net
- @@DATEFIRST
- @@error
- @@OPTIONS
- 70-411 Exam
- 70-457 Exam
- 70-462 Exam
- aa
- AAG
- Accelerated Data Recovery (ADR)
- Access
- Access Control
- Access Restriction
- Accessed Date
- ACID
- Active Directory
- Ad hoc reporting
- Adaptive Query Processing
- Add integers
- Administration
- Administrator
- ADO
- ADO.NET
- Advanced
- Advanced Querying
- Advanced SQL
- Adventureworks
- AES-256
- Age
- Age Calculation
- Agent
- Agent jobs
- Aggregate Transform
- Aggregates
- agile
- Agile Database Techniques
- Alerting
- alerts
- Alias
- Alter
- Alter Column
- ALTER DATABASE MODIFY FILE
- Alter Index
- ALTER PROCEDURE
- ALTER ROLE
- Alter table
- Always Encrypted
- always on
- Always On
- Amazon
- Amazon RDS
- Amazon Redshift
- AMO
- AMR
- Analysis Services (SSAS)
- Analytic Functions
- Analytical Methods
- Android
- Angular
- AngularJS
- ANSI_NULLs
- ANSI_PADDING
- Apache Druid
- Apache Spark
- APPLY
- April Fools
- APS
- Arabian number to English
- Arabic
- Architecture
- archive
- Archiving Data
- Arithmetic
- arithmetic expression
- Array
- Arrays
- Artificial Intelligence (AI)
- ASCII()
- ASCMD
- ASP
- ASP .NET
- ASP.NET
- async
- AT TIME ZONE
- attach database
- Attach/Detach
- Audit
- Audit Specification
- AUDIT_LOGOUT
- Auditing
- Authentication
- auto format sql
- AUTO_UPDATE_STATISTICS
- AutoGenerate
- AutoGenerate parameters
- Autogrow
- autogrowth
- Automate
- automated deployment
- Automated Deployments
- Automated index defragmentation script
- automatic
- Automatic page repair
- Automatic tuning
- Automating SQL Server Health Checks
- Automation
- Availability
- Availability Group (AG)
- Availability Group Listener
- Awards
- AWS
- azsure sql database
- Azure
- Azure AD
- Azure BLOB Storage
- Azure Cognitive Services
- Azure Cosmos DB
- Azure Data Explorer
- Azure Data Explorer (ADX)
- Azure Data Factory
- Azure Data Lake
- Azure Data Studio (ADS)
- Azure DevOps
- Azure IaaS VM
- Azure Purview
- Azure SQL
- Azure SQL database
- Azure SQL Managed Instance
- Azure SSIS Feature Pack
- Azure Stack
- Azure Storage
- Azure VM
- Backup
- Backup and restore
- Backup compression
- Backup to Azure
- Backuphistory
- Backup-Restore
- Backups
- backupset
- Bala
- Balanced Data Distributor Transformation
- Barcode
- Baseline
- baselines
- BASH
- Basic
- Basics
- batch processing
- BB
- bbb
- BCP
- BCP (Bulk Copy Program)
- BCP command
- Beginner
- Best and Worst Practices
- Best Practices
- beta testing
- BETWEEN
- BI
- BIDS
- Big
- Big Data
- Big Data Cluster
- BigData
- bigint
- BIML
- Bin packing
- binary
- Binary conversion
- Binary Data
- binary string
- BISM
- Bit Columns
- Bit Masking
- Bit operation
- bitmasking
- bitwise
- Bitwise AND
- Bitwise Operations
- Bitwise Operators
- BlackBerry
- BLOB Manipulation
- BLOB Storage
- blockchain
- Blocking
- Blocking in SQL Server
- Blocks
- Blog
- Blogs
- bloopers
- Board Game
- Book Reviews
- Bookmark Lookup
- books
- Books ON Line (BOL)
- Books Online
- boolean
- Browser
- Browser Service
- Brute Force
- bruteforce
- Buffer Cache
- Buffer Pool
- Buffer Pool Extensions (BPE)
- bug
- Bugs
- Build List
- Bulk import
- bulk insert
- Bulk Load
- bulk logged
- bulk replace
- bulk update
- BULKADMIN
- bulkcopy
- Business Days
- Business Improvement
- Business Intelligence
- Business Intelligence (BI)
- Business Intelligence Development Studio
- business logic
- Business Rules
- Byte Me
- C#
- cache
- Caching
- Calculate Distance
- calculation
- calendar
- Calendar Function
- Calendar Table
- Capacity planning
- Capitalize
- Cardinality Estimates
- Cardinality Estimator
- Career Growth
- career networking
- Cartesian Product
- cascade
- CASE
- Case sensitive
- CASE statement
- Case Studies
- Cashing
- CassandraDB
- CAST
- CAST and CONVERT
- CC
- cDatabase Activity Monitoring
- CDC
- CDC Change Data Capture
- CEILING()
- Central Management Server (CMS)
- Central management servers
- Cerebrata
- Certificates
- certification
- Certifications
- change
- change column
- Change Data Capture (CDC)
- change detection
- change foreign key name
- change sql server password
- Change Tracking
- char
- charindex
- Chart
- CHECK constraints
- CHECK()
- CheckDB
- Checking null values in a column using count
- checkpoint
- checksum
- checksum_agg
- CHOOSE
- Cleanup
- Cleanup Files/Folders & Sub-folders
- Cloning
- cloud
- Cloud Computing
- cloud services
- CLR
- cluserting
- cluster
- Cluster Analysis
- Cluster resource SQL Server failed
- clustered columnstore
- Clustered columnstore index
- clustered index
- Clustered Nonclustered Index freespace rebuild
- Clustering
- cmd
- CMDSHELL
- Coalesce
- Coalesce()
- Coaslece
- COBOL
- COBOL conversion
- Code Analysis
- code coverage
- Code formatting
- Code Generation
- Code reuse
- Code Review
- Code Smells
- Coding Standards
- Coding Style
- Collation
- collationlevel
- Color Coding
- Column Master Key (CMK)
- Column Sets
- columns
- ColumnStore Index
- Combinatorial Optimization
- Comic Strip
- comma separated list
- Comma Separated Value
- Comma seperated
- command
- Command Prompt
- Command Prompt Utilities
- Comments
- Common Language Runtime (CLR)
- Common Table Expressions (CTE)
- Communication
- Community
- Commvault
- compact edition
- Compare
- compare database
- Comparing
- Comparison
- Compatibility
- Compatibility level
- Competition
- Complex Queries
- Compliance
- COMPRESS()
- Compressed backup
- Compression
- computed columns
- Computer Name
- computer networking
- computer theory
- CONCAT()
- Concatenate
- Concurrency
- conditional
- Conferences, Classes, Events, and Webinars
- Configuration
- Configuration Files
- Configuration Repository
- Configuration Settings
- Configure SQL Jobs
- Configuring
- Connection
- Connection Strings
- Connections
- Connectivity
- Console Commands
- Consolidation
- constraints
- contained databases
- Containers
- Contest
- contests
- context_info()
- continuous delivery
- continuous deployment (CD)
- Continuous Integration
- Continuous Integration (CI)
- CONTROL SERVER
- conversion
- Conversions
- Convert
- convert datetime to bigint
- Convert row to column
- copy
- Copy Database Script
- copy logins
- Copying File in SSIS
- Corruption
- CORS
- CosmosDB
- count()
- covering index
- CPU
- cpu issues
- CPU Performance
- CPU Time
- CPU Usage Data
- cpuissue
- Create
- Create a folder
- create database
- CREATE EXTERNAL TABLE
- create index
- Create Nonclustered Indexes
- Create Schema
- CREATE TABLE
- Create Table At Runtime
- CREATE XML INDEX
- critical
- cross apply
- CROSS APPLY VALUES UNPIVOT
- CROSS APPLY WITH SCALAR FUNCTION
- CROSS JOIN
- cross platform
- Crosstab
- crossword
- CSV
- CTAS
- CTE
- Cube
- Culture
- CUME_DIST()
- cumulative
- Cumulative Updates (CU)
- Currency
- current running sessions
- cursor
- Cursor Options
- Cursor vs Recursive CTE
- cursors
- Custom Auto Increment Value
- Custom Logging
- Custom Metrics
- Customizing ORDER BY clause
- CXPACKET
- cybercrime
- DAC
- dacconnection
- DACFx
- dacpac
- Danish language for sql server 2008
- Dashboard
- data
- Data access
- data analtyics
- Data Analysis
- Data and Log file Usage
- Data API Builder (DAB)
- data catalogs
- Data classification
- data cleansing
- Data cleanup
- Data Collections
- Data Collector
- Data Compression
- data context
- Data Conversion
- data corruption
- data definition language
- data degredation
- Data Dude
- Data exploration
- Data Explorer
- data extraction
- Data File
- Data Flow Task (SSIS)
- Data Generation
- data governance
- data integrity
- Data Lake
- Data Lineage
- Data Loading
- Data Manipulation
- Data Mart
- data masking
- Data Migration Assistant
- Data Mining
- Data Mining Query Task
- Data Modeling
- data monitoring
- Data path
- Data Platform
- data privacy
- Data Privacy and Protection
- Data Processing
- Data Profiling
- Data Protection
- Data Protection Manager
- Data Quality
- Data Quality Services (DQS)
- Data Recovery
- data retention
- Data Science
- Data Sets
- Data Storage
- Data Synchronization
- data type
- Data Types
- data validation
- Data Vault
- Data Visualization
- Data Warehouse
- Data Warehouse ETL simplification
- Data Warehousing
- Data Warehousing\Business Intelligence
- Database
- Database Administration
- Database Administrator
- database aging
- Database backup
- Database Builds
- Database Configuration
- Database corruption
- Database Deadlock
- database delivery
- database dependencies
- Database Deployment
- Database Design
- Database Design and Implementation
- Database Development
- database diagram
- Database Drift
- database engine
- Database Engine Tuning Advisor
- Database File
- Database Files
- Database growth
- Database growth Status
- Database I/O
- Database information
- Database Lifecycle Management
- Database load
- database log file is huge
- Database Mail
- Database Maintenance
- Database Master Key (DMK)
- Database Migration
- Database Mirroring
- Database modelling
- Database objects
- database options
- Database Performance
- database permissions
- Database projects
- Database properties
- Database Recovery
- Database Repair
- Database Reporting and Administration
- database restore
- Database Roles
- Database Scoped Configuration
- Database Scripts
- database size
- Database size in SQL Server 2012
- Database Snapshots
- Database Space
- Database Testing
- Database Upgrade
- Database Users
- Database version control
- Database Weekly
- Databases
- Databases Backup
- databases managment
- database-scoped credential
- Databricks
- Databse Mirroring SQL Server
- Datafile
- Datalength
- data-modeling
- DataType
- Datatype Conversion
- DataTypes
- Datazen
- Date
- Date Calculations
- Date computation
- date conversion
- date datatypes
- Date Difference
- date dimension
- Date Functions
- Date Manipulation
- Date/Time
- DATEADD
- DateDiff
- DateFirst
- Dateformat
- DateTime
- Datetime conversions
- Datetime Functions
- Datetime Manipulation
- Datetimeoffset
- DateTimes Difference Duration
- DAX
- Days since last backup
- DB Administration
- DB Growth
- db memory consumption
- db name
- DB online
- DB performance
- DB Source Control
- db_datareader
- DB_Mail
- db_owner
- DBA
- DBA Basics
- DBA Concepts
- DBA in Space
- dba skills
- DBA tips
- DBA Tools
- DBAStar
- dbatools
- DBCC
- DBCC CHECKDB
- DBCC CHECKIDENT
- DBCC CLONEDATABASE
- DBCC Commands Category:
- DBCC InputBuffer
- DBCC Shrinkfile
- DBMAIL
- DBPro
- dbroles
- dbWarden monitoring maintenance
- dd
- DDL
- DDL Auditing
- DDL trigger
- DDL Triggers
- deadlocks
- Dealing With Errors
- debug
- Declaration
- Declarative Referential Integrity (DRI)
- declare
- decomissiondatabase
- Dedicated Administrator Connection (DAC)
- Deduplicate
- Default Constraint
- default database
- default schema
- Default settings
- Default Trace
- Defaults
- Defects
- defensive programming
- Deferred Name Resolution
- defragmentation
- Defragmentation.
- Delayed Durability
- Delegation
- delete
- Delete Change Tracking sys.syscommittab table
- Delete Data
- Delete Files
- delete rows
- Deleting Data
- Deleting Data Referential Integrity
- Delimited List
- Delimited Strings
- delimiters
- Delphi
- Denali
- denormalization
- Dependencies
- dependency
- Deploying
- deployment
- Deployment Process
- Deprecated Features
- Derived Column
- Derived Columns
- DerivedTables
- Design
- Design and Theory
- Design pattern
- Designing database
- desktop BI
- detach database
- deterministic
- Development
- Development Process
- DevOps and Continuous Delivery (CI/CD)
- diagnostic
- Diagram
- diagrams
- Difference
- differential
- dimension
- dimensioning
- Dimensions
- Directory
- dirty pages
- Disable / Enable All triggers
- Disaster Recovery (DR)
- DISK
- disk space
- Disk space monitoring
- Disk speed
- disks
- diskspd
- Display SQLservices info
- Distance Calculation
- DISTINCT
- Distributed computing
- Distributed Queries
- Distributed Replay
- Distributed Transactions
- Dividing comma seperated values
- DLM
- DML
- DMO
- DMV
- DMVs
- DNS
- DNX
- Docker
- Documentation
- Documenting Code
- DONEPROC
- Double Hop
- Downgrading
- DRI
- Drive space
- DROP
- Drop Column
- drop database objects
- drop indexes
- Drop Table
- Dropping table
- DSQL
- dtc
- DTS
- Duplicate
- duplicate data
- duplicate records
- duplicate rows
- duplicates
- Duration
- dynamic
- Dynamic Code Analysis
- Dynamic Cross Tabs
- Dynamic Data Masking
- Dynamic Management View
- Dynamic query
- Dynamic Script
- Dynamic Search
- Dynamic SQL
- Dynamic Tables
- D-YQWTX-G8T4R-QW4XX-BVH62-GP68Y
- Easter Sunday
- EAV
- ebook
- Edition
- editions
- Editorial
- Editorial - iPod
- Editorial - MP3
- Editorial - WMV
- Education
- EDW
- ee
- Effective Dating
- Elapsed time measurements
- Email
- Email Address
- Embedded Edition
- EMONTH
- emotion
- employement
- Encryption
- endpoints
- Engineering
- English Query
- Enterprise Administration
- Enterprise solution
- Enterprise-only features
- Entity Framework
- EOMONTH()
- EPPlus
- Error Handling
- Error Log
- Error Messages
- errorlog
- ERRORS
- ETL
- ETL (Extract Transform and Load)
- ETL/SSIS/Azure Data Factory
- event
- Event Notification
- Event Notifications
- Event Streaming
- Events
- Exams
- Excel
- Excel 2007
- EXCEL FILE
- EXCEPT
- Exceptional DBA
- Exceptional DBA Awards
- Execute
- Execute AS
- execute process task
- Execution Logging
- Execution Plan
- Execution Plans
- Exotic Join
- Explicit Transactions
- Export
- export data
- Express Edition
- Expressions
- Extended Events (XE)
- extended properties
- Extended Property
- Extended Stored Procedures
- extendedvents
- Extent
- Extract, Transform, Load (ETL)
- Extracting data
- Extracting Integer
- Extreme Programming
- failover
- Failover Clustered Instance (FCI)
- fdsafdsafdsafdsa
- features
- Federations
- Fetch
- ff
- fibonacci
- FIFO
- FIFO Queues
- File Size
- File System Task
- FileGroup
- Filegroups
- Filename
- FILEPROPERTY()
- Files
- Files and Filegroups
- FileSize
- FILESTREAM
- FileTable
- Fill Factor
- Filter Backup
- Filtered
- Filtered Index
- Filtered Indexes
- Financial Month
- Financial Rounding
- find
- Finding Dependencies.
- firewall
- FIRST_VALUE
- Fiscal Year
- Fixing Orphaned users
- FizzBuzz
- FK
- float
- FLOOR()
- Flyway
- FMTONLY
- Foolishness
- football
- FOR JSON
- FOR XML
- FOR XML PATH
- Forced Parameterization
- FORCESCAN
- Foreach Looping logic
- Forecast
- foreign keys
- Foreign Keys (FK)
- FORMAT()
- formatting
- Formula
- Fragmentation
- framework
- Free Training
- FTP
- FTP Task
- FULL JOIN
- full text search
- Full Text Searching
- Full-Text Search
- Full-Text Search (2005)
- Full-Text Search (2008)
- Full-Text Search (FTS)
- fun
- function
- Function;
- Functional Dependency
- Functional programming
- functions
- Fuzzy
- Fuzzy Match
- FxCop
- Game
- Gaps
- Garcinia Life Plus
- GDPR
- General
- generate create table script
- generate large sample data
- generate numbers
- Generate scripts
- GENERATE_SERIES()
- Generator
- GenesisOne
- geocode
- geo-replication
- get candidate keys for a table
- GET_BIT()
- GETDATE
- GETDATE()
- gg
- ghost cleanup
- ghost record
- Git
- GitHub
- global
- Global temporary table
- GO
- golang
- Google
- Google Cloud SQL
- Government
- GPT
- Grafana
- Grant Fritchey
- Graph databases
- GraphQL
- Graphs
- green coffee bean max
- Groouping
- GROUP BY
- Group Managed Service Accounts
- Grouping
- grouping sets
- Growth
- Guest User
- GUI
- GUID
- Guids
- HA/DR/AG/FCI/Clustering/Business Continuity
- Hadoop
- Hamming Weight
- Hardware
- hash
- Hash Functions
- Hash join
- HASHBYTES()
- hashing
- HDInsight
- Head Blocker
- HEADERONLY
- health
- Health Check
- healthcheck
- heap
- Heaps
- Hekaton
- help to solve this query..
- Hexadecimal
- hh
- Hibernate
- hierarchical data
- Hierarchies
- Hierarchy
- HierarchyID
- High Availability (HA)
- hints
- HIPAA
- Hiring
- history
- History size database files
- HKS
- holiday
- How can i Auto shirink true in to tempdb?
- How to create a popup SSRS report
- How to show this row data column wise?
- How would you design this
- Howlers
- HP Enterprise DBC Appliance
- HTML
- humor
- Hybrid cloud
- Hydro Muscle Max
- Hyper-V
- I need one help.
- I/O
- IaaS
- IBM
- IDENT_CURRENT
- Identifiers
- Identify illegal characters
- IDENTITY
- IDENTITY Property
- IDENTITY()
- IDENTITY_INSERT
- IFF
- ILM
- images
- Immutable databases
- implicit conversion
- import
- import export wizard
- importing data
- Importing Data from Excel
- IN Operator
- included columns
- Incorrect syntax near GO
- index count
- Index Rebuild
- Indexed Views
- Indexes
- Indexing
- Information Schema
- INFORMATION_SCHEMA
- infrastructure
- Inline Function
- In-Memory
- in-memory oltp
- In-Memory OLTP Tables
- input validation
- insert
- INSERT - DML COMMAND
- Inside-SQL
- Install
- Install Instance
- Installation
- Instance
- instancename
- Instant File Initialization (IFI)
- instead of trigger
- integer to binary
- Integers
- Integration Services
- Integration Services (SSIS)
- Integration Services (SSIS_
- integrity
- Intelligent Query Processing
- Interim File
- Internet of things
- Intersect
- Interval
- Intervals
- Interview
- interview questions
- Interviews
- Inventory
- IO
- io performance
- IOT
- IP Address
- IP Addresses
- IPv4 Addresses
- IronPython
- iscsi
- ISNULL
- IsNumber
- ISNUMERIC()
- Isolation Levels
- It is launched as is.
- Iterative
- ITIL
- its description related for ppc add descriton
- its description related to facebook description
- its just a description for ppc
- iTVF
- Itzik
- Itzik Ben-Gan
- java web development
- JavaScript
- JDBC
- Jeff Moden
- Jenkins
- JET
- Job Dependencies
- Job history
- Jobs
- joe celko
- JOIN
- Join Ordering
- Join Predicate
- JOIN SET MATH LISTS
- JOINS
- Joma Alrzini
- journal
- JSON
- Jupyter Notebook
- Kafka
- Kerberos
- key lookup
- kill
- Kill Processes
- Knowledge
- kpi
- ksdsd
- laaS VMs
- LAG
- LAG function
- laptop
- large data
- Large Data Sets
- Large Projects
- Last reboot time
- LAST_VALUE
- Latching
- Latest Backup
- latitude longitude distance coordinates Vincenty
- LDAP
- LEAD
- LEAD Function in 2008
- Learn SQL
- learning
- LEN
- LEN()
- Levenshtein
- Licensing
- like
- Limitation
- link esteblishment
- Linked Server
- Linked Servers
- LINQ
- LINQ to SQL
- Linux
- Linux SQL Server
- List all running jobs.
- list scheduled jobs
- Litespeed
- live query statistics
- LIVE QUERY STATS - SQL 2016 Feature
- Lmage Eye Serum
- LocalDB
- Lock
- Lock and Connection Management
- Lock Pages in Memory
- Lock Timeout
- Locking
- Locks
- log
- Log File Maintenance
- LOG Files
- Log growth
- Log Shipping
- Logfile names
- logging
- Logic Puzzle
- login
- Logins
- Logon Trigger
- Lookup
- Lookup Logic
- Loops
- LOT-442 certification exam
- Lottery Numbers
- LPC-201
- ltrim
- M Langauge
- Machine Learning
- Machine Learning (ML)
- Machine Learning Services (MLS)
- Mail
- Mail Profile
- Maintainable Code
- Maintenance
- Maintenance and Management
- Maintenance Plans
- maintenance purge cleanup
- Managed Backup
- Managed Instances
- Management
- Management Data Warehouse
- Management Studio (SSMS)
- Map Tool
- MariaDB
- Master Data Management (MDM)
- Master Data Services (MDS)
- Master Database
- math
- Math Functions
- Matrix
- max
- Max Degree of Parallelism
- max memory setting
- Max Worker Threads
- MAX()
- MAXDOP
- MAXERRORS
- MAXX()
- MCTS
- MDM
- MDS
- MDW
- MDX
- Measurable applications
- MEDIAN
- Meetings
- megadrox
- Memory
- Memory Corruption
- Memory lane
- Memory Management
- Memory Optimized
- Memory Optimized Tables
- Memory Quota
- Memory Tuning
- Memory Usage
- memory-optimized table
- Memory-Optimized Table Storage
- Memory-Optimized Tables
- MERGE
- Merge Replication
- MERGE Statement
- Merge Vs. Insert-Update
- Metadata
- Metrics
- microservices
- Microsoft
- Microsoft Access
- Microsoft Fabric (Azure Synapse, Data Engineering, etc.)
- Microsoft News
- Microsoft R Services
- Microsoft Server Integration Services
- Microsoft SQL Server
- Microsoft SQL Server (MSSQL)
- MicroStrategy
- Middle tier
- Migration
- Migration Assistant
- migrations-based
- Mind map
- minionware
- Mirroring
- misaligned log IO
- Misc
- Miscellaneous
- Missing Index
- Missing Index finder
- Missing Indexes
- Missing Numbers
- mistake
- Mistakes
- Mobile App Development
- Mobile Dashboard
- mod
- Model Database
- Modeling
- money
- MongoDB
- MONGODB Source
- monitor
- Monitor Server
- Monitor SQL Server and Service
- Monitor URL
- Monitoring
- Month Name
- Monty
- mount points
- Move Files
- Moving Average
- Moving Data from Current to History.
- moving databases
- MPP
- MS Access Reports
- MS Azure
- MS SQL
- MS SQL 2008 Policy-Based Management &
- MS SQL 2012
- MS SQL Server Agent
- MSBI
- MSBI- SSIS
- msdb
- msdb database huge
- MSDE
- MSDTC
- mssql
- MSSQL administration
- MSSQLSERVER
- Mulesoft
- Multi Column SSRS Stored Procedure
- multi-platform
- Multiple Cascade
- Multiple Instances
- Multiple rows value in single column
- Multiply
- Multiply Arbitrary Length Integers
- Multi-Select Parameters
- multi-server management
- Mutex
- MySQL
- MySQL 7
- named instance
- Naming Standards
- Need Guidance on SP ETL
- Neeraj Yadav
- Nested Stored Procedure
- Net Meeting
- netbackup
- NETWORK
- Network Load Testing
- New feature
- News
- NEWSEQUENTIALID()
- nHibernate
- nmap
- Nolock
- Normalisation
- Normalization
- NoSQL / NewSQL
- Notes
- Nothing about SQL
- notification
- Notification Services
- NOWAIT
- ntext
- Nth occurrence of a weekday in a month and year
- ntile
- NuGet
- NULL
- NULLIF
- NUMA
- Number of Rows Read
- numbers
- Numbers Only
- nvarchar(max) vs nvarchar
- Obfuscate
- object
- Object Dependencies
- Object Search
- Object Search Script for SQL Server 2005
- objects
- Observability
- oData
- ODBC
- ODBC functions
- Oddity
- OFFSET
- OLAP
- OLAP Server
- ole
- ole automation
- OLTP
- On-Call Duties
- online
- online education
- Online Training
- Open Data
- OpenDataSource
- OPENJSON
- OpenPOWER
- OPENQUERRY
- OPENQUERY
- OPENROWSET
- OpenStack
- OpenXML
- Operational Analytics
- operations
- Operations Manager
- Operator precedence
- Operators
- Optimiser
- Optimization
- Optimizer
- Optimizer_WhatIF
- options
- Oracle
- Oracle Ref Cursor SSIS
- order by
- Ordnance Survey OS Data
- ORIGINAL_DB_NAME()
- Orphan users
- orphaned users
- OS
- Other
- Outer Joins
- Outlier Detection
- outlook
- output
- output clause
- OVER()
- overlap
- Ownership
- Ownership chaining
- Package Parts
- packaged applications
- page
- Page Repair
- PAGE_VERFIFY
- pages
- paging
- Paging Data
- PAL Tool
- parallel processing
- parallelism
- parameter
- Parameter Sensitive Plan Optimization
- Parameter Sniffing
- Parameterization
- Parameterized Queries
- parameters
- Parameters Passing
- Paritioning
- parse
- PARSE()
- PARSENAME
- PARSENAME()
- Parsing
- partition
- partition elimination
- partition switch
- partition table
- Partition Tables
- Partitioned Tables
- Partitioned Views
- Partitioning
- Partitions
- pass
- PASS Summit
- PASS Virtual Chapters
- password
- password cracking
- Passwords
- Patches
- Patching
- Patindex
- PayPal
- pdf
- Peer to peer replication
- PERCENT_RANK
- PERCENTILE_CONT
- PERCENTILE_DISC
- PerfMon
- Performance
- performance analysis
- Performance and Tuning
- Performance Counters
- Performance Dashboard
- Performance Dashboard Reports
- Performance Monitoring
- Performance testing
- Performance Tools
- Performance Tuning
- PerformancePoint
- PerformanceTuning
- Perl
- Permissions
- permutations
- Pester
- Philosophy
- phonetic
- PHP
- ping
- Ping Servers
- pivot
- pivot table
- Pivoting
- plan
- plan cache
- Planguide
- platform engineering
- Platform Refresh
- PLEASE UPDATE COMMAND
- Podcast
- Poisson Distribution
- Policy Based Management (PBM)
- Polls
- PolyBase
- Port
- postcode
- PostgreSQL
- Power BI
- Power BI dashboards
- Power BI Designer
- Power BI Desktop
- Power Consumption
- Power Pivot Upgrade to 2012.
- Power Query
- Power View
- PowerBI
- Powerpivot
- PowerPivot/PowerView/PowerQuery/PowerBI
- PowerShell
- PowerShell Tool Time
- PowerView
- Precedence
- PRECISION
- Precision Evaluation Script
- Predicates
- Presentations
- press release
- Primary data file
- Primary Key (PK)
- Prime Numbers
- Principals
- Print
- Privacy
- problem solving
- Problem with Finding Length in the SQL
- Procedure
- Product and Book Reviews
- Product News, Releases, and Upgrades
- Professional Development
- Profiler
- Programming
- project management
- Proper Case
- ProperCase
- provisioning
- proxy accounts
- Prudentia Consulting Pte Ltd
- Public Speaking
- purgingtable
- Puzzle
- Python
- QA-Taskpad
- Qlikview
- QOTD
- QR Code
- Queries
- query
- Query Analyzer
- Query Answers with SQL Server
- Query Data Store (QDS)
- Query Optimization
- Query Optimizer
- Query performance
- query plan
- Query plans
- Query Store
- Query Tuning
- Querying
- queryperformance
- QUERYRULEOFF
- Queue processing
- Queues
- Quine-McCluskey
- QUOTED_IDENTIFIER
- QUOTENAME()
- R
- R Language
- R Package
- R Platform
- R Programming
- R Services
- R Services installation
- RAID
- raiserror
- RAND()
- Random Data
- Random Numbers
- RangeS-S
- rank
- Ranking Functions
- RANKX()
- Ransomware
- Rants
- Rationalisation
- Raw Materials
- RDS SQL Server
- React
- Read
- read only
- readonlydatabase
- ReadyRoll
- Rebuild
- Rebuild Index
- Rebuilding indexes
- Rebuilding system databases
- recompile
- Recovery Interval
- Recovery Model
- recovery pending state
- Recursion
- RECURSIVE
- Recursive CTE
- Recursive function
- RedGate
- Redgate Challenge
- Redgate Skills
- Redgate Software
- Refactoring
- Reference
- Reference Data
- Referential Integrity
- refresh
- RegEx
- Registered Servers
- Regular Expressions
- Reindex
- relational
- Relational Algebra
- relational databases
- relational division
- Release Management
- release testing
- releases
- Remote Connection tool
- Removing duplicates
- rename
- rename primary key
- renaming
- REPLACE()
- REPLICATE
- Replication
- replication monitor
- Report Builder
- Report Designer
- Report Development
- Reporting
- Reporting Services (SSRS)
- required Privilege
- research
- RESEED
- Reserved Words
- Resource Database
- Resource Governor
- RESOURCE_SEMAPHORE
- REST API
- Restart
- Restore
- Restore Genie
- review
- Reviews
- RevolutionR
- RevoScaleR
- RID Lookup
- Ring Buffer
- RINU
- Risk Management
- RK
- Role
- Roles
- Rollback
- Rollup
- Roman number
- ro-RO
- round
- ROUND()
- Row Compression
- Row Constructor
- Row Count
- Row sorting
- Row Versioning
- ROW_NUMBER()
- Row-Level Security (RLS)
- rows
- Rows to Columns
- RowSize
- RSExecutionLog
- RSS
- Rules
- Run As
- running count
- Running Totals
- S3
- SA
- Salary Survey
- salesforce
- Sample Chapters
- SAN
- Sanpshot
- SAP HANA
- SARGability
- saturday
- Saurabh Sinha
- Scala
- Scalability
- Scalar UDF
- Scale-out
- Schedules
- Schema
- schemachanges
- Schemas
- SCOM
- SCOME
- script
- Script Task
- ScriptDOM
- scripting
- Scripting Fun - Cursor Vs While
- Scripts
- scripts to update the table using cursor
- Search
- search database
- Secure
- Secure Programming
- Security
- Security Audit
- seek
- Seeks
- select
- SELECT *
- SELECT INTO
- select join range performance
- Select Query
- Select to array
- self deleting Job
- Semantic Search
- Senior Database Administrator
- Separation of duties
- sequence
- Sequence Numbers
- Sequence Object
- sequence of letters
- SEQUENCING
- Serial ID
- Server configuration
- Server Migration
- Server Roles
- Server side trace
- Server Space
- ServerLess
- Server-Level Collation
- SERVERPROPERTY
- Service Accounts
- Service Broker (SSSB)
- Service Owner
- Service Packs
- Session
- Session settings
- SESSION_CONTEXT()
- Set Based
- Set DateFormat
- SET NUMERIC_ROUNDABORT
- SET Options
- SET STATISTICS IO
- SET STATISTICS PROFILE
- set-based
- set-based loop
- settings
- setup
- Shared development
- Sharepoint
- Sharma
- Sharon Rimer
- shipping
- shortcuts
- Showplan
- shrink
- Shrink Database
- SHRINKFILE
- Shrinking Transaction Log File
- SID
- SID Mismatch Check
- SIGN()
- SignalR
- Silly Question
- simple talk
- Simple-Talk
- Simple-Talk Series
- size
- size database
- Skills Check
- slipstream
- Slowly Changing Dimensions
- Slowly Changing Facts
- Slow-Running Queries
- smalldatetime
- SMO
- SMO, RMO, AMO
- SMTP
- snapshot
- Snapshot Replication
- Snowflake
- SOA
- social networking
- Soft Skills
- software development
- software testing
- sort
- SORT OPERATOR
- soundex
- source control
- sp_addextendedproperty
- sp_allnightlog
- sp_Blitz
- sp_configure
- sp_depends
- sp_detach_db
- sp_executesql
- sp_helpdb
- sp_helptext
- sp_helptext()
- sp_import_errorlog
- sp_msforeachdb
- sp_msforeachdb.
- sp_msforeachtable
- sp_prepexec
- sp_refreshsqlmodule
- sp_refreshview
- sp_rename
- sp_resetstatus
- sp_send_dbmail
- sp_spaceused
- sp_start_job
- sp_uforeach
- sp_who
- sp_who2
- SP_who3
- sp_whocpu
- sp_whoIO
- sp_whom
- space
- space allocation
- space management
- space monitoring
- Space Usage
- sparse
- Sparse Column
- Sparse Columns
- Spatial
- Spatial Data
- Spatial Data Types
- Special characters
- Specialization
- SPID
- spinlock
- split
- split string
- SPLIT_STRING()
- Splitting strings
- sponsored article
- sports
- SQL
- SQL Agent
- SQL Alerts
- SQL Audit
- SQL Browser
- SQL Census
- SQL Change Automation
- SQL Clone
- SQL CLR
- SQL Cluster
- SQL Code
- SQL collation
- sql commands
- SQL Compare
- SQL Connections
- SQL Data Compare
- SQL Data Exploring
- SQL Data Warehouse
- SQL Database Search
- SQL DBA
- SQL Diag
- SQL Directory Size
- SQL Doc
- SQL Documentation
- SQL elapsed times
- SQL Engine
- SQL Error Logs
- SQL ErrorLog
- SQL Family Feud
- Sql Functions
- SQL Generation
- SQL in the City
- sql injection
- SQL Installation
- SQL Intersection
- SQL Jobs
- SQL joins
- SQL LIKE SEARCH
- SQL Lunch
- SQL memory performance analyzer
- SQL Migration Assistant
- SQL Monitor
- SQL Monitoring
- SQL Next
- sql n-Tuples
- sql password
- SQL Performance
- SQL Powershell
- SQL Profiler
- SQL PROMPT
- SQL Provision
- SQL Puzzles
- sql query
- SQL Rally
- SQL Relay
- SQL Response
- SQL Restore
- SQL Sat
- SQL Saturday
- SQL Script
- SQL Script- Automation.
- SQL script to populate the data as below
- SQL Scripts Manager
- SQL Server
- SQL Server 2000
- SQL Server 2005
- SQL Server 2008
- SQL Server 2008 R2
- SQL Server 2011
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2016 Performance
- SQL Server 2017
- SQL Server 2017 on Linux
- SQL Server 2019
- SQL Server 2022
- SQL Server 2025
- SQL Server 6.5
- SQL Server 7
- SQL Server Agent
- SQL Server Alias
- SQL Server Architecture
- SQL Server Audit
- SQL Server Compact Edition (SSCE)
- SQL Server Configuration Manager
- SQL Server Data Services
- SQL Server Data Tools (SSDT)
- SQL server database task
- SQL Server Denali
- SQL Server Express
- SQL Server Graph Database
- SQL Server Instance
- SQL Server internal storage
- SQL Server Licensing
- SQL Server Mail
- SQL Server Management Studio
- sql server monitoring
- SQL Server News
- SQL Server Objects
- SQL Server on Linux
- SQL Server opearation studio
- SQL Server patching
- SQL Server performance
- SQL Server R Services
- SQL Server Replication
- SQL Server Reporting Services
- SQL Server security
- SQL Server String Operation
- SQL Server TRACE
- SQL server training
- SQL Server Upgrade
- SQL Server v.Next
- SQL Server versions
- SQL Server Workgroup Edition
- SQL Sever
- SQL Source Control
- SQL Spackle
- SQL Syntax
- SQL System Database
- SQL TABLE TYPE
- SQL Test
- SQL Toolbelt
- SQL Trace
- SQL Triggers
- SQL Uniform Random Numbers
- sql#
- SQL_VARIANT
- SQLAgent
- sqlazure
- SQLBits
- SQLCLR
- SQLClue
- SQLCMD
- sqlcmd mode
- SQLCop
- SQL-DMO
- SqlDumpExceptionHandler
- SQLInsider Scripts
- SQLIO
- SQLite
- SQLMail
- SqlPackage
- SQLProfiler
- SQLSaturday
- SQLServer
- SQLServer2008R2
- sqlserverbuilds
- SQLServerCentral
- Sql-server-performance
- SQLskills
- SQLwaits
- srilatha
- Srini
- SSAS
- SSAS - Cubes with huge dimensions
- SSD
- SSDT
- SSIS Catalog Compare
- SSISDB
- SSL
- SSOX
- SSPI
- SSRS
- Stack
- Stairway Series
- Standards
- star schema
- Startup
- Startup parameters
- Startup stored procedures
- State of the Business
- static
- Static Code Analysis
- Statistical Analysis (mathematics)
- statistics
- statistics (data)
- status
- Storage
- Storage Management
- storage queues
- Storage Spaces Direct
- Storage Subsystem
- Stored Procedures
- Storing passwords
- STR
- Strategies
- StreamInsight
- Stress Testing
- Stretch
- Stretch Database
- String
- String Function
- String Functions
- String Manipulation
- string occurences
- String operations
- STRING_AG
- STRING_AGG
- STRING_SPLIT
- STRING_SPLIT()
- Structure
- STUFF
- STUFF()
- Sub-queries
- Subquery
- Subscription
- SUBSTRING
- Sudoku
- sum
- sum()
- summary table
- Support
- survey
- suspect
- Suspect Database
- suspect page
- Suspect Pages
- SWITCHOFFSET()
- Symantec OpsCenter Reporting
- Sync Framework
- synchronize database
- Synchronous
- synonym
- Synonyms
- syntax
- Syntax Check
- SYS.DATABASE_FILES
- sys.dm_exec_requests
- sys.fn_PhysLocFormatter
- sys.index_columns
- SYS.MESSAGES
- sysadmin
- syscomments
- Sysdtslog90
- sysprocesses
- system database
- System databases
- System Development Life Cycle
- system functions
- System Stored Procedure
- System Tables
- System Versioned Temporal Tables
- system views
- tabela
- Table
- Table compression
- Table Constraints
- Table Data Comparison
- table design
- table fields definition
- Table Hint
- Table Hints
- Table Name
- Table Row Count
- Table search
- Table Size
- Table space
- Table Spool Operator
- Table storedprocedure
- Table Value Constructor
- Table Value Constructor (TVC)
- Table Valued Function (TVF)
- Table Valued Parameters (TVP)
- Table Variables
- Table Warehouse
- tablediff Utility
- tables
- tables names
- Table-Valued Parameter
- tabular
- Tabular Model
- Tabular Report
- tally
- Tally Table
- Task
- T-Complex
- TCP
- TCP connection
- TCP/IP
- TDE
- Team Development
- technical debt
- Technology
- Telecommuting
- telemetry
- Temp tables
- tempdb
- tempdb utilization
- TEMPLATE
- Temporal Data
- Temporal Tables
- Temporary Objects
- Temporary Stored Procedures.
- Temporary Table
- Temporary Tables
- Teradata
- Term Extraction Transformation
- terminology
- Terraform
- test
- Test Data
- Test database
- Test Driven Development (TDD)
- test3
- Testadrox
- Test-Driven Development
- Testing
- testtesttest
- text
- TFS Server
- TFVC
- The Lighter Side
- the modern workplace
- theory
- Three Valued Logic
- THROW
- ththe
- TIME
- time dimension
- Time zone
- Time zone convertion
- timeline
- Timeticks
- Tips
- Tips and tricks
- T-Log
- To get the actual username of the user.
- To Process SSAS - Cubes
- Tool to Register Multiple SQL Server
- Tools for development
- Top
- Top buffer cache object
- trace
- trace files
- Trace Flag 7471
- trace flags
- trace-flag
- Tracing
- Tracking Schema Changes
- Training
- Transaction
- Transaction isolation
- Transaction Log
- Transactional Replication
- transactions
- Transfer Logins Administration
- translate
- TRANSLATE()
- Transparent Data Encryption (TDE)
- Travel/Hospitality/Recreation
- Tree
- TribalSQL
- trigger
- Triggers
- trim
- TRIM()
- Trivia
- Troubleshooting
- Truncate
- Truncate Table
- Truncating a database
- Truncating Tables
- TRY..CATCH
- TRY_CAST()
- TRY_CONVERT()
- T-SQL
- T-SQL Challenges
- tSQLt
- TSQLUnit
- Tuning
- TVP
- Twitter
- UDF
- UDM
- UDT
- uiii
- un comment
- Uncategorized
- Unicode
- uninstall
- UNION
- UNION ALL
- Unique constraint
- unique index
- unit of conversion
- Unit Test
- Unit Testing
- Unknown
- unpivot
- Unstructured Data
- Untrusted Foreign Key
- unused
- Unused procedure
- Unzip via SP !
- update
- UPDATE EACH ROW FIRST ROW VALUE UPDATE NEXT ROW
- Update Queries
- update statistics
- Update Stats
- update trigger
- UPDATE()
- Updated Columns List
- UpdateGrams
- updating statistics
- upgrading
- uppercase
- uptime
- URL
- User
- user connections linked server report
- User database
- User Defined Function
- User Defined Function (UDF)
- User Groups
- User permissions
- User-defined data types
- User-Defined Table Type
- USER-DEFINED TYPES
- users
- U-SQL
- UTF-8
- Utility
- Utility Control Point
- utility function
- values
- varchar
- varchar(max)
- Vardecimal
- Variables
- VB
- VBScript
- vCenter
- Vector Database
- Vendors/3rd-party Products
- Verify
- Version
- Version Control
- Version Control Systems (VCS)
- versioning
- Video
- Views
- virtual
- Virtual Chapters
- virtual memory
- Virtual Server
- Virtualization, containers, and k8s
- Visio
- Visual Analytics
- Visual Basic 6
- visual studio
- Visual Studio Code
- Visual Studio SSDT
- Visual Studio Team Services
- vivek
- VMWare
- vnext
- Votofel Force
- VS Code
- VSTS
- wait events
- wait statistics
- Waitfor
- Waste of my valuable time at work
- web service
- webinar
- Webinars
- What it the output of E1 and E2
- WHERE CLAUSE
- White Papers
- whitespace
- who
- Wild Card
- Wildcard
- WinDocks
- window functions
- Windows
- Windows 10
- Windows 2003
- Windows Authentication
- Windows Azure
- Windows Azure SQL Database
- Windows Cluster
- Windows Containers
- Windows Core
- Windows Firewall
- windows functions
- winforms
- WIP
- WITH
- WITH ENCRYPTION
- word
- Work environment
- work for women
- Workdays
- Working Hours
- workshop
- Worst Practices
- XEvents
- XML
- XML Datasource
- xp_cmdshell
- xp_getfiledetails
- XQUERY
- XSL
- Xtreme Nitro
- xxx
- XXXXX
- XXXXXXXXXXXXXXX