bhaskar.thapa (7/20/2015)

---

Hi,

Currently i have set of queries which i run for data extraction and result pasted in Excel table so that my pivot table and Chart gets populated along...

Quick questions, what are the server's specs? What is the cost threshold for parallelism? What are the tempdb configurations? Can you post the execution plans? Any indices on the table?

😎

Edit:typo

Although I haven´t seen anything stating that the temporal tables are Enterprise only feature, it´s certainly starting to look like it is.

😎

kapil_kk (7/18/2015)

---

HI friends,

I was trying to create temporal table feature which gets introduced in SQL Server 2016 but I am getting this error while trying to create it;

Cannot enable compression...

Read

Peter19898 (7/17/2015)

---

Hi

One of our SQL servers ran out of disk space and we received an error stating that the transaction log file was full for one of our Sharepoint content...

Looks to me like a permission issue (the credentials used for running the package), was anything changed that could affect this. Seen similar in the passed where permissions to read...

darren-hong (7/17/2015)

---

Hi all,

I have the following attributes in this Table A.

1) Location_ID (int)

2) Serial_Number (nvarchar(Max))

3) KeyID (nvarchar(max)

4) Reference_Address (nvarchar(max)

5) SourceTime (datetime)

6) SourceValue (nvarchar)

I am trying to create 1000000 dummy records...

Lynn Pettis (7/16/2015)

---

Here is another way to accomplish the task with no need to create a sort column in a CTE.

SET NOCOUNT ON;

DECLARE @TEST_NULL_SORT TABLE (AREA VARCHAR(50) NOT NULL, CATEGORY...

Further on Gail's and Steve's replies, don't ponder on how before you can identify and quantify the potential problem. If there are only 10-20 inserts per second, each record would...

Bharatvip (7/15/2015)

---

We are building a new environment and have got a Sql Server with 32 GB memory, 32 core 2.00 GHZ CPU, a Sql 2012 installation. We have about 6...

Depends on few things but one aims as close...

Does not exist in SQL Server but a workaround could be adding a sort column

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TEST_NULL_SORT TABLE (AREA VARCHAR(50) NOT NULL, CATEGORY VARCHAR(50) NULL);

INSERT INTO...

Quick thought, normally I would script out A, do whatever modificarions needed and then run the scripts on B and full rebuild.

😎

Glad you made the right decision,...