Step by Step Merge transformation control in SSIS TIP #122
In the Series of Zero to hero in SSIS this is another post. In this post we are going to...
2015-12-13
872 reads
In the Series of Zero to hero in SSIS this is another post. In this post we are going to...
2015-12-13
872 reads
SELECT DISTINCT s.Netbios_Name0 AS ComputerName,
s.Operating_System_Name_and0 AS OSName,
pr.Name0 AS ProcessorTypeSpeed,
pr.Manufacturer0 Manufacturer,
pr.NumberOfCores0 Cores,
pr.NumberOfLogicalProcessors0 LgicalProcessorCount,
case when pr.DataWidth0=64 then '64 bit'else'32 bit' end DataWidth,
m.TotalPhysicalMemory0/1024.00 AS MemoryMB,
GS1.TotalVirtualMemorySize0 VirtualMemory,
GS1.TotalVisibleMemorySize0 VisibleMemory,
ip.IPAddress0,
T1.COL AS TotalDriveSize,
LastBootUpTime0,
DATEDIFF(Day,GS1.LastBootUpTime0, GETDATE()) AS [Days since last boot]
FROM v_R_System_Valid s
INNER JOIN v_GS_PROCESSOR pr ON s.ResourceID = pr.ResourceID
INNER JOIN v_GS_COMPUTER_SYSTEM gs ON s.ResourceID = gs.ResourceID
INNER JOIN v_GS_NETWORK_ADAPTER ON s.ResourceID = v_GS_NETWORK_ADAPTER.ResourceID
INNER JOIN v_GS_X86_PC_MEMORY m ON s.ResourceID = m.ResourceID
INNER JOIN v_GS_NETWORK_ADAPTER_CONFIGURATION ip ON s.ResourceID = ip.ResourceID
-- INNER JOIN v_GS_LOGICAL_DISK AS ld ON s.ResourceID = ld.ResourceID
INNER JOIN
( SELECT RESOURCENAME,
col
FROM
(
SELECT DISTINCT TAB.Netbios_Name0 RESOURCENAME,
(
SELECT COL.deviceid0 +' '+ cast(COL.Size0/1024.00 AS varchar(20))+' '
FROM v_GS_LOGICAL_DISK COL
WHERE
COL.ResourceID = TAB.ResourceID AND COL.DriveType0=3
FOR XML PATH ('')
) COL
FROM v_R_System_Valid TAB
)T
where T.COL is NOT NULL
) T1 on T1.RESOURCENAME=s.Netbios_Name0
INNER JOIN V_GS_OPERATING_SYSTEM GS1 on GS1.ResourceID=s.ResourceID
WHERE
s.Operating_System_Name_and0 LIKE '%Windows NT Server%'
AND
ip.IPAddress0 IS NOT NULL AND ip.DefaultIPGateway0 IS NOT NULL
2015-12-11
658 reads
I ran across this site after reading a post from Jeremiah Peschka. It’s an interesting idea, and since I’m trying...
2015-12-18 (first published: 2015-12-11)
2,073 reads
Upcoming this Saturday 12/12/2015, SQL Saturday #465, taking place in the more modest Providence, Rhode Island venue, comes a great...
2015-12-11
1,318 reads
Earlier this week, the Database Strategy Team at my company was contacted about queries that were failing on one specific...
2015-12-10
1,610 reads
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
799 reads
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a lot of boiler plate stuff and offers re-writes for...
2015-12-10
18 reads
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
43 reads
I love writing c# code using visual studio and resharper, it is a really nice experience and resharper does a...
2015-12-10
41 reads
"where ISNULL(column, 'DontMatch') = 'Match'" - is kind of a bad thing to do in SQL as it means that any index...
2015-12-10
617 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers