News in the Category: SQL Subscribe to the rss of this category.

Total posts: 7630 | Sort by Views | Sort by Hits

SQL SERVER How to Fix Error 8134 Divide by Zero Error Encountered

Journey to SQL Authority with Pinal Dave, August 27, 2016
Views: 6 | Hits

Here is one of the most popular questions: How to overcome (Error 8134) Divide by Zero Error Encountered in SQL Server?First appeared on SQL SERVER – How to Fix Error 8134 Divide by Zero Error Encount...

Restore or Attach Database Without Log File SQL in Sixty Seconds #082

Journey to SQL Authority with Pinal Dave, August 26, 2016
Views: 111 | Hits 4

One of the most common question I get on blog is - how do I attach database without log file. I have previously blogged about it over here. I request you to read this blog post if you want a solution ...

Predicates With Subqueries

Simple Talk, August 25, 2016
Views: 57 | Hits 3

The ALL, SOME and ANY predicates aren't much used in SQL Server ,but they are there. You can use the Exists() predicate instead but the logic is more contorted and difficult to read at a glance. Set...

SQL Server for Linux

Simple Talk, August 25, 2016
Views: 65 | Hits 3

Although SQL Server for Linux removes the concern that adopting SQL Server forces you to also adopt the Windows platform, it could also provide a useful alternative platform, and a more obvious altern...

SQL SERVER Fix Error Cannot use the backup file because it was originally formatted with sector size 4096 and is now on a device with sector size 512

Journey to SQL Authority with Pinal Dave, August 25, 2016
Views: 81 | Hits 1

Here is a recent email which I received from Madhu. He is a beginner in the SQL Server and when he tried to take a backup from SSMS (SQL Server Management Studio), he got error related to backup file....

SQL SERVER Script level upgrade for database master failed because upgrade step upgrade_ucp_cmdw.sql

Journey to SQL Authority with Pinal Dave, August 24, 2016
Views: 107 | Hits 1

Recently once by my client contacted via Skype to know my thoughts about a cluster failover failure issue. They were having two nodes SQL Clustered instance and it was running fine of Node1. As soon a...

SQL SERVER Summer Sale and Monowheel Raffle

Journey to SQL Authority with Pinal Dave, August 23, 2016
Views: 126 | Hits 2

My good old friends from Devart keep exciting me with great news. As it became a tradition, the company treats its customers with tasty discounts on all its product range. But there's more each custo...

SQL SERVER Understanding Basic Memory Terms of Physical Memory and Virtual Memory

Journey to SQL Authority with Pinal Dave, August 22, 2016
Views: 119 | Hits 4

Recently I had been to an institute to talk about some database concepts to computer science students. Most of these academic engagements get me closer to young minds and this is an awesome way for me...

Does Dropping Primary Key Drop Non-Clustered Index on the Column? Interview Question of the Week #085

Journey to SQL Authority with Pinal Dave, August 21, 2016
Views: 142 | Hits

Question: When we drop primary key on the column, does it automatically drop a non-clustered index on the same column (if created)?Before we see answer of this question, I suggest you read following t...

SQL SERVER SSMS Error During Restore: No Backupset Selected to be Restored

Journey to SQL Authority with Pinal Dave, August 20, 2016
Views: 149 | Hits

There are various ways of learning in my current role. Along with client engagements, reading others blog, I also learn from comment/interaction of my own blog. One of my blog readers sent below email...

SQL SERVER Backup to URL Fails in Azure Resource Manager (ARM) Deployment Model with Error (400) Bad Request

Journey to SQL Authority with Pinal Dave, August 19, 2016
Views: 128 | Hits

During my previous consulting engagement, I learned something new with SQL Server feature called back up to the URL. Since it was not so clearly documented, I am sharing this with you. In this blog po...

SQL SERVER False Error Cannot bulk load because the file could not be opened. Operating system error code 5 (Access is denied.)

Journey to SQL Authority with Pinal Dave, August 18, 2016
Views: 107 | Hits

