spectra (12/11/2016)

---

Hi,

I have two files i.e .ldf and .mdf in my disk. As we know these are normally SQL Server database log and data files....

Can you post the full code for the stored procedure please?

😎

ptownbro (12/10/2016)

---

We have a new server and want to move the SSAS databases from the old server to the new one. I thought this could be done by detaching the...

Quick example of an inline calendar CTE, you should be able to adjust it to your requirements.

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @DateRanges TABLE

(

StartDate DATE,

EndDate DATE

)

INSERT INTO @DateRanges (StartDate,EndDate) VALUES ('2016-12-01','2016-12-01')--2016-12-01

INSERT INTO...

Try to keep it as simple as possible, not only is the logic more readable, it also helps the performance.

😎

SQLUSERMAN (12/10/2016)

---

Suppose I want to find customers in the customers table who are not in the US or the UK.

To me the query for the above requirements would be as...

In SQL, one cannot use this kind of a where clause, if using multiple values it will have to be a sub query

😎

where Sales.SalesTerritory.[Group] in (@Sales.SalesTerritory.[Group])

should be something like

where...

swarun999 (12/9/2016)

---

Hi I have a issue. When I am using this scrpit in SSRS its showing error.

select sales.SalesTerritory.TerritoryID , sales.SalesTerritory.Name , sales.SalesTerritory.CountryRegionCode,

sales.SalesTerritory.[Group] ,

sales.SalesTerritory.SalesYTD, year(sales.SalesTerritoryHistory.StartDate) as [Year]

from sales.SalesTerritory join...

savibp3 (12/9/2016)

---

I have 2 proc , calling one proc inside another. There are 2 parameters need to pass .When I call the main procedure and it takes parameter.There is considition...

ChrisM@Work (12/9/2016)

---

Eirikur Eiriksson (12/9/2016)

---

ChrisM@Work (12/9/2016)

---

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet...

ChrisM@Work (12/9/2016)

---

Brandie Tarvin (12/9/2016)

---

rodjkidd (12/9/2016)

---

ChrisM@Work (12/8/2016)

---

rodjkidd (12/7/2016)

---

Eirikur,

I'm about a 20 minute walk to the High Holborn Caffe 1882. Let me know if you still want to meet up today?

Chris, are...

avi7070 (12/9/2016)

---

Hi,

It would be better to schedule FULL, DIFF, and TLog backups for production server databases. As you are not using any not using any high availability technique.

For Point in...

Strongly suggest that you use Ola Hallengren's SQL Server Maintenance Solution[/url]

😎

moosamca (12/9/2016)

---

Hi All,

COuld you please help me to tune the below query. I have attached the query plan of this query. Its going ont he nested loop and its cost...

Start by removing the redundant tables which are cross joined in the from clause, not used in the query so why are they there?

😎

wtpart A1,

epmdocument A2,

epmbuildrule A3,

epmreferencelink...