Forum Replies Created

Viewing 15 posts - 1,891 through 1,905 (of 13,460 total)

  • RE: sql 2012 sharepoint instance slow to startup

    also how many VLF's are there?

    run DBCC LOGINFO on your Sharepoint database; you might need to reduce them.

    http://blogs.msdn.com/b/saponsqlserver/archive/2012/02/22/too-many-virtual-log-files-vlfs-can-cause-slow-database-recovery.aspx

    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!

    March 16, 2015 at 8:03 am

    #1784256

  • RE: Using powershell in tsql scripts

    kevaburg (3/16/2015)

    roger.price-1150775 (3/16/2015)

    Not seen SQL call Powershell but seen lots of powershell scripts calling SQL.

    Why are you renaming the files ?

    If it's to ensure a file is only processed once...

    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!

    March 16, 2015 at 6:30 am

    #1784232

  • RE: Is there anyway to use a People Distribution List with DBMail?

    as far as i know sp_send_DbMail requires email addresses int he correct format; it will not work with an operator name.

    all my SQLAgent my operators point to sqlAlerts@mydomain.com, which is...

    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!

    March 13, 2015 at 8:15 am

    #1783897

  • RE: Is there anyway to use a People Distribution List with DBMail?

    i beleive groups are a function of the mails erver, which generates individual copies of the email to people assinged tot eh group that the smtp alias points to;

    i know...

    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!

    March 13, 2015 at 7:51 am

    #1783880

  • RE: OR condition cancels AND condition

    also

    b.field1 LIKE 'ABC'

    is exactly the same as

    b.field1 = 'ABC'

    maybe you meant

    b.field1 LIKE 'ABC%' --starts with

    or

    b.field1 LIKE '%ABC%' --contains

    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!

    March 13, 2015 at 7:46 am

    #1783876

  • RE: OR condition cancels AND condition

    my knee jerk reaction would be to handle nulls for inequalities and exists, like this...

    does this get expected data with this change?

    WHERE

    b.field1 LIKE 'ABC'

    AND b.field2 BETWEEN GETDATE() -...

    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!

    March 13, 2015 at 7:44 am

    #1783870

  • RE: OR condition cancels AND condition

    do any of those fields have nulls in them?

    i think the "not in" portions can doink things up, right?

    OR {NULL} NOT IN ('1', '2', '7', 'B')

    ...

    OR {NULL}NOT IN ('CO','LT','B7')

    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!

    March 13, 2015 at 7:36 am

    #1783863

  • RE: weird login failure user name

    that string is the base64 conversion of some string or value; i recongnize the format and the double equal signs at the end.

    i tried running it through an online decoder...

    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!

    March 12, 2015 at 3:37 pm

    #1783734

  • RE: De-identification of Fields

    i don't know how others do it, but i have a few tables i use for replacements;a table with random values and numbers, another with ANSI colors, another with...

    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!

    March 12, 2015 at 11:57 am

    #1783682

  • RE: How to find which oracle client is being used by SSRS Reports

    i think you just have to open each datasource in the web client and review it to see if it is using ORAOLEDB.Oracle, or ORAOLEDB.Oracle.1 right? how many unique...

    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!

    March 12, 2015 at 7:28 am

    #1783563

  • RE: How to find which oracle client is being used by SSRS Reports

    this gives you the name of the report + name of the shared data source;

    if your reports have embedded data sources, i think you have to open each report.

    from there,...

    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!

    March 12, 2015 at 7:03 am

    #1783555

  • RE: Logic in a default constraint?

    Khades i tried with a user defined function as the default as wlel, doesn't work;

    i think you're stuck with adding an trigger for insert in order to get your default...

    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!

    March 11, 2015 at 11:53 am

    #1783408

  • RE: Generating Word reports programmatically using SQL Server Reporting Services 2012 with T-SQL(Stored Procedure)

    there is no ability to directly render as any format (ie $renderAsWORD) from within SQL server; those functionalite are all possible with an exdtrnal resource.

    you can do html, fixed...

    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!

    March 11, 2015 at 10:09 am

    #1783366

  • RE: Generating Word reports programmatically using SQL Server Reporting Services 2012 with T-SQL(Stored Procedure)

    do you mean dynamically select a query and result set, and use SSRS to export it to doc/docX? if that's the question, i don't believe you can. i'm awful sure...

    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!

    March 11, 2015 at 9:05 am

    #1783324

  • RE: master db deleted

    if the service is running, it's not possible to delete the master database either accidentally or on purpose; it has a file lock on it by the SQL Service.

    if the...

    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!

    March 11, 2015 at 6:22 am

    #1783243

Viewing 15 posts - 1,891 through 1,905 (of 13,460 total)