Advertisements

SQL SERVER – Talking Points


List of SQL Server – Taking Articles

Sr. No Article
206 SQL SERVER | Disabling INDEXES : Clustered Index – A Good Idea ? | SQL Interview Question
205 SQL SERVER | Enable or Disable CONSTRAINTs? | SQL Interview Question
204 SQL SERVER | Table-Valued Parameters – Marshal multiple rows of data to SQL
203 SQL SERVER | How to import CSV DATA using BULK INSERT?
202 SQL SERVER – What is the Maximum Length for creating non-clustered index?
201 SQL SERVER | Can you Skip Header Row in BULK INSERT?
200 SQL SERVER | Handling Special characters with For XML PATH(”) Puzzle
199 SQL Server | Deterministic and Nondeterministic Functions?
198 Free Online Utilities to write SQL code – SQL Server, Oracle, mySQL Server, PostgreSQL, MariaDB
197 SQL SERVER | SSMS 17.3 New Feature – XE Profiler
196 SQL SERVER | SSMS v17.3 New Feature – Import Flat File Wizard
195 NEW T-SQL FEATURES IN SQL SERVER 2017- III [ STRING_AGG() ]
194 NEW T-SQL FEATURES IN SQL SERVER 2017- II [ TRIM() Function – Remove Leading and Trailing Spaces from a String ]
193 NEW T-SQL FEATURES IN SQL SERVER 2017- IV [ DBCC CLONEDATABASE ]
192 2017 | New Data Management Tool for SQL Server – SQL Operations Studio
191 NEW IN SQL SERVER 2017 – SQL SERVER available in Multiple Operating Systems
190 NEW T-SQL FEATURES IN SQL SERVER 2017- V [ CONCAT_WS() ]
189 NEW T-SQL FEATURES IN SQL SERVER 2017- IV [ TRANSLATE() ]
188 NEW T-SQL FEATURES IN SQL SERVER 2017- VII | Resumable Online Index Rebuild
187 NEW T-SQL FEATURES IN SQL SERVER 2016 – XVII | JSON_MODIFY()
186 NEW T-SQL FEATURES IN SQL SERVER 2016 – XV | JSON_VALUE()
185 NEW T-SQL FEATURES IN SQL SERVER 2016 – XIII | ISJSON()
184 NEW T-SQL FEATURES IN SQL SERVER 2016 – XII | OPENJSON Function (SQL Server)
183 NEW T-SQL FEATURES IN SQL SERVER 2016- X [ FORMATMESSAGE() ) ]
182 NEW T-SQL FEATURES IN SQL SERVER 2016 – XIX | PolyBase
181 NEW T-SQL FEATURES IN SQL SERVER 2016 – XVIII | Dynamic Data Masking
180 NEW T-SQL FEATURES IN SQL SERVER 2016 – XIV | JSON Support in SQL Server 2016
179 NEW T-SQL FEATURES IN SQL SERVER 2016 – XI | Temporal Tables
178 NEW T-SQL FEATURES IN SQL SERVER 2016- IX [ SESSION_CONTEXT() ) ]
177 NEW T-SQL FEATURES IN SQL SERVER 2016- VIII [ TRUNCATE TABLE WITH ( PARTITIONS ( … ) ) ]
176 NEW T-SQL FEATURES IN SQL SERVER 2016- VII [ USE HINT query hint argument ]
175 NEW T-SQL FEATURES IN SQL SERVER 2016- VI [ STRING_ESCAPE() ]
174 NEW T-SQL FEATURES IN SQL SERVER 2016- V [ DATEDIFF_BIG() ]
173 NEW T-SQL FEATURES IN SQL SERVER 2017- IV [ DBCC CLONEDATABASE ]
172 NEW T-SQL FEATURES IN SQL SERVER 2016- III [ CREATE OR ALTER ]
171 NEW T-SQL FEATURES IN SQL SERVER 2016- II [ STRING_SPLIT() ]
170 NEW T-SQL FEATURES IN SQL SERVER 2016 – I
169 What you mean by Hot and Cold Data?
168 ALTER Table – [ WITH { CHECK | NOCHECK } ] { CHECK | NOCHECK } CONSTRAINT | ALTER Table with CHECK options??
167 SQL Server | SQL SERVER Resource Database – Deep Dive
166 SQL Server | SQL Server – Logical and Physical Operators
165 SQL Server | Table Variables & Estimated No of Rows
164 SQL Server | Types of Spools in Execution Plan – Deep Dive
163 SQL Server | How to handle large number of insertions in SQL Server?
162 SQL Server | Where CTEs are stored?
161 SQL Server | How to write optimized queries
160 SQL Server | How SQL SERVER handles duplicate values in an index?
159 SQL Server | Execution/Query Plan Operator – The Concatenation
158 SQL Server | Why Lookups are bad for performance?
157 SQL Server | Spools in Execution Plan. Are they bad?
156 SQL Server | What you should look in execution plans?
155 SQL Server | How to avoid/eliminate/remove ORDER BY from SQL Queries?
154 SQL Server | Table Variable – Estimated no of rows = 1 | No Statistics?
153 SQL Server | Execution/Query Plan Operator – The Sort Operator – Part II, Which sorting algorithms used by SQL Server? Is it blocking or non-blocking?
152 SQL Server | Execution Plan Operator – Properties, Types – Blocking / Non-Blocking?
151 SQL Server | Why Order By is bad in Queries? / Execution/Query Plan Operator – The Sort Operator Basics
150 SQL Server | What is Selectivity? How we can use this in creating our indexes?
149 SQL Server | What are the internal methods of Physical Operators? How they work?
148 SQL Server | What controls an Index Scan to read all pages from leaf level? Or An Index scan operator always reads all pages from leaf level?
147 SQL Server | Implicit Conversions are Bad for Performances? Why?
146 SQL Server | How to find latest order Id from Orders table for each product? (Top n orders for each product) Let’s write a better query.
145 SQL Server | How to properly read an Execution Plan/Query Plan?
144 SQL Server | LIKE IS SARGable, How to write better Where Clause –II. Let’s Check?
143 SQL Server | CAST IS SARgable, How to write better Where Clause. Let’s Check?
142 SQL Server | Update Statistics – Synchronously and asynchronously. Which one is better?
141 SQL Server | Why we should update statistics? When one should update statistics?
140 SQL Server | Avoid Using Function in WHERE Clause. Why?
139 SQL Server | What is Plan Cache? Why it is important?
138 SQL Server | Raw SQL Vs Stored Procedures?
137 SQL Server | Estimated Execution Plan versus Actual Execution Plan?
136 SQL Server | Execution Plans?
135 SQL Server | Which one is better | Temp Table or Table Variable?
134 SQL Server | Don’t ever do SELECT *. It’s really a bad idea. Why?
133 SQL Server | Performance issues due to bad statistics?
132 SQL Server | What are Statistics & why they are important
131 SQL Server | SQL Server Query Optimizer
130 SQL Server | Differences – Clustered & NonClustered , Clustered & Primary Key
129 SQL Server | Filtered Index
128 SQL Server | NonClustered Index with Included Columns & Covering Index
127 SQL Server | Index – Clustered & NonClustered Index
126 SQL Server | Different Methods to get Row Numbers WITHOUT Order By Clause in SQL Server
125 SQL Server | Multiple ways to convert an Integer value to String
124 SQL Server | SQL 2014 In Memory OLTP (Hekaton)
123 SQL Server | Find Number of Days in a Year
122 SQL Server | Different Methods to Insert multiple rows using single Insert Keyword
121 SQL Server | Multiple ways to find distinct rows without using distinct Keyword
120 SQL Server | Explicitly inserting data into an IDENTITY column
119 SQL Server | GUID causes fragmentation in Clustered Indexes
118 SQL Server | Cardinality IN SQL 
117 SQL Server | SQL SERVER 2014 New Features
116 SQL Server | Cast vs Convert 
115 SQL Server | Find No of Column in a Table 
114 SQL Server | Difference between Count(1) / Count(1000) 
113 SQL Server | Len Vs Data Length 
112 SQL Server | Unique Key 
111 SQL Server | Query-to-find-last-day-of-a-month-in-sql-server-2005/
110 SQL Server | Getdate VS Sysdatetime 
109 SQL Server | Stuff VS Replace
108 SQL Server | Bulk Insert 
107 SQL Server | Number of Indexes 
106 SQL Server | Print Row Numbers 
105 SQL Server | Explicit Value for Identity Column
104 SQL Server | Insert multiple rows using one Insert keyword 
103 SQL Server | Delete duplicate rows 
102 SQL Server | Find duplicate rows 
101 SQL Server | Cast vs Convert 
100 SQL Server | Find number of columns in a table 
99 SQL Server | IsNull 
98 SQL Server | IsDate
97 SQL Serve | Remove-date-from-datetime-field
96 SQL Server | Add-n-number-of-days-in-current-date
95 SQL Server | NULLIF
94 SQL Server | Clustered Key Vs Non Clustered Key
93 SQL Server | How-to-debug-a-stored-procedure
92 SQL Server | Copy-data-from-one-table-to-another
91 SQL Server | Remove-extra-multiple-spaces-in-string
90 SQL Server | Space Function
89 SQL Server | Row Count 
88 SQL Server | Error 
87 SQL Server | Exception-handling-in-sql-server-2005-using-try-and-catch/
86 SQL Server | Maximum-no-of-columns-in-a-table-in-sql-server-2005/
85 SQL Server | Use-of-objectproperty-to-find-whether-an-object-is-a-table-or-not-in-sql-server-2005/
84 SQL Server | Object and Column Property 
83 SQL Server | Insert-data-size-more-than-8000-in-a-column-in-sql-server-2005-and-not-more-than-12000/
82 SQL Server | Keys in Database
81 SQL Server | Data Pages and Extent 
80 SQL Server | Data Files 
79 SQL Server | Types of Pages 
78 SQL Server | Query Execution 
77 SQL Server | Indexes in Detail
76 SQL Server | ACID Properties
75 SQL Server | Difference between DBMS and RDBMS
74 SQL Server | Database 
73 SQL Server | Codds Rule
72 SQL Server | Advantages of Stored Procedures 
71 SQL Server | Recompile option in a SP 
70 SQL Server | Delete Vs Truncate 
69 SQL Server | Basics of Derived Table 
68 SQL Server | Replicate Function
67 SQL Server | Left Function 
66 SQL Server | Difference between Primary Key and Unique Key 
65 SQL Server | Right Function 
64 SQL Server | Updateable Views 
63 SQL Server | Magic Tables 
62 SQL Server | Database Paging using row number 
61 SQL Server | Page Split 
60 SQL Server | Page Structure 
59 SQL Server | Coalesce-statement-to-concatenate-all-the-rows-of-a-particular-column
58 SQL Server | waitfor-function-in-sql-server-2005/
57 SQL Server | Delete-duplicate-rows-from-a-table
56 SQL Server | Generate-a-complex-random-string
55 SQL Server | Usage-of-from-clause-in-update-statement
54 SQL Server | In-clause-for-multiple-columns
53 SQL Server | Find-created-and-last-modified-date of SP
52 SQL Server | Recursive-common-type-expression
51 SQL Server | Change-table-name-index-name-coumn-name-using-a-query-in-sql-server-2005/
50 SQL Server | Differences-between-stored-procedure-and-function 
49 SQL Server | Object Id 
48 SQL Server | Interesting Facts
47 SQL Server | System-tables-help
46 SQL Server | Information-schema-view
45 SQL Server | Ansi_nulls-on-off
44 SQL Server | Quoted-identifier-on-off
43 SQL Server | Renaming-your-database-in-sql-server
42 SQL Server | Difference-between-char-and-varchar-data-type
41 SQL Server | Difference-between-nchar-and-nvarchar-data-type
40 SQL Server | Difference-between-char-and-nchar-data-type
39 SQL Server | Difference-between-char-and-nchar-data-type/
38 SQL Server | Difference-between-numeric-and-decimal-data-type
37 SQL Server | Difference-between-varchar-and-nvarchar-data-type
36 SQL Server | Difference-between-smallmoney-and-money-data-type
35 SQL Server | New-data-types-in-sql-server-2005/
34 SQL Server | Differences-between-smalldatetime-and-datetime
33 SQL Server | Differences between Tinyint, smallint , int, bigint
32 SQL Server | Execution Plans 
31 SQL Server | Estimated Vs Actual Execution Plan 
30 SQL Server | Formats of Execution Plans 
29 SQL Server | UDF (User defined functions) 
28 SQL Server | Triggers – Basic Information 
27 SQL Server | Case-function-and-order-by-clause 
26 SQL Server | IsNumeric function
25 SQL Server |Disadvantages of Stored Procedures 
24 SQL Server | Views – Basic Information 
23 SQL Server | Types of Views 
22 SQL Server | Symmetric key creation 
21 SQL Server | Why-we-have-to-first-create-unique-Clustered-Key-on-view
20 SQL Server | Indexed Views with Schema binding
19 SQL Server | Basics of Normalization 
18 SQL Server | Normal forms 
17 SQL Server | Data Abstraction 
16 SQL Server| System Databases 
15 SQL Server | Transaction Isolation Levels 
14 SQL Server | Case Statement 
13 SQL Server | ISNULL Vs NULLIF 
12 SQL Server | Authentication Mode 
11 SQL Server | Use Statement 
10 SQL Server | DDL / DML / DCL / TCL 
9 SQL Server | Relational Engine 
8 SQL Server | SQL – TSQL 
7 SQL Server | Delete Cascade Update Cascade 
6 SQL Server | Union Vs Union ALL 
5 SQL Server | Table Scan | Index Scan | Index Seek 
4 SQL Server | Covering Index 
3 SQL Server | Set No Count ON 
2 SQL Server | Collation 
1 SQL Server | Fetch Status 
Advertisements

135 thoughts on “SQL SERVER – Talking Points”

  1. Kevin Lee said:

    Hello There,

    Great info! I recently came across your blog and have been reading along.
    I thought I would leave my first comment. I don’t know what to say except.

    We are running SQL Server 2014 Enterprise Edition hosting Dynamics AX 2012 R3 databases.
    It has been my experience that, while this is an easy concept, many fall short of understanding it in practice. Read consistency is nothing more than Oracle’s way of quarantining that the data / result set you request at a specific time will be available until the request is complete.
    We have some overnight batch processes that are running batch updates but we’re often getting blocking with these queries. The batch processes themselves are blocking a system process with a program name of “TASK MANAGER” with 2 open transactions.
    This seems to be causing the transaction log to fill up because the transaction log backup is unable to clear down the log.
    Having trawled the internet I cannot find a definitive answer as to what the TASK MANAGER process is doing. Some say it’s Change Tracking Cleanup others point to auto stats updates.
    Could someone please advise as to what this system process actually does?

    Anyways great write up, your efforts are much appreciated.

    Thanks a heaps,
    Jake

    Like

Leave a comment

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s