Viewing 15 posts - 526 through 540 (of 1,246 total)
Maybe I am getting my terminology mixed up. The article mentions that replication between 2008 and 2016 is unsupported. This under the heading of "Items Deprecated in SQL Server...
----------------------------------------------------
September 12, 2016 at 4:44 pm
I keep things simple, if it is in sys.tables then it is a table even if it is not ordered. I can always use an ORDER BY clause to pull...
----------------------------------------------------
September 7, 2016 at 11:45 am
Thanks for the feedback. And I wont bog you down with questions, just that if you want to let us know the exact issues you encountered then we can certainly...
----------------------------------------------------
September 6, 2016 at 3:24 pm
(3) Design a package to transfer 10 files from FTP and store them to hard drive?
Done. Ohh was this a question? 😛
Did you have to draw this out on a...
----------------------------------------------------
September 2, 2016 at 2:12 pm
provide the serverpassword for FTP using a package config file.
I know this is the quickest and easiest way to go about it. You know that you are storing a...
----------------------------------------------------
September 2, 2016 at 2:01 pm
I also wonder if you may want in the future to know if when those actions occurred. In your current design you would need three new columns for the times...
----------------------------------------------------
September 2, 2016 at 1:05 pm
We are going to need your table definitions and a script to fill them with sample data. (Directly from the articles that you were linked to). I am not clear...
----------------------------------------------------
September 2, 2016 at 12:50 pm
SQL Server could hold everything in RAM. Yet the database objects need to be tagged as to what database they belong to. I look at it as temp tables and...
----------------------------------------------------
September 2, 2016 at 12:41 pm
Good stuff, thank you for taking the time to explain this.
----------------------------------------------------
August 31, 2016 at 11:09 pm
Diligentdba 46159 (8/31/2016)
----------------------------------------------------
August 31, 2016 at 6:29 pm
Odds ratio is better explained here since there is a more detailed example https://en.wikipedia.org/wiki/Odds_ratio
It makes better sense now, though I wouldn't call this simplistic necessarily.
the sql server world is...
----------------------------------------------------
August 31, 2016 at 12:31 pm
lemmae880 (8/29/2016)
CAN ANY ONE HELP PLEASE
TITLE: Web Service Task
------------------------------
Could not read the Web Services Description Language (WSDL) file. The input WSDL file is not valid. The following...
----------------------------------------------------
August 31, 2016 at 11:46 am
It seems to me that the odds ratio is equivalent to a percentage. n1/n2 only tells me how many of the bottom subgroup there are for each one of the...
----------------------------------------------------
August 31, 2016 at 11:17 am
This is why one must be very careful with the SELECT * approach. Since you will have to run a refresh of the view, I find it less potentially confusing...
----------------------------------------------------
August 30, 2016 at 2:17 pm
SteveD SQL (8/30/2016)
Thanks for your response, while my tables do have check and RI constraints I also use surrogate keys and therefore most of my data import type packages...
----------------------------------------------------
August 30, 2016 at 11:33 am
Viewing 15 posts - 526 through 540 (of 1,246 total)