Viewing 15 posts - 3,421 through 3,435 (of 6,401 total)
You are right, you cant take the database from 2012 to 2005 as it will not reattach or restore.
Two options I can think of off the top of my head...
November 9, 2012 at 7:16 am
DECLARE @a SMALLINT
SELECT @a = cpu_count FROM sys.dm_os_sys_info
IF @a = 1
BEGIN
EXEC sp_configure 'min server memory (MB)',xxxxx
EXEC sp_configure 'max server memory (MB)',xxxxx
...
November 9, 2012 at 5:36 am
Somewhere up the north of England, Manchester prefered, London was just to tricky to get to this time around.
November 9, 2012 at 5:27 am
Jason-299789 (11/9/2012)
Eg.
SELECT distinct
pd.description
, convert(varchar(10),convert(datetime, pe.enc_timestamp, 103),103) enc_timestamp
, pd.icd9cm_code_id
, dsm.description
, pd.note
...
November 9, 2012 at 4:56 am
Does the following work for you?
SELECT
Desc1,
convert(varchar(10),convert(datetime, enc_timestamp, 103),103) as EncTimestamp,
icd9cm_code_id,
Desc2,
note
FROM
(
SELECT
DISTINCT
pd.description Desc1,
pe.enc_timestamp,
pd.icd9cm_code_id,
dsm.description Desc2,
pd.note
FROM
ngkbm_dxcode_to_category_ ndc
join
patient_diagnosis pd
ON
pd.icd9cm_code_id = ndc.txt_icd9cm_code_id
left join
ngkbm_categry_to_specialty_...
November 9, 2012 at 4:25 am
Its picking up the column alias instead of the actual column as the sorting object.
Add the pe. alias to the order by or change the column alias in the select...
November 9, 2012 at 4:13 am
Koen Verbeeck (11/9/2012)
Try changing the order by clause to
ORDER BY enc_timestamp DESC
+1
As your ordering by a VARCHAR, it orders it from left to right not by value as that is...
November 9, 2012 at 4:03 am
What post-migration steps have you carried out on the new server?
I am guessing you backed up and restored the 2005 database onto the 2008 server?
Did you run DBCC UPDATEUSAGE, rebuild...
November 9, 2012 at 3:56 am
Sorry forgot to add this one in on the definition of a table variable
http://msdn.microsoft.com/en-us/library/ms188927.aspx
COLLATE section
If not specified, the column is assigned either the collation of the user-defined data...
November 9, 2012 at 2:56 am
What are you classing as a CPU, a physical socket or a logical core?
November 9, 2012 at 2:16 am
You would have to create your own sort of logshipping which restores the logs with the continue_after_error clause, standard log shipping wants the DB to be consistant, so you if...
November 9, 2012 at 2:15 am
November 9, 2012 at 2:10 am
To get the physical number of CPU's in a box
SELECT
cpu_count / hyperthread_ratio AS PhysicalCPUs
FROM
sys.dm_os_sys_info
To get the number of logical CPU's in a...
November 9, 2012 at 2:07 am
You can give it the SSIS job step, as all it does is execute dtsexec behind the scenes it doesnt have any dependency on the SSIS service.
November 8, 2012 at 8:05 am
Viewing 15 posts - 3,421 through 3,435 (of 6,401 total)