Viewing 15 posts - 7,591 through 7,605 (of 13,876 total)
SQL!$@w$0ME (2/4/2016)
Could you please give some guidance on selecting hardware for a new DB server. This will be a new Operational Data Store setup. Expecting moderate ETL load (SSIS...
February 4, 2016 at 1:16 pm
Michael L John (2/4/2016)
Grumpy DBA (2/4/2016)
Michael L John (2/4/2016)
GilaMonster (2/4/2016)
jasona.work (2/4/2016)
February 4, 2016 at 12:32 pm
jasona.work (2/4/2016)
Luis Cazares (2/4/2016)
jasona.work (2/4/2016)
February 4, 2016 at 11:10 am
For each combination of machine/instance?
February 4, 2016 at 9:28 am
kavithaje (2/4/2016)
Sorry i did not understand clearly.Can you please give me some real example with the below query?
Thanks in advance.
Without knowing your table structures, the examples provided are as real...
February 4, 2016 at 8:47 am
Grant Fritchey (2/4/2016)
Grumpy DBA (2/4/2016)
February 4, 2016 at 8:10 am
John Mitchell-245523 (2/4/2016)
WITH Combined AS (SELECT Timestampcol, <other columns>, 'Table1' AS TableName
FROM Table1
UNION ALL
SELECT Timestampcol, <other columns>, 'Table2'
FROM Table2
)
SELECT Timestampcol, <other columns>, TableName
FROM Combined
John
I think you might need to extend...
February 4, 2016 at 8:07 am
Edvard Korsbæk (2/4/2016)
checked on the DB, which was used by the customer - it had level 110.
Next question is of cause, what...
February 4, 2016 at 6:30 am
Orlando Colamatteo (2/3/2016)
removed silly post...
Your own, presumably? 🙂
February 4, 2016 at 6:15 am
You seem to have found the correct answer, using the wrong technique 🙂
Different versions of SQL Server support different compatibility levels (see here).
Within a SQL Server instance, databases can have...
February 4, 2016 at 6:12 am
Have a look at TFS Power Tools.
You'll need to select the correct version for your environment. Once you've done that, you'll get a certain amount of TFS functionality available to...
February 4, 2016 at 6:06 am
Orlando Colamatteo (2/3/2016)
SQL_Surfer (2/2/2016)
February 3, 2016 at 10:54 am
Dave R (UK) (2/3/2016)
Currently not running 2012 so not an option 🙁Really frustrated as the solution works with the one exception of multiple lines in configuration table
OK. Then you are...
February 3, 2016 at 10:20 am
I just had another idea, which may or may not work in practice.
Create a 'master' package. This package searches a specific local folder and executes any packages it finds there.
Deploy...
February 3, 2016 at 10:18 am
SQL_Surfer (2/2/2016)
February 3, 2016 at 10:13 am
Viewing 15 posts - 7,591 through 7,605 (of 13,876 total)