BI_Dev (10/11/2016)

---

Hi,

Is it possible to block all users from querying a table while it's being refreshed (truncate/insert into) by a maintenance job? I'm not a DBA but would like...

Quick question, do you have a POC (Partition, Order, Covering) index to satisfy the row_number?

😎

As mentioned before, check the parentheses, here is a suggestion

😎

SELECT

bi.ref

,st.design

,bi.qtt

,bi.qtt2

,st.fornecedor

,st.epcult

...

This is well documented on BOL: Using XML Data Types

😎

rajemessage 14195 (10/11/2016)

---

hi,

i get xml in following formate

select cast('<?xml version="1.0" encoding="utf-8"?>

<test>d</test>' as xml)

this formate works in sqlserver but following is not working what should i do.

select...

Hi, we will need more information, can you elaborate further?

😎

You are very welcome.

😎

pnr8uk (10/10/2016)

---

Hi All

I have a strange problem here which I can't quite get to the bottom of.

I have a file path in my table which reads like this:

\\cc0dware01\BMF\RMS\REBATERATES-WORKING-2016ToEnd08-20160905180112.csv

I only want...

eandre360 (10/9/2016)

---

Thanks Eirikur. Unfortunately, I won't be able to hardcode my. Need to figure out a way to either...

Ramdas Baghel (10/9/2016)

---

Hello folks,

I was reviewing a execution plan which I found from procedure cache. I found all details except - How much time it took to complete query?

Is...

Who deleted the thread on stuffing overlapping intervals?

😎

Quick example, clean the string and stuff it with hyphens

😎

USE TEEST;

GO

SET NOCOUNT ON;

;WITH SAMPLE_DATA AS

(

SELECT SD_ID, SD_STR FROM

(

...

eandre360 (10/9/2016)

---

Hello,

First time poster on this forum. I've recently been thrown into the world of SQL server, so my experience is limited to the last month or so. I believe...

It isn't nice to have one guessing what the requirements are when trying to...

Any other additional...