Forum Replies Created

Viewing 15 posts - 181 through 195 (of 1,409 total)

  • RE: SQL Backup running long

    What is logged in the SQL Error log for both (and previous) backup runs? Look for something similar like "BACKUP DATABASE successfully processed 3824 pages in 0.376 seconds (79.440 MB/sec)."...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 4:07 am

    #1908543

  • RE: SQL Backup running long

    In general the I/O is the limiting factor with backup operations. Does the size of the backup file differs much between the last and the previous one? Did you specify...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 3:38 am

    #1908541

  • RE: Table Partitioning - Data column

    Can you show us the PARTION FUNCTION and the PARTION SCHEME (preferable by posting the DDL statements)? Without the definitions it is not possible for us to help you with...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 2:19 am

    #1908523

  • RE: Always On log file Full

    The main question is: what were the actions executed on the database during the growth of the LOG file? Active transactions prevent a log-backup from releasing space inside the LOG...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 2:12 am

    #1908519

  • RE: Delete massive records and still can't shrink db

    Does the database consists of multiple files and/or multiple filegroups? When you want to shrink databasefiles using the GUI it will default show only the first datafile of the PRIMARY...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 1:49 am

    #1908517

  • RE: Query to Dynamically Sum Sales Amounts By Month, Quarter, or Year

    Are you able to modify the [tblMonth] to a more general calendar table (like this sample[/url])? That will allow you to join the table and use it as filter on...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 1:32 am

    #1908516

  • RE: Sql Server Agent Profile Error

    Don't forget to look at the "Notifications" defined in the properties of each jobstep. Besides using the profile (by calling the sp_send_dbmail) through code, it could also be defined in...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 25, 2016 at 1:07 am

    #1908511

  • RE: Rearrange Display 3 id per row(6 rows 3 columns to 2 rows 9 columns)

    With NTILE you are able to split the selection in groups of three. With a CASE statement on this NTILE column you can move the specific rows to columns. The...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 8:34 am

    #1908384

  • RE: Different database collation

    I guess the different results are because the [tempdb] is always using the collations as set at instance level. So as soon as the queryplan decides to use the [tempdb]...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 8:06 am

    #1908371

  • RE: sCHOOL.BAK

    muhamadehsan (10/24/2016)

    Actually I got the ...

    thanks

    Go back to the source ;-). Ask the one who gave you the RAR file to unzip it, restore the BAK and just deliver the...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 7:54 am

    #1908370

  • RE: ParallelPeriod dynamic set very odd behaviour

    The weeknumber is determined different around the world, mostly depending on what is considered as first day of the week. Check the LOCALE settings of both environments.

    information: http://www.epochconverter.com/weeknumbers

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 5:44 am

    #1908327

  • RE: SQL Mail

    HappyGeek (10/21/2016)

    Is it possible to make contingency for when SQL sends a mail as a result of an alert but the mail server simply fails to deliver? I think I...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 5:37 am

    #1908324

  • RE: SQL Mail

    The query below shows information about how mail has been processed according to SQL Server (see [sent_status] column). But if the mail failed on the SMTP-server without a proper feedback...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 5:30 am

    #1908321

  • RE: SQL query to find the previous date, current date data

    pietlinden (10/23/2016)

    You may need to tweak the WHERE clause so it returns exactly what you want.

    Your answer is perfect if you need to filter for the past 24 hours. As...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 24, 2016 at 5:25 am

    #1908317

  • RE: Can I do this?

    BLandry474 (10/21/2016)

    ... Right now this is all done by 'eyeball' and I thought if I had a good query that could examine a column and its length, then be...

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

    October 21, 2016 at 8:12 am

    #1907972

Viewing 15 posts - 181 through 195 (of 1,409 total)