Forum Replies Created

Viewing 15 posts - 436 through 450 (of 13,460 total)

  • RE: MCSA 2012/2014

    this page specifically says, for SQL 2012, no retirement for exams are planned at this time:
    http://blog.firebrandtraining.co.uk/2017/01/microsoft-exams-retiring-2017.html

    SQL Server

    As with SharePoint, we see only the planned retirement...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 9, 2017 at 8:39 am

    #1950102

  • RE: SSAS in AG

    you are correct.
    SSAS can participate in a Cluster with shared storage, and is Cluster Aware.
    but  the service does not  have the equivalent of Availability groups.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 7, 2017 at 10:05 am

    #1949976

  • RE: Simple/Easy Way To Test Stored Procedures And Functions

    don't test on production.
    best practice is to test on a Development copy of production,s o you have no chance of actually screwing up important data.
    never test on production.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 7, 2017 at 8:40 am

    #1949941

  • RE: Reading from a view intoa table is taking forever!

    yeah now that we see the actual execution plan, we can see the impact of the nested views; there's a couple of tables like [ins_smr] and [ins_mod] that are joined...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 5, 2017 at 11:05 am

    #1949538

  • RE: I need to hide columns based on a field value, which isn't working, What's the best way to accomplish this? Grouping, subreport, Multiple datasets, or something else?

    for me, your expression looks like the problem, but of course it depends on your data.
    =IIf(Fields!NotificationType.Value = "Discharge",False,True
    that is evaluated each row, right? so potentially some rows toggle...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 5, 2017 at 9:20 am

    #1949507

  • RE: Reading from a view intoa table is taking forever!

    I'd look at the indexing and SQL code in the view; it could be using non-Sargable WHERE statements or join criteria, inline scalar functions, or just not have any indexing...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 5, 2017 at 8:51 am

    #1949496

  • RE: Trigger for Auditing

    create a table with the same schema as the table you want to audit.
    add additional columns for capturing whodunnit information.
    then you just need a trigger to handle update...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 5, 2017 at 7:13 am

    #1949461

  • RE: Reading from a view intoa table is taking forever!

    somone already mentioned that the order by , when inserting into a table is an extra cost with no benefit;(a table has no implicit order...you have to use an order...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 5, 2017 at 6:19 am

    #1949443

  • RE: Running total for previous 7 values where there is a 1

    here's your data setup with proper data types. your monthYr MUST BE a date datatype in order to get the proper order. you don't want the data to order in...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 3, 2017 at 7:24 am

    #1949131

  • RE: Download SQL patch Info

    Nice job Theo;
    I had created a procedure to check the current patch version,all available patch version, and the suggested Service pack version, but it used an internally contained CTE full of...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 3, 2017 at 6:37 am

    #1949119

  • RE: Replicate process from excel to sql

    what you want is a case statement to pick one column or the other base don the value.
    here's a complete working example based on what you posted. see how...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2017 at 8:09 pm

    #1949091

  • RE: SSIS Error When Executing Package in SSMS

    look specifically at the path in that Package.ConnectionManagers[StaffExport], 
    is it using a mapped drive, and not a unc path? ie the path should be \\servername\sharename\filename.txt, and not the T:\sharename\filename.txt
    mapped...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2017 at 4:55 pm

    #1949084

  • RE: De-Identification of PHI Data

    I have a DBA_Utilities database that I keep tables  in place for randomization. So for example i have a MovieStars database that is a cross join of Real Movie Starts...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2017 at 2:41 pm

    #1949081

  • RE: Issue with remotely connecting to SSAS Tabular via non-domain machine

    Analysis server allows windows connections only, you are correct.
    i those situations, we've added consultants to have a domain name on our network, and they connect via citrix to establish...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2017 at 5:07 am

    #1949040

  • RE: Stripping RTF from a text field

    I've done this with a Common Language Runtime (CLR)that was unsafe(due to windows.forms) so i could create an RTF object and get the MyObject.Text from it.
    if you google, you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    June 30, 2017 at 1:32 pm

    #1949000

Viewing 15 posts - 436 through 450 (of 13,460 total)