|
|
-
|
|
Revisiting Database object names, naming conventions for identifiers and some of the methods that you can use to rectify this - use column aliases, quoted identifiers and square braces. A small lesson in how haste makes waste and how haste sometimes reminds us of things we already know....
|
|
-
|
|
What TCP/IP port is my SQL Server instance listening on? Can I use SQL Server Management Studio or SQL Server Configuration Manager to find the port number used by SQL Server? Today's post helps database administrators and developers answer this question....
|
|
-
|
|
This is actually a spin-off from a Question of the Day, which appeared in SQLServerCentral (December 16, 2010). A brief History For those of you who have been around in the industry for more than a decade, the term Y2K carries mixed feelings. It was a very much hyped and very real problem, but wit......
|
|
-
|
|
It's time for a change. This website, BeyondRelational.com, is rolling out a new Blogs module with improved features, feedback and social opportunities. All 146 of my posts have been moved to the new location: http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx?tab=default. All future po......
|
|
-
|
|
Often, students and colleagues come up to me and enquire how do they get started learning about some of the newest technologies. They generally do not seem to have issues with getting the study materials (most common study materials are the many blogs on the Internet and MSDN documentation). The one......
|
|
-
|
|
In November 2011, I wrote a post titled SQL Server – Performance – Best Practice – Create Index Before or After a data insert?. The post dealt with answering the question - which method was better – whether to create an index before or after a bulk-insert? The post was essentially targeted to code t......
|
|
-
|
|
As you know, I recently completed a 10-part tutorial series on the SQL Server Management Studio (SSMS). As I finished writing the tutorial, I remembered that one of the issues most SQL Server developers encounter are the slow load times of the SSMS. Sometimes, SSMS is just not fast enough for a quic......
|
|
-
|
|
Recently at the office, we ended up discussing the BIT data type (http://msdn.microsoft.com/en-us/library/ms177603.aspx). While we all understand that BIT is supposed to represents a Boolean value, we were not quite convinced. Boolean values are two-state – they can only be TRUE or FALSE (or 1 and 0......
|
|
-
|
|
Ever since SQL Server 2005 introduced user-schema separation, schemas have received due importance. Most new designs isolate functionality within the same database via the use of schemas. With the growing use schemas, did you ever face a situation wherein you or one of the team members created a tab......
|
|
-
|
|
It is a well-known recommendation and best practice that the transaction log of any database must be on a drive different than the data files are on. This is especially useful to improve transaction log file performance, which manifests itself as a high value for the LOGBUFFER wait type. Refer Pinal......
|
|