|
|
-
JacobSebastian Liked 2 Years ago through Blogs
Today morning, as I was reading the morning newspaper and having a nice cup of tea, the following article grabbed my attention: Edition: Times Of India, Ahmedabad edition Date : July 04, 2011 Page :...
|
-
JacobSebastian Liked 2 Years ago through Just Learned
Many of us have been doing different 'unsupported' work-around options to clear history of server names from the SSMS connection dialog. The new version of SSMS released with Denali CTP 3 allows you to easily delete old entries right from the connection d
|
-
JacobSebastian Liked 2 Years ago through Puzzles
This challenge is to generate an HTML calendar based on the data stored in a table. The
concept is very similar to the calendar we generate for the Quiz Series.
|
-
JacobSebastian Liked 2 Years ago through Puzzles
An ETL application receives product and category information in a text file. The category
hierarchy is specified as a string. Your job is to read the hierarchy information and
generate a relational table (result set) representing the hierarchy of catego
|
-
JacobSebastian Liked 2 Years ago through Just Learned
Most of the technical documents at my workplace are stored in google docs. The main attraction is that several people can edit/view the documents and the changes one person makes is visible to all others in real time.
Just learned that Microsoft Word no
|
-
JacobSebastian Liked 2 Years ago through Just Learned
Just learned from Paul Randal's blog post that DBCC CHECKDB does not cause blocking. It used to cause blocking in SQL Server 7.0 and earlier versions, but never after that.
DBCC CHECKDB in SQL Server 2000 uses transaction log analysis to get a consisten
|
-
JacobSebastian Commented 2 Years ago through Just Learned
Agreed. The last two tips demonstrated are really cool. Many times we need to do calculations to find start and end date of a given period (week, month etc) and the logic demonstrated is worth noticing. It goes bad only when applied on a column....
|
-
JacobSebastian Commented 2 Years ago through Just Learned
Agreed. The last two tips demonstrated are really cool. Many times we need to do calculations to find start and end date of a given period (week, month etc) and the logic demonstrated is worth noticing. It goes bad only when applied on a column....
|
-
JacobSebastian Commented 2 Years ago through Just Learned
Agreed. The last two tips demonstrated are really cool. Many times we need to do calculations to find start and end date of a given period (week, month etc) and the logic demonstrated is worth noticing. It goes bad only when applied on a column....
|
|
|