Skip to content

SQLSERVERLEARNER

LEARN SQL SERVER ONLINE

  • Home
  • About
  • Copyright

Year: 2012

  • Home
  • 2012
    • Interview Questions
    • SQL SERVER VARIABLES
    • SQLServerPedia Syndication
    • T-SQL Code Examples

Interesting Observation – Declaring Table Variables impact on Tempdb

By deviprasad
    • SQL Server Issues
    • SQLServerPedia Syndication

SSMS Available Databases DropDown Acts weird if Connection Properties Are Changed

By deviprasad
    • SQL Server Profiler

‘Ӈ耇’ was found in the text of this event

By deviprasad
    • T-SQL Code Examples

TSQL Script to remove TAB, LINE FEED and CARRIAGE RETURN

By deviprasad
    • SQLServerPedia Syndication
    • T-SQL Code Examples

Concatenating Data From Different Rows into Single Column Row

By deviprasad
    • T-SQL Code Examples

How to Find the List of Functions in SQL Server

By deviprasad
    • Msg 10054

Msg 10054, Level 20, State 0, Line 0

By deviprasad
    • SQL AZURE

This session has been assigned a tracing ID of ‘xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx’. Provide this tracing ID to customer support when you need assistance.

By deviprasad
    • Msg 141

Msg 141, Level 15, State 1, Line 3 A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

By deviprasad
    • SQL Server Misconceptions

SQL Server Misconception – NVARCHAR(MAX) Cannot Store More Than 4000 Characters

By deviprasad

Posts navigation

Older

Recent Posts

  • sp_xp_cmdshell_proxy_account – The provided account was invalid or the ##xp_cmdshell_proxy_account## credential could not be created Access is denied
  • Performance Tuning – Steps to make sure that you are comparing apples to apples
  • TSQL Script to fetch the list of tables with identity properties
  • TSQL Script to Clear SQL Server Cache
  • SQL SERVER 2016 Data Sheet

Recent Comments

  1. Bitsqueezer on HOW TO CONVERT TABLE DATA TO XML AND XML TO TABLE
  2. Elisandro Lima Armindo on Causes For Network Related Errors in SQL Server
  3. sql1 on Conversion failed when converting the varchar value xx to data type int.
  4. Mad Computerist on Concatenating Data From Different Rows into Single Column Row
  5. Nitin on sql server configuration manager remote procedure call failed

Archives

  • June 2018
  • August 2015
  • October 2013
  • September 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • January 2012
  • December 2011
  • August 2011
  • July 2011
  • June 2011

Categories

  • 10060
  • 10061
  • CHANGE DATA CAPTURE
  • Collations
  • Configuring SQL Server
  • Credentials
  • DatabaseBackup
  • DBCC Commands
  • Dead Lock
  • Dead Lock Resolution
  • Denali
  • Error Messages
  • Filtered index
  • Identity
  • Indexed Views
  • Interview Questions
  • Msg 10054
  • Msg 107
  • Msg 120
  • Msg 1205
  • Msg 121
  • Msg 127
  • Msg 141
  • Msg 15099
  • Msg 15122
  • Msg 15151
  • msg 15195
  • msg 15405
  • Msg 156
  • Msg 207
  • Msg 229
  • Msg 245
  • Msg 297
  • Msg 402
  • Msg 4606
  • Msg 4621
  • Msg 628
  • Msg 6401
  • Msg 7919
  • Msg 8152
  • Msg 8180
  • Nokia OVI Store
  • Performance Tuning
  • PROXIES
  • Puzzles
  • sp_executesql
  • SQL AZURE
  • SQL Date Time Functions
  • SQL Errors
  • SQL Security
  • SQL Server 2000
  • SQL Server 2008 R2
  • SQL Server 2010
  • SQL Server 2012
  • SQL Server 2016
  • SQL Server Abbrivations
  • SQL Server Basics
  • SQL Server Collations
  • SQL Server Download
  • SQL Server Installation
  • SQL Server Issues
  • SQL Server Links
  • SQL Server Management
  • SQL Server Misconceptions
  • SQL Server Permissions
  • SQL Server Profiler
  • SQL Server Tricks
  • SQL SERVER VARIABLES
  • SQLServerMaximumLimitations
  • SQLServerPedia Syndication
  • Stored Procedures
  • System Stored Procedures
  • T-SQL Code Examples
  • Table Variables
  • Temporary Tables
  • Tools
  • TOP Clause
  • VIEW CHANGE TRACKING
  • VIEW SERVER STATE
  • XML
Copyright © 2023 SQLSERVERLEARNER All Rights Reserved | Bloghill by Theme Palace