Viewing 15 posts - 391 through 405 (of 1,243 total)
mugilanoracle (11/29/2016)
please tell me how to export sql server single table into multiple excel sheets in single Excel file using SSIS package.(ex-have region column in source table and have to...
----------------------------------------------------
November 30, 2016 at 10:25 am
Ed Wagner (11/30/2016)
Sean Lange (11/30/2016)
Do be careful using this procedure in a production environment. It will sometimes skip databases. http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspxHere is another great article on the topic. https://spaghettidba.com/2011/09/09/a-better-sp_msforeachdb/%5B/url%5D
Yes it does....
----------------------------------------------------
November 30, 2016 at 10:12 am
To answer your third question that would depend on the isolation level of the transaction. You can override the databases default isolation level with something like
set transaction isolation level read...
----------------------------------------------------
November 25, 2016 at 3:07 pm
. So account name of 'EEERT0450' is unique and will be on source and DW. So when I populate the DW, the process would check if that account already exists...
----------------------------------------------------
November 25, 2016 at 12:11 pm
sipas (11/24/2016)
Actually it doesn't even work for this year.
SELECT DATEPART(DAYOFYEAR, SYSDATETIME()); gives 329
SELECT DATEDIFF( DAY, '20160101', SYSDATETIME()); gives 328
Happy Thanksgiving to all in the...
----------------------------------------------------
November 25, 2016 at 9:29 am
Jeff Moden (11/22/2016)
Phil Parkin (11/21/2016)
Jeff Moden (11/21/2016)
Phil Parkin (11/21/2016)
Jeff Moden (11/21/2016)
Why not just use EXCEPT?
EXCEPT on a 2-million-row resultset is tidier than a column-by-column comparison, but still not to be...
----------------------------------------------------
November 23, 2016 at 10:58 am
Here too is a resource that can help you get started with graphical execution plans : https://www.mssqltips.com/sqlservertip/1873/how-to-read-sql-server-graphical-query-execution-plans/
----------------------------------------------------
November 21, 2016 at 1:40 pm
The MAX(rowCreatedDT) is only scanning the table once!
There is a button in your SSMS window that displays "include actual execution plan" when you hover over it. You push this button...
----------------------------------------------------
November 21, 2016 at 11:49 am
Upon further inspection, do you still need the following in the fact table: CounterpartyAccountKey and GenevaAccountKey? I would think these are being replaced with the sourceKey field.
----------------------------------------------------
November 21, 2016 at 11:28 am
Yes. That appears like a straight forward star schema. One note though is that I would be consistent with the namings. If a column is named sourceKey in the fact...
----------------------------------------------------
November 21, 2016 at 11:22 am
Interesting that SMALLINT will implicitly convert to INT , but INT wont implicitly convert to BIGINT. Is this the case also with a .NET language like C#?
----------------------------------------------------
November 18, 2016 at 4:21 pm
Eric M Russell (11/17/2016)
In terms of the Kimball methodology of star-schema modeling, I believe this would be an example of a "role playing dimension".
From what I understand I dont think...
----------------------------------------------------
November 17, 2016 at 1:42 pm
Jeff Moden (11/16/2016)
IMHO, cleaner code if you take the shortcut.
SELECT mychar FROM mydata WHERE mychar LIKE '[[]%'
That's how I went about doing it and then had to take a closer...
----------------------------------------------------
November 17, 2016 at 12:00 pm
kevin.obrien 66193 (11/16/2016)
The question to the OP is ... are CounterpartyAccountKey and GenevaAccountKey mutualy exclusive? It appears to me from the reading that they may very well be (normally a...
----------------------------------------------------
November 17, 2016 at 11:42 am
Jeff Moden (11/16/2016)
tnnelzo (6/20/2013)
Everyday i run a querry in sqlserver 2008 to get a report to sent to my boss, but i want to automate this, so that the...
----------------------------------------------------
November 17, 2016 at 11:27 am
Viewing 15 posts - 391 through 405 (of 1,243 total)