|
|
-
|
|
Data type conversion has been one of the most used features of any programming language. Microsoft SQL Server users are familiar with the two functions: CAST() and CONVERT() and use them regularly, and more specifically, interchangeably. A few months ago, I had written a post comparing the performan......
|
|
-
|
|
Part 01 of a 3 part summary on Microsoft TechEd (India) 2012 held in Bengaluru (Bangalore) from March 21-23, 2012 at the Lalit Ashoka Hotel. I attended TechEd 2012 as a TechEd Rockstar....
|
|
-
|
|
Today, we will talk about a slightly different, yet very common subject. We will talk about what are the different ways to measure the number of rows in a table. I found a couple of posts over the Internet, and I will reference them as and when I demonstrate the associated methods. This post basica......
|
|
-
|
|
SQL injection refers to the ability of an attacker to inject a rogue SQL command to the database within a seemingly legitimate request. One of the most common myths that surrounds SQL Injection is that it is due to the use of EXEC or EXECUTE. Some say – “simply replace EXEC with calls to sp_executesql and the system becomes SQL injection-proof”. This has to be the biggest misconception of all times around this subject....
|
|
-
|
|
One of the most popular of the blogging tools currently being used is the Windows Live Writer. In order to configure the Windows Live Writer to work with your blog on the Blogs Module of BeyondRelational.com, you only need to follow the following very s...
|
|
-
|
|
My blog on BeyondRelational.com (BR) is completing two years today! Here's a quick snapshot of the splendid & exciting journey that these two years have been....
|
|
-
|
|
Updating string data in-place - while there are lots of options, SQL Server always has something new. The .WRITE clause in the UPDATE statement provides partial data update, and promises to be a great alternative to REPLACE and STUFF depending upon the situation....
|
|
-
|
|
Open connections consume server resources. If you need to frequently disconnect all your open connections to the corresponding SQL server instances from the multiple queries open in SQL Server Managment Studio (SSMS), this neat little feature built into the SSMS can come in handy....
|
|
-
|
|
I attempt to bust an old wives tale surrounding table & column aliasing in your T-SQL query. Is it a myth that table & column aliasing impacts query performance? Or bloats the plan cache? Or hinders plan reuse? Join me as I try to answer these questions....
|
|
-
|
|
Today we explore a former table hint - FASTFIRSTROW - which tells the optimizer that it is important to have the first row returned as fast as possible, allowing the application to return results to the users faster. The table is now replaced by a query hint - OPTION(FAST n)...
|
|