There are many methods to store date values. One of them is Julian date. It is a seven digit number where first four is the year part and the next three digits are the number of days from Jan 01.
Interview Question of the Week #009 – Is GO T-SQL Statement?
I often get this question in the email – more frequently than I would like to get.
Question: “Is GO T-SQL statement?”
SQL SERVER – FIX: SQL Server Not Starting – Msg 864, Level 16, State 1- Buffer Pool Extension Feature
Recently I got an email from one of the student who attended my SQL Server 2014 Pluralsight Course from last year, he was trying to use Buffer Pool Extension feature and got into some unique trouble. Here is the email from him:
SQL SERVER – ReadOnly Databases and Notes Using Snapshots
This seems to be the third week that I am writing about ReadOnly databases, this blog is in continuation of last weeks notes. When I wrote the notes from last week, one of my blog reader said if it is possible to get the ReadOnly error without making the database into a ReadOnly database. This got me thinking and I couldn’t sleep that day. And a quick call to my friend to get some ideas – the answer was simple – using Snapshots.
Hey DBA – Protecting a Proactive Attitude – Notes from the Field #069
[Note from Pinal]: This is a 69th episode of Notes from the Field series. Mike Walsh is an amazing person to meet and know. I am fortunate to be his friend. Every single time I meet him, I learn something as a human. He is always looking for an opportunity…
Read MoreSQL SERVER – Storing Data in Hindi, Chinese, Gujarati and Tamil (or any other) Language in the Same Table
Long time ago, I have written a blog which talks about multi language support available with SQL Server. SQL SERVER – 2005 – Multiple Language Support I have been getting below questions on regular basics and it still baffles me: How do I pass Hindi parameters in SQL Server procedure…
Read More
SQL SERVER – Configure, Monitor and Restore Backups from Mobile & Web browser
So tell me if this is a fantasy or a reality about restore backups: You are on a beach, sipping on your cocktail and looking at the sea when you get a frantic call from your boss, “One of the junior DBAs has just deleted all of the data from a critical database”. You say “Hold on”, switch to a browser on your smartphone, go to your dashboard on SqlBak.com and click a Restore button on your latest transaction log backup. In a few seconds, you get back to your boss and say: “I have fixed it”. Your boss is stunned, thinking you are a magician and makes a note to give you a raise and a bonus while you continue enjoying the beach…
SQL SERVER – COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression
In earlier blogs on “Fundamentals of Columnstore Index”, I took a simple approach on taking a tour of how to create a simple Columnstore index. Having said that, SQL Server 2014 supports columnstore and columnstore archival compression for columnstore tables and indexes. Columnstore tables and indexes are always stored with…
Read More
Interview Question of the Week #008 – Write Scripts to Convert String to Title Case or Proper Case
Just received a question in an email asking questions about how to Convert String:
“I just got out of the interview and I was asked to write scripts to convert a string to Title Case. I was also asked to refer to the website over here to validate my answer after I complete writing script.
Do you think it is not fair to ask such questions in an interview?”
SQL SERVER – Script to Find Strings with Same Characters
One of my blog followers asked me if it is possible to check whether all the characters of a column value is same. For example if there are values like KKK and KKT, the value KKK should be the output as all characters are same. There is a method without…
Read More