The script doesn't have errors as such but it would possibly error on either the table name or missing schema prefix, suggest you add the table schema and use the...

I have the suspicion that this may be down to cached connection/meta data in Excel, suggest you look into clearing those.

😎

You will have to do more detailed analysis of the problem, without further information there is no way one can even start to guess where the bottleneck might be.

😎

Hi and welcome to the forum. Here are two possible solutions, the first uses conventional aggregation and the second one uses the window function aggregation, the former seems to perform...

mmsheehan (12/29/2016)

---

We are seeing the following error on a few of our systems ... I've searched the internet, but cannot find the "exact" error. Any suggestions?

A fatal error occurred while...

SQLserver_learner (12/29/2016)

---

Thank you John.

Both the queries are working. but it is giving 2 rows instead 1 row for NULL values for column [MDDS01_PORTFO_D]. one row is having latest timestamp...

Simple row_number solution (didn't see John's fine solution before posting)

😎

USE TEEST;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.MMDDS01_PORTFO_LIST') IS NOT NULL DROP TABLE dbo.MMDDS01_PORTFO_LIST;

CREATE TABLE [dbo].[MMDDS01_PORTFO_LIST]

(

[MDDS01_UUI_D] ...

Snargables (12/28/2016)

---

i can remove them from the avail group then change to simple then shrink then add back to avail group however i'd rather not have to do that unless...

Are all databases in simple recovery or are any in full recovery? If any in full recovery, are all of those with regular log backups?

😎

Strongly suggest that you use...

Quick thought, it is a good practice to use HOLDLOCK with the MERGE statement to avoid race conditions, whether that's in an explicit transaction or not is not really relevant.

😎

Simply copy and paste from the document and then use the IFCodes...

Hi and welcome to the forum....

Quick question, are the rows identical or are you comparing individual columns/column combinations?

😎

Strongly suggest that you use...

SQLUSERMAN (12/25/2016)

---

Hi all,

Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary key column be less efficient than using an ID column of type integer...