Yes, it's possible that SQL Server can raise false and misleading error. I was trying to do some pretty straight forward stuff import data from text file to SQL table using the BULK INSERT command of...

Database Sharding How to Identify a Shard Key?

Journey to SQL Authority with Pinal Dave, August 17, 2016
Views: 137 | Hits 5

I have written a number of posts in the past working on shared databases and the concepts around these can be read at Sharding or No Sharding of Database Working on my Weekend Project for the starter...

PowerShell SQL Server Paging of Memory Identification

Journey to SQL Authority with Pinal Dave, August 16, 2016
Views: 128 | Hits 1

In one of my recent consultation visits to a customer, there was deep performance related problems. They were unclear to what was happening and what was the actual problem. But these are some of the c...

SQL SERVER A Timeout (30000 milliseconds) was Reached While Waiting for a Transaction Response from the MSSQLSERVER

Journey to SQL Authority with Pinal Dave, August 15, 2016
Views: 141 | Hits 2

Recently I was contacted by a client who reported very strange error in the SQL Server machine. These consulting engagements sometimes get the best out of you when it comes to troubleshooting. They re...

How to Drop Clustered Index on Primary Key Column? Interview Question of the Week #084

Journey to SQL Authority with Pinal Dave, August 14, 2016
Views: 147 | Hits 1

Question: How to drop clustered index, which is created on primary key?Answer: If you thought the answer as simple as following script, you are wrong.DROP INDEX PK_Table1_Col1ON Table1GOFirst appeared...

SQL SERVER Installation Fails With Error A Constraint Violation Occurred

Journey to SQL Authority with Pinal Dave, August 13, 2016
Views: 135 | Hits

In my recent past, I have helped around 10 customers who have had similar problems while installing SQL Server Cluster on windows. So I thought it would be a nice idea to pen it down as a blog post so...

SQL SERVER Creating a Copy of Database in Azure SQL DB

Journey to SQL Authority with Pinal Dave, August 12, 2016
Views: 125 | Hits 1

Recently I was about to undertake an interesting assignment for one of my clients who pinged me for Performance Tuning exercise. Since this is something I have been doing full time in the past couple ...

Questions About Azure SQL Database You Were Too Shy to Ask

Simple Talk, August 11, 2016
Views: 146 | Hits 6

You've heard of Azure SQL Database, you've nodded wisely in discussions and you might even have tried it out on some sample data. However, you have some nagging basic questions that would seem slightl...

PostgreSQL Learn Online in a Single Day PostgreSQL Learning Path

Journey to SQL Authority with Pinal Dave, August 11, 2016
Views: 152 | Hits 2

PostgreSQL is considered to be one of the most advanced open source database. PostgreSQL is very easy to learn as well as it is very implemented and easy to implement. Along with SQL Server I have bee...

Formatting SQL Code Part the Second

Simple Talk, August 10, 2016
Views: 140 | Hits 10

When you're formatting SQL Code, your objective is to make the code as easy to read with understanding as is possible, in a way that errors stand out. The extra time it takes to write code in an acce...

Direct Query with Power BI

Simple Talk, August 10, 2016
Views: 125 | Hits 2

Power BI allows you to connect directly to the data just as if it were a standard connection, and modify and extend the data to support analytics. By using DirectQuery, you can build reports based on...

Master Data Management (MDM) Using SQL Server

Simple Talk, August 10, 2016
Views: 121 | Hits 4

So many of the problems that organisations have with their IT applications are due to the struggle with data, in the absence of overall organization-wide control and supervision of data and its progre...

Install SQL Server 2016 Sample Database WideWorldImporters SQL in Sixty Seconds #081

Journey to SQL Authority with Pinal Dave, August 10, 2016
Views: 143 | Hits 4

I have been a very loyal user to sample database AdventureWorks for a while, I really liked the overall database. However, as we know SQL Server releases, new features every year and along with the ne...

SQL SERVER How to Recover Truncated or Deleted Data When a Database Backup is or is not Available

