Advertisements

SQL SERVER – Talking Points


List of SQL Server – Taking Articles

Sr. No Article
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

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s