Forum Replies Created

Viewing 15 posts - 361 through 375 (of 459 total)

  • RE: The Vermillion Screen of Death (Raw Materials Comic Strip)

    LOLOLOLOLOLOLOL!!!!

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 11, 2009 at 7:19 am

    #957453

  • RE: Finding all data types in user tables

    casc (12/5/2008)

    Hi Gaby.

    If this script should run on MS SQL Server, you have to fix it first!!!!

    BR cas

    Umm...this script ran fine in 2005. Tested in master, AdventureWorks, and a...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 6, 2009 at 11:32 am

    #955147

  • RE: Security context for dtexec on SSIS package

    K. Brian Kelley (2/28/2009)

    If you already have an external scheduler, is there a reason to run it from within SQL Server? You could set up a batch job to call...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    March 2, 2009 at 6:09 am

    #951802

  • RE: Security context for dtexec on SSIS package

    Greg Charles (2/27/2009)

    First question is where is the package stored - in SQL Server or in the file system? If it's in SQL Server, you can take advantage of...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 27, 2009 at 11:18 am

    #951310

  • RE: TSQL - tempdb

    Chad Crawford (2/27/2009)

    Gaby Abed (2/27/2009)

    How many rows would this return? 🙂 (yes...it's different)

    use AdventureWorks

    go

    declare @tableA TABLE(col1 int, col2 int)

    go

    --stmt 1

    select name from tempdb.sys.tables where name like '%tableA%'

    --stmt 2

    select...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 27, 2009 at 8:34 am

    #951213

  • RE: Perfmon

    sudhakara (2/25/2009)

    ALZDBA (2/25/2009)

    I think it is CU2 http://support.microsoft.com/kb/961930

    thks for your reply ..can you anyone confirm this what is the latest cumulative update package for sql server 2005 sp3 ?

    Try this...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 27, 2009 at 7:05 am

    #951140

  • RE: TSQL - tempdb

    How many rows would this return? 🙂 (yes...it's different)

    use AdventureWorks

    go

    declare @tableA TABLE(col1 int, col2 int)

    go

    --stmt 1

    select name from tempdb.sys.tables where name like '%tableA%'

    --stmt 2

    select name from tempdb.sys.columns where...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 27, 2009 at 6:47 am

    #951123

  • RE: Defragmenting indices on tables with a small number of pages

    GilaMonster (2/26/2009)

    1000 page is the usual rule-of-thumb. Smaller than that and the table will probably be in memory. Fragmentation is a disk issue, it doesn't affect pages in memory.

    The other...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 26, 2009 at 7:26 am

    #950581

  • RE: Do You Verify Your Database Backups?

    Steve Jones - Editor (2/25/2009)

    Gaby,

    I think this works to a point. When I worked at a small company, 3 or 4 instances, 5-10 databases, this is easy. When I worked...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 25, 2009 at 9:13 am

    #950079

  • RE: Do You Verify Your Database Backups?

    Steve Jones - Editor (2/24/2009)

    You restore all user db backups every day? Automated to a remote server?

    How much data is there?

    It's not all that unusual it seems. There's a...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 25, 2009 at 7:17 am

    #949956

  • RE: Do You Verify Your Database Backups?

    Jeff Moden (2/21/2009)

    I absolutely agree... It's not what you can backup... it's what you can restore. I do at least one "practice" recovery a week and I'm not the...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 24, 2009 at 7:34 am

    #949358

  • RE: Negative numbers......

    venki (2/20/2009)

    Hi,

    I have a negative numbers in one of the column. Actually that is temperature min_temp.

    Min_Temp float

    In another table, the datatype is varchar for this data. I want to...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 23, 2009 at 12:42 pm

    #948877

  • RE: Querying small table against very large table, indexing strategy involved?

    Thanks GSquared. I had a sneaky suspicision that was the case, but had to be sure in cases where the table is truly massive.

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 23, 2009 at 8:32 am

    #948637

  • RE: My favorite way to access Excel files

    Jacob Luebbers (2/19/2009)

    Gaby,

    You may also want to amend the article to include the Excel 2007 methodology. Eg. using the Microsoft.ACE.OLEDB.12.0 provider with the Office 2007 System Driver installed.

    Thanks...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 20, 2009 at 6:51 am

    #947458

  • RE: Generate a random password

    J (11/13/2008)

    Nice !

    There also might be confusion between letter "G" and number 6...

    Definitely, feel free to update the script to do so. However, I've also submitted an updated script...

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

    February 10, 2009 at 10:18 am

    #941429

Viewing 15 posts - 361 through 375 (of 459 total)