Viewing 15 posts - 3,811 through 3,825 (of 9,244 total)
gautham.gn (1/3/2014)
I want to find those columns which are in main table but are not present in _dup table.
Try this
SELECTc.TABLE_SCHEMA
, c.TABLE_NAME
, c.COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS c
LEFT OUTER JOIN INFORMATION_SCHEMA.COLUMNS cd
ON c.TABLE_SCHEMA =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 4:12 am
arrjay (1/2/2014)
All 5 database instances are being used by the users.
sounds like you're hitting this from an Oracle terminology point, theyre different entirely.
Each instance will default to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 3:25 am
similar to HP Polyserve then by the sound of it.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 3:20 am
Ginga (12/31/2013)
We have a server that needs more memory but we've hit the 32GB limit imposed by Windows Server 2008 R2 Standard. We plan to perform an in place...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 3:14 am
WebTechie38 (1/2/2014)
I am trying to document the environment I am working at.
I want to document our clustered servers.
1) Server Name
2) Virtual Server Name
3) Primary node name
4) ...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:47 am
So you're replicating the database storage drives at the storage level, no HA on the Windows or SQL level, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:33 am
For more on moving database files in SQL Server see my guide at this link[/url], now to the issue at hand
ramana3327 (1/2/2014)
use test_copy
alter database test_copy
MODIFY FILE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:25 am
JimS-Indy (1/2/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 2:08 am
niver (1/2/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 1:04 am
darklight_arizona (1/2/2014)
You mean to say we put all the system databases (like master, msdb, temdb etc)
on a shared disk and these databases are common to both the nodes.
Active...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2014 at 12:56 am
Grant Fritchey (1/2/2014)
100% true. But, you probably wouldn't be asking about where to put storage if you had no choice in the matter.
Sure, about the only time is when migrating...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 7:07 am
Krishna1 (4/9/2013)
DECLARE @bc INT;
DECLARE @ec INT;
DECLARE @bfn VARCHAR(1000);
DECLARE @efn VARCHAR(10);
-- Get the name of the current default trace
SELECT @filename = CAST(value AS NVARCHAR(1000))
FROM ::fn_trace_getinfo(DEFAULT)
WHERE traceid = 1 AND...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 6:44 am
Follow this knowledge base article from MS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 6:24 am
JoshDBGuy (12/30/2013)
and need to replicate/mirror/copy/log ship to another server in the cloud.
First thing to do is to decide on which you will use sounds like you have thought about it...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 5:50 am
Grant Fritchey (1/2/2014)
If you want faster performance for the system databases, you might consider local storage.
Unless its an FCI then you are required to use shared storage not local
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 2, 2014 at 5:42 am
Viewing 15 posts - 3,811 through 3,825 (of 9,244 total)