mar.ko (9/2/2015)

---

I need to use the same SQL source code in more than one stored proc.

Is there a way to -include mysql.sql or something like that ?

How does everyone handle...

Capital Punishment

Steve Cornwell-278514 (9/2/2015)

---

It's a big shared environment with 9 other instances of SQL Server are running. Approximately 200 GB of physical memory remains unallocated at this time. No...

What else is running on this server apart from the SQL Server? Why such a meagre memory configuration if the server has 512Gb of RAM? Are you RDP'ing on to...

Munabhai (9/1/2015)

---

drop table #temp

CREATE TABLE #TEMP

(

date1 DATE,

date2 DATE

)

insert into #TEMP values

('2011-06-18','2011-06-29'),('2010-12-09','2010-12-15'),('2011-03-04','2011-03-16'),('2010-02-09','2010-07-08'),('2010-03-10','2010-03-31'),

('2010-03-31',null),('2014-08-01',null),(null,'2010-07-08'),('2010-07-08',null),(null,'2014-05-23'),

('2011-02-09','2011-02-02'),('2011-06-22','2011-06-14'),(null,null),(null,null)

SELECT date1, date2,

CASE

WHEN (ISNULL(date1, '1900-01-01') = '1900-01-01' AND ISNULL(date2, '1900-01-01') = '1900-01-01') THEN 0

WHEN ISNULL(date2, '1900-01-01')...

jharvey6 76850 (8/31/2015)

---

I have been tasksed to create a data table and stored procedure to extract a special formatted XML file that is an attachment with a standard XML envelope....

Ed Wagner (8/31/2015)

---

SQLRNNR (8/31/2015)

---

Brandie Tarvin (8/31/2015)

---

Ed Wagner (8/31/2015)

---

Sean Lange (8/31/2015)

---

Grant Fritchey (8/31/2015)

---

For the upgrade to 10, I think I'd suggest holding off a while. I'm seeing occasional errors: faulty_hardware_corrupted_page. From...

For fun, here is an alternative

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @STR_DATE VARCHAR(6) = '083115';

SELECT CONVERT(DATETIME,STUFF(STUFF(@STR_DATE,3,0,'/'),6,0,'/'),1);

Output

2015-08-31 00:00:00.000

sunnyepgc (8/31/2015)

---

Hi, Could any one help me to resolve the issue. We have around 5 SP’s which are inserting data into Table A,and these will run in parallel.From the temp...

balasach82 (8/30/2015)

---

Its a new Win 2008 R2 box with 128 GB ram. SQL is allocated about 4 GB (min) max (61 GB). Thsi configuratin is much higher than what we...

balasach82 (8/30/2015)

---

An Stored proc which was running in SQL 2008 for 6hrs, after upgrade to 2012 takes 12 to 13hrs to complete.

Inside the proc, an cursor is created and 300K...

alessandro.feltrin (8/29/2015)

---

[font="Arial"]

Hello. I need to implement a Lab environment and in order to do this i have installed a new Virtual Machine with the same configuration and Software releases.

I've performed...

Spent several days once debugging a system and the bug turned out tobe caused by nolock hints.

😎

Thank you for this interesting question Hugo.

😎

Slightly taken aback seeing the overall results though

Correct answers:6%

Incorrect answers:94%

The site is once again very slow, up to 90sec between clicks :sick: and images particularly slow!

😎

Quick test