Viewing 15 posts - 3,301 through 3,315 (of 11,678 total)
Megha P (4/10/2014)
Hello,Is it good to pass 70-433 now or should go for SQL 2012 developer certification?
Is 70-433 certification is valuable ?
Thanks,
Megha
That is a 2008 exam, which have expired...
April 10, 2014 at 12:36 am
Benki Chendu (4/9/2014)
Please select the following one - SQLServer2008R2_SP2_CU10_2908087_10_50_4297_x64
Seems obvious...
April 9, 2014 at 6:59 am
Why is there SSMS running on the production server?
April 9, 2014 at 6:53 am
Oblivion (4/9/2014)
Koen Verbeeck (4/9/2014)
(just...
April 9, 2014 at 6:14 am
You cannot just have less columns on a row then on another row.
Formatting output is better done with a front-end application, like SSRS.
April 9, 2014 at 3:41 am
Another side effect from SSMS is that it has to display all the rows in the result set. It might do it not so efficiently as SSRS.
(just a wild guess...
April 9, 2014 at 3:40 am
Sorry for the late reply, I have been busy.
Here is how I would solve it using TSQL:
-- create temp table
CREATE TABLE #viewReportMonitorCounterLog
([Machine] VARCHAR(10) NOT NULL
,[Counter Instance] VARCHAR(10) NOT NULL
,[Counter Object]...
April 9, 2014 at 1:59 am
Interesting question.
Always nice to see how Microsoft differs from other vendors (or how other vendors differ from Microsoft :-D) when it comes to terminating a simple line.
Always nice when you...
April 8, 2014 at 11:51 pm
rocky_498 (4/4/2014)
Need Help,I want to know what is the best way to deal this kinda Problem or approach.
I am creating almost 30 SSIS Packages, some of them...
April 8, 2014 at 12:31 pm
You could make create a link to the SSRS webserive wherein you supply the parameters and ask for the report in Excel format.
April 8, 2014 at 12:29 pm
I was rereading your original question, and I need some more info.
You said first you would like to have a count of how many machines have a value over 80%....
April 8, 2014 at 2:33 am
If you want to calculate aggregates in your query, you need to use a GROUP BY clause.
April 8, 2014 at 1:04 am
I'm not sure what you mean?
When you open up the package using VS 2012, you can see the different tasks. Some of them can contain SQL code.
April 7, 2014 at 2:58 pm
Viewing 15 posts - 3,301 through 3,315 (of 11,678 total)