Search:

Type: Posts; User: rdjabarov; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Hmmm...I thought you mentioned in your initial...

    Hmmm...I thought you mentioned in your initial post that you changed the owner after restore...



    Also, are you deliberately keeping the versions of the two boxes different?
  2. Post the contents of your script file.

    Post the contents of your script file.
  3. Note the current size of the log file. Make sure...

    Note the current size of the log file. Make sure you have a full backup, then perform trx log backup. Then, set the database to SIMPLE recovery mode to reset the virtual log size. If necessary -...
  4. Replies
    3
    Views
    696

    you can also reference the IP instead of the...

    you can also reference the IP instead of the name. Of course creating a HOST A record on your DNS server would have partially solved the issue, except you still need an FQDN, not just the NetBIOS...
  5. Instead of involving SQL Agent look into a...

    Instead of involving SQL Agent look into a startup stored procedure formed from your script:

    https://msdn.microsoft.com/en-us/library/ms181720.aspx
  6. Replies
    9
    Views
    1,641

    how big is the table you're comparing, and how...

    how big is the table you're comparing, and how big is the table you're comparing to? Make a copy of an excerpt from both, and I am sure someone (including myself) will write up a concept.
  7. Replies
    5
    Views
    563

    have you tried "create database...for attach"...

    have you tried "create database...for attach" already?
  8. Replies
    4
    Views
    949

    Yeah, the field names indicate something other...

    Yeah, the field names indicate something other than SQL. It will not run "as is" without correctly delimiting each identifier (both table names and column names). After that is done, you need to...
  9. Replies
    2
    Views
    570

    hmmmm...PSK instance is down...Have you tried to...

    hmmmm...PSK instance is down...Have you tried to connect using TCP?
  10. Replies
    1
    Views
    348

    select a.[Group], SummaryValue = case when exists...

    select a.[Group], SummaryValue = case when exists (select * from a_table a1 where a.[Group] = a1.[Group] and a1.Value != 0) then 1 else 0 end
    from a_table a group by a.[Group]
  11. why can't you do Column_1 * (10*Column_1) as...

    why can't you do
    Column_1 * (10*Column_1) as Column_6?
  12. Replies
    6
    Views
    1,113

    did you look at your "Missing Index" hint in the...

    did you look at your "Missing Index" hint in the query plan output?



    /*
    Missing Index Details from query.sqlplan
    The Query Processor estimates that implementing the following index could...
  13. Here's more: if exists (select * from...

    Here's more:



    if exists (select * from sys.databases d where d.compatibility_level = 110 and name='test') begin
    raiserror ('CompatibilityLevel is 110!!!', 0, 1)
    end else begin
    declare...
  14. This may be a clue as to why your resulting...

    This may be a clue as to why your resulting column ends up with ANSI_PADDING ON (BOL - since 2005 mind you):



    The following are criteria for type_name of an altered column:


    The...
  15. Replies
    5
    Views
    963

    select [This is FALSE] = cast('false' as bit),...

    select [This is FALSE] = cast('false' as bit), [...and this is TRUE] = cast('true' as bit), [while this is NULL] = cast(null as bit)
  16. Replies
    1
    Views
    409

    Just like almost any database should have a table...

    Just like almost any database should have a table with numbers (check with Itzik Ben Gan if in doubt), it would not be a bad idea to equip every database where "date/time" values are used for any...
  17. Replies
    3
    Views
    729

    and this has to run in prod real time? creating...

    and this has to run in prod real time? creating new tables from existing ones? Wonder who's the "architect" of this masterpiece is...
  18. Replies
    5
    Views
    1,182

    a. Actually, FULL or even BULKLOGGED is preferred...

    a. Actually, FULL or even BULKLOGGED is preferred when performance is of concern, because of additional overhead related to checkpoint process that is outside of configuration control when db is in...
  19. Do you have to do an actual xml update? The few...

    Do you have to do an actual xml update? The few times I dealt with xml in SQL, I ended up forming (or re-forming) the xml that I need outside of the table, and then doing the update to the xml...
  20. Replies
    7
    Views
    1,566

    ...and you don't need to purchase any client...

    ...and you don't need to purchase any client licenses for your 3client boxes.
  21. Replies
    1
    Views
    728

    You don't need WorkLoad and ShopWorkLoad, for...

    You don't need WorkLoad and ShopWorkLoad, for sure. Definitely don't use triggers. *ALL* operations within your database must be initiated by the front-end code calling stored procedures. The...
  22. Not sure if I'm sticking around this time either,...

    Not sure if I'm sticking around this time either, but - Thanks!
  23. (It's C# BTW) Well, the OP was talking about VS,...

    (It's C# BTW) Well, the OP was talking about VS, and instead of going through an open-ended solution with the GUI, a console app gives you a sense of completion relatively quickly :)
  24. 150? It's not as many as I've seen, but it is...

    150? It's not as many as I've seen, but it is definitely a prime candidate for a specific concern, - make sure to implement asynchronous!
  25. Reminder

    Create a console app that accepts parameters (args[]), and pass connection arguments, along with the name of the database you want to create. The app should have a connection object that allows you...
Results 1 to 25 of 28
Page 1 of 2 1 2