|
|
-
|
|
Almost every product comes with a set of predefined system default data. There are very few product teams who use row constructors (introduced in SQL Server 2008) to populate their default data. What these teams fail to realize is that many a times, the conventional approach may have a negative impact on the time it takes to insert the data and also reduces the overall efficiency of the entire data load operation....
|
|
-
|
|
Returning Result sets is perhaps one of the most common methods used by development teams to debug databse triggers. However, returning result sets from triggers is already marked as a deprecated feature. DBAs can use the "disallow results from triggers" switch to begin educating teams to start moving away from this technique....
|
|
-
|
|
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......
|
|
-
|
|
The Merriam-Webster dictionary describes a book (http://www.merriam-webster.com/dictionary/book) as “something that yields knowledge or understanding” and that it is the source of the “the total available knowledge ......
|
|
-
|
|
For those of you who visit BeyondRelational regularly, you would have noticed that the web-site now has a new feature called “Ask”. The feature is a “personal forum” and allows you to approach one of the SQL Server experts associated with BeyondRelational directly with your queries. It facilitates a......
|
|
-
|
|
As mentioned in my previous post, I am currently developing a series of brief articles on the many underappreciated features of Microsoft SQL Server as received from the community as a response to Andy Warren’s SQLServerCentral.com’s editorial (http://www.sqlservercentral.com/articles/Editorial/7178......
|
|
-
|
|
It’s New Year’s Eve, and I am spending some nice family time by taking a holiday from work. However, it is not possible for me to forget the nice memories that the SQL Server community has given me. As we wind up the year 2010, I would like to express my sincere thanks to the entire SQL Server Comm......
|
|
-
|
|
Forgetting the "sa" login is an issue frequently seen in development & QA environments. Generally the Windows login works, but in some cases the IT team who installed the server may have forgotten to add someone to the sysadmin role. This post provides a proactive recommendation and link to a workaround....
|
|
-
|
|
When working on development projects, one may need to restart servers and/or workstations often. When working from remote locations or on virtual machines hosted on the network, this often becomes a challenge. Today, I will show how to shutdown or restart a local or remote machine via the command prompt....
|
|
-
|
|
ISV Vendors may supply a copy of their data files instead of a full database backup/scripts. Attempting to attach the database requires the use of CREATE DATABASE...ATTACH_REBUILD_LOG option. Re-creating the log file resets the recovery model of the database to SIMPLE. In this post, we attempt to explore why the recovery model is reset....
|
|