Forum Replies Created

Viewing 15 posts - 5,536 through 5,550 (of 13,460 total)

  • RE: Access Database Engine 2010 (32-bit) on Windows 7 x64

    found this over at stack overflow, which says there's a bit of configuring to do, but you can use 32 bit drivers with 64 bit SQL:

    http://stackoverflow.com/questions/1134827/how-do-i-use-a-32-bit-odbc-driver-on-64-bit-server-2008-when-the-installer-doesn

    10 down vote accepted

    It turns...

    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!

    May 1, 2012 at 11:41 am

    #1481968

  • RE: report takes longer to run

    you might remember there are a few other very similar posts which state that after an in place upgrade, rebuilding of statistics is an absolute requirement.

    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!

    May 1, 2012 at 11:13 am

    #1481946

  • RE: report takes longer to run

    sqlfriends (5/1/2012)

    We have a stored proc runs in less than a second on the database using SQL Management studio. But when running through the reporting services using the same...

    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!

    May 1, 2012 at 9:21 am

    #1481853

  • RE: Access Database Engine 2010 (32-bit) on Windows 7 x64

    maybe things have changed, but i had to uninstall office 32 bit completely, and then install the AccessDatabaseEngine_x64.exe so that i could connect via a linked server.

    No big deal for...

    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!

    May 1, 2012 at 9:08 am

    #1481847

  • RE: How Many number of columns we can specify in tabluar report

    SQL has a maximum of 4096 columns in a select statement.

    a Single, normal(non-wide ) table can have up to 1024 columns in it...but wide tables can have 30K columns.

    http://msdn.microsoft.com/en-us/library/ms143432.aspx

    an html...

    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!

    May 1, 2012 at 7:25 am

    #1481785

  • RE: need help with query speed.

    two issues i see:

    two different WHERE statements have a function on a datetime column...

    WHERE DATEADD(day, 15, time) > GETDATE()

    --and later:

    AND CONVERT(DATE, recorddate) = '2012-04-25'

    this requires SQL to do a...

    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!

    May 1, 2012 at 6:23 am

    #1481721

  • RE: Quering with "google-style" operators

    also did you look at this long, detailed article here on SSC:

    A Google Like Full Text Search[/url]

    when the article came out, and i played with it, i learned a LOT.

    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!

    April 30, 2012 at 1:14 pm

    #1481436

  • RE: Modifiy query

    no it's closed to us for manipulation.

    you can manipulate the results with a find and replace, but you cannot change that gui script to to prompt you for an alias...

    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!

    April 30, 2012 at 12:53 pm

    #1481421

  • RE: a view randomly lost/corrupted metadata

    thanks for the info!

    i was guessing that permissions were going to be the cause, but now i'm not sure.

    when i goggled "reported a change in schema version between compile...

    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!

    April 30, 2012 at 9:52 am

    #1481329

  • RE: Compare Database Objects from Multiple Instances

    pawana.paul (4/30/2012)

    Yes. Only trying to see what objects are on one instance and not the other. That is what is my requirement. Please let me know if you have better...

    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!

    April 30, 2012 at 9:26 am

    #1481314

  • RE: a view randomly lost/corrupted metadata

    not sure what advice to offer yet, I've got a couple of questions first:

    what was the specific error that was returned? that would tell us a lot.

    how is the report...

    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!

    April 30, 2012 at 9:18 am

    #1481308

  • RE: Change tracking and immediate notification

    the true instantaneous way would be a trigger, and your notification (email I assume) would have to be able to report if multiple rows were changed, as well as multiple...

    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!

    April 30, 2012 at 8:43 am

    #1481289

  • RE: Change tracking and immediate notification

    Since you aready have a solution that is sending notifications due to change tracking, Instead of adding a trigger or service broker item to send an email immediately, i'd simply...

    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!

    April 30, 2012 at 7:53 am

    #1481253

  • RE: Will Tables affect Performance...?

    -edit: just saw Gail identified your logic as an Entiry-value table, and not a single table of similar values.

    single table for sure.

    That's a basic premise of normalization of your data:...

    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!

    April 30, 2012 at 7:24 am

    #1481223

  • RE: Server IP Address

    you want to think outside of the box on this one...literally.

    you do not want to connect to a sql server simply to ask the sqlserver what it's IP is...since 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!

    April 30, 2012 at 7:18 am

    #1481217

Viewing 15 posts - 5,536 through 5,550 (of 13,460 total)