Journey to SQL Authority with Pinal Dave, August 9, 2016
Views: 134 | Hits 4

Recovering lost data that was deleted or truncated can be fairly quick and easy, depending on the environment in which the database resides, recovery measures implemented before and after the data los...

Install SQL Server Management Studio 2016 SQL in Sixty Seconds #080

Journey to SQL Authority with Pinal Dave, August 8, 2016
Views: 119 | Hits 5

Earlier this week, I have published a blog post where I explained how to install SQL Server 2016. One of the most asked questions was Where is SQL Server Management Studio 2016? I totally understand w...

Does Dropping Clustered Index Drop Primary Key on the Same Column? Interview Question of the Week #083

Journey to SQL Authority with Pinal Dave, August 7, 2016
Views: 125 | Hits 1

Question: When we drop clustered index on the column, does it automatically drop primary key on the same column (if created)?First appeared on Does Dropping Clustered Index Drop Primary Key on the Sam...

SQL SERVER Error: 14258 Cannot perform this operation while SQLServerAgent is starting. Try again later

Journey to SQL Authority with Pinal Dave, August 6, 2016
Views: 140 | Hits

One of my clients asked assistance in fixing an interesting issue. They informed me that they are not able to run any job in SQL Agent. When they try to run the job manually, they are seeing below mes...

SQL SERVER Event 17058 initerrlog: Could not Open Error Log File

Journey to SQL Authority with Pinal Dave, August 5, 2016
Views: 115 | Hits

If you have ever interacted with me or taken my services, you would notice that I always ask for ERRORLOG in almost all of my contact with my client. Once of my friend contacted me and when I asked fo...

SQL SERVER DMVs to Detect Performance Problems in SQL Server Notes from the Field #135

Journey to SQL Authority with Pinal Dave, August 4, 2016
Views: 143 | Hits 5

[Notes from Pinal]: Performance tuning is a complex subject, and not everyone knows where to start and how to handle this complex subject. There are so many different areas for performance tuning for ...

SQL Complete Smart Code Completion and SQL Formatting

Journey to SQL Authority with Pinal Dave, August 3, 2016
Views: 132 | Hits 5

A week ago, I saw a notification about the release of dbForge SQL Complete 5.5. As a long-time user of this product, I have updated to the new version. A week later I decided to share my impressions o...

SQL Server Access Control: The Basics

Simple Talk, August 2, 2016
Views: 136 | Hits 4

SQL Server provides a number of settings for controlling access to data, metadata, and other SQL Server resources. For those who are new to SQL Server security or dont manage security routinely, confi...

SQL SERVER Setting Firewall Settings With Azure SQL Server VMs

Journey to SQL Authority with Pinal Dave, August 2, 2016
Views: 125 | Hits 1

Recently I had a session around using SQL Server on Azure and during this session one of the questions was to access the SQL Server in a Hybrid Setup. This is a typical scenario wherein the developer ...

An introduction to In-Memory OLTP Database Objects

Simple Talk, August 1, 2016
Views: 123 | Hits 5

If your number one wait type, by far, is io_latch, if you find yourself relying on table variables, if you’re collecting massive amounts of data in SQL Server through inserts, the chances are that you...

SQL SERVER Unable to Create Listener for AlwaysOn Availability Group in Azure via Template Deployment

Journey to SQL Authority with Pinal Dave, August 1, 2016
Views: 98 | Hits 1

Recently I was trying to help a customer who was deploying AlwaysOn Availability Group in Microsoft Azure via template deployment. The template was failing with below errorFirst appeared on SQL SERVER...

Does Dropping Primary Key Drop Clustered Index on the Same Column? Interview Question of the Week #082

Journey to SQL Authority with Pinal Dave, July 31, 2016
Views: 122 | Hits 3

Question: When we drop primary key on the column, does it automatically drop a clustered index on the same column (if created)?Answer: This is one of the most popular questions, whenever I ask this to...

Life Lessons Understanding Your Customer

