qjt (1/10/2017)

---

My laptop with 8G memory installs SQL Server 2014 EXPRESS for 64bit. A workstation with 32G memory also installs SQL Server 2014 EXPRESS. Both computers have the same database,...

sqlbaby2 (1/10/2017)

---

Hi DBA,

I created a view 'vw_AnnualSales_2016' on DB A, and this view is querying data from multiple tables which stored in DB B. I've granted user to has read...

Gaurang-Patel (1/11/2017)

---

I have received a new server. The server has the following specification. It has 500 gig 7.2K RPM disk, SSD, NVME and 1.2 TB 10K RPM disk.

RAM is...

Just a quick thought on this, but I have to wonder how VoltDB handles floating-point math. As your fields are declared as "float" data types, one thing you...

Phil Parkin (1/3/2017)

---

I did not have to install anything special to get multiple taskbars showing in W10. Just right-click / Properties on the taskbar & then check the 'Show taskbar...

Jim-S (1/3/2017)

---

Phil Parkin (12/22/2016)

---

Jim-S (12/22/2016)

---

Unfortunately it is causing us some issues, we are using Microsofts ALM (kanban model) to deploy our stuff to test and live servers. We attach our...

jtrask (1/3/2017)

---

I have a table that stores EmployeeID, and Date. I want to create a report for 2016 that shows what the best month, by highest record count, for...

Phil Parkin (1/3/2017)

---

sgmunson (1/3/2017)

---

Phil Parkin (1/3/2017)

---

sgmunson (1/3/2017)

---

I have yet to play with that feature, and as I have multiple monitors, as well as Classic Shell installed and configured to have...

Phil Parkin (1/3/2017)

---

Thom A (1/3/2017)

---

Hmm, interesting. I could replicate the problem, but not with SSMS. Strangely it was Outlook 2016 that wanted my attention. SSMS was happy to plum away...

thbaig (1/3/2017)

---

I have 2 tables

1-Web_Orders

Reference_No int

Released int

Data :

Reference_No , Released

123 ,0

456,1

789,1

002,1

2-tblOptionalRefNo

Reference_No int

Data:

Reference_No

123

Table 2...

Phil Parkin (1/3/2017)

---

sgmunson (1/3/2017)

---

I have yet to play with that feature, and as I have multiple monitors, as well as Classic Shell installed and configured to have the task bar...

I'm wondering if perhaps you have a SQL Server version difference between your laptop and the server itself. I recently ran into some SQL 2012 SSIS packages...

I have yet to play with that feature, and as I have multiple monitors, as well as Classic Shell installed and configured to have the task bar appear on all...

Jeff Moden (1/2/2017)

---

Alan.B (1/2/2017)

---

sgmunson (1/2/2017)

---

Jeff Moden (12/28/2016)

---

IIRC, PARSENAME has an element length of NCHAR(128) as a limit on each part it returns and is heavily dependent on the consistent position...

spectra (1/2/2017)

---

when I run the folling script

I get error in SQL 2008 Message tab : Query completed with error

DECLARE @TableName as sysname

DECLARE @ColName as sysname

DECLARE @sql as...