Ekkert mal

😎

You are welcome

Yees

😎

Quick suggestion

😎

USE TEEST;

GO

SET NOCOUNT ON;

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

CREATE TABLE [dbo].[Test](

[PK] [int] IDENTITY(1,1) NOT NULL,

[COLUMN1] [nvarchar](50) NOT NULL,

[COLUMN2] [nchar](10) NULL,

[COLUMN3] [nchar](10) NULL,

[COLUMN4] [nchar](10) NULL,

CONSTRAINT [PK_Test] PRIMARY...

torfi (7/13/2016)

---

Thanks for the advise put it didn't change anything. Now I created the index like this:

CREATE FULLTEXT INDEX ON MalBokunSkyrsla

( Skjalid TYPE COLUMN Filextension Language 1039) KEY...

Quick suggestion towards a SQL Server 2008 solution, which is fine on smaller sets but may need to be improved for large sets. If you are on SQL Server 2012...

This is wrong, NVARCHAR and VARCHAR will hold RTF files just...

Don't worry about removing it;-)

😎

Suggest you look into colour coding the connections in SSMS and paying attention...

peden (7/12/2016)

---

I have a requirement to display a "banner" with a warning message every time somebody "logs on to the database". I looked into possibly implementing a logon trigger,...

sqld-_-ba (7/12/2016)

---

Our production server (VM + SAN) has 32 GB of RAM, the database size is ~80GB. The application uses TempDB heavily - disk is hit ~100 MBps both reads...

Quick question, why are you using IMAGE data type and not NVARCHAR?

😎

torfi (7/12/2016)

---

I´m trying to create FullText Index on Image field witch contains text in rich text format. I´m from Iceland and we use several characters based on our language like...

You are very welcome.

😎

These changes have been slightly annoying but looks like they are slightly improving with each release, make certain you have the latest release of SSMS.

One particularly annoying thing was...

Quick though, NUMA node 2 only has 4 cores, possibly that should be your maxdop limit.

Depending on the type of workload I normally set the Cost Threshold for Parallelism...

If I understood correctly this could be a solution

😎

Foreign Sales X:=CALCULATE

( SUM(Sales[SalesAmount])

,ALL(Sales)

,FILTER(ALL('Market'),'Market'[Market]<>"Ireland")

)

Domestic Sales X:=CALCULATE

( SUM(Sales[SalesAmount])

,ALL(Sales)

,FILTER(ALL('Market'),'Market'[Market] = "Ireland")

)