Journey to SQL Authority with Pinal Dave, July 30, 2016
Views: 127 | Hits 2

A couple of weeks back, I wrote a blog around - Life Lessons Are There Rules for Interacting With Customers. This has been just to write out what I had in mind and how I approached a customer in gene...

SQL SERVER What is Deadlock Scheduler? How to Reproduce it?

Journey to SQL Authority with Pinal Dave, July 29, 2016
Views: 120 | Hits 2

If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler. First appeared on SQL SERVER – What is Deadlock Scheduler? How ...

SQL SERVER Becoming a More Effective DAX Developer with DAX Studio Notes from the Field #134

Journey to SQL Authority with Pinal Dave, July 28, 2016
Views: 105 | Hits

[Note from Pinal]: This is a new episode of Notes from the Field series. I personally have no problem accepting that I do not know many topics. One of the such topics is DAX Studio. I always wanted to...

SQL SERVER 2016 Learn Installation of SQL Server 2016 in 2 Minutes Video

Journey to SQL Authority with Pinal Dave, July 27, 2016
Views: 149 | Hits 2

Every time when new SQL Server version arrives, lots of people want to install it, however the biggest hesitance is the fear of unknown. Lots of people do not try out new software because they are wor...

SQL SERVER System Stored Procedures I Use to Get Started

Journey to SQL Authority with Pinal Dave, July 26, 2016
Views: 144 | Hits 6

Call me an old school or whatever there are certain things I believe in strongly. I have a working style and these in my opinion have evolved over years. I keep innovating myself as I learn on my way...

SQL SERVER Installation FeatureUpgradeMatrixCheck (SQL Server 2016 Feature Upgrade) setup rule failed

Journey to SQL Authority with Pinal Dave, July 25, 2016
Views: 163 | Hits 1

One of the best ways to learn problems faced by individuals and organizations is to look at the forums for these issues. Often I have visited MSDN forums and see if there are some hot or interesting i...

How to Find Outdated Statistics? Interview Question of the Week #081

Journey to SQL Authority with Pinal Dave, July 24, 2016
Views: 140 | Hits 2

Recently in one of the webcast, while I was presenting about statistics and performance tuning, I was asked by one of the attendees that if there is anyway to find out all the outdated statistics base...

SQL SERVER Network Servers List is Empty in SQL Server Management Studio

Journey to SQL Authority with Pinal Dave, July 23, 2016
Views: 159 | Hits 3

I have in numerous places told that the first tool that I often open when the computer boots up will be SQL Server Management Studio. I get intrigued whenever someone comes up with an error relating t...

Azure SQL Database How to choose the right service tier

Simple Talk, July 22, 2016
Views: 36 | Hits

So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Yo...

Formatting SQL Code Part the First

Simple Talk, July 22, 2016
Views: 37 | Hits 1

With the formatting of code, we sometimes do things because they've always been done that way, rather than making code easier to understand. Occasionally these habits get in the way of readability. J...

Azure SQL Database How to choose the right service tier

Simple Talk, July 22, 2016
Views: 141 | Hits 3

So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Yo...

SQL Server Statistics Basics

Simple Talk, July 22, 2016
Views: 129 | Hits 6

Distribution statistics are used by SQL Server's Query Optimiser to determine a good execution plan for your SQL query. You don't need to know about them to execute queries, but the better you underst...

SQL SERVER Install Error Could not Find the Database Engine Startup Handle

Journey to SQL Authority with Pinal Dave, July 22, 2016
Views: 154 | Hits

Note: There are multiple reason of above error and this blog shows just one of them. I am sure that this blog would give you guideline about what do to in case you see this error about install error. ...

Free DBA Tools for SQL Server Professionals Notes from the Field #133

Journey to SQL Authority with Pinal Dave, July 21, 2016
Views: 158 | Hits 10

[Note from Pinal]: This is a 133rd episode of Notes from the Field series. I know Mike for many years and Mike has always inspired me with his positive energy. I have always enjoyed spending time with...