We learn from mistakes and we improvise with experience. I couldn’t think of a better example than the one below for this. I have been watching many sessions by various speakers and found that many times they have struggled to get rid of Error 3702.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
[Note from Pinal]: This is a 83rd episode of Notes from the Field series. Maintenance of the database is very critical activity and I have always seen DBA taking it very seriously. There is a only one problem – there is no single solution or guidance for how to maintain the database.…
Read MoreSQL SERVER – Finding Out Identity Column Without Using Column Name
There is an interesting observation when querying the identity column of a table Let us create the following tables CREATE TABLE test1 ( id INT IDENTITY (1,1) ) GO CREATE TABLE test2 ( id INT ) Note that the table test1 has identity column and table test2 does not have…
Read MoreSQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server
I make a visit to the local user group whenever I get and keeping the community juices up and running for me. I get an opportunity to share some of the learnings and meet tons of new people. In our recent meetup at the SQLBangalore UG, I met a lot…
Read MoreSQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)
As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging. This is his initial email: Hi Pinal, Your blogs have been very helpful to me…
Read MoreInterview Question of the Week #022 – How to Get Started with Big Data?
Big data is one of the most popular subject in recent time and everybody wants to get started on this subject. During recent interviews there are plenty of the questions with related to Big Data. Here is the most popular question which I receive on this subject. Question: How to…
Read MoreSQL SERVER – Error Msg 511 using SQL Server Sparse columns
When I wrote the previous post around SQL SERVER – CREATE TABLE Failed Because Column ‘C1024′ in Table ‘myTable’ Exceeds the Maximum of 1024 Columns, I thought it was a simple concept. Lesser did I know that there can be something wrong. One of my blog reader said they were getting…
Read More