Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 13,460 total)

  • RE: select SERVERPROPERTY('COLLATION')

    based on this ms doc, where changing the server collation requires a rebuild:

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

    i'm guessing that the server collation is actually the collation of the resource database, regardless of whatever...

    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!

    July 27, 2011 at 7:04 am

    #1359202

  • RE: accessing SQL server from 3rd party application

    is your instance an "Express" instance?

    by default, an express isntance does not allow remote connections...meaning you can work just fiine locally, but nothing can connect to your machine until 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!

    July 27, 2011 at 6:33 am

    #1359161

  • RE: How to find performance difference before and after changing the query in SP

    In addition to what Eugene said, i usually create the replacement proc under a new, temporary name,a dn test them side by side, comparing execution plans;

    yoiu know exec pr_myproc @param...

    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!

    July 27, 2011 at 6:25 am

    #1359153

  • RE: Stored proc returning puzzling error - Invalid column name

    Riskworks (7/26/2011)

    I have a SP that returns a table variable. It compiles and runs with no issues.

    When I call it from another Proc I get an error saying that...

    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!

    July 27, 2011 at 6:19 am

    #1359144

  • RE: Computed Columns

    not directly like that...you could use a scalar function instead...but before i demo that...lets review what you are trying to do...there might be a better way.

    if the email address 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!

    July 27, 2011 at 6:02 am

    #1359128

  • RE: a new db is created

    i was playing witht eh event notifications for that for a while; on a certians erver, i was trying to create a suite of roles in any database that was...

    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!

    July 26, 2011 at 1:18 pm

    #1358769

  • RE: a new db is created

    also, you can use a server wide DDL trigger for CREATE_DATABASE, but if the database is created new from a restore, it's not detected, for whatever reason that;s not 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!

    July 26, 2011 at 1:15 pm

    #1358767

  • RE: Best way to find the number of rows for a view

    GilaMonster (7/26/2011)

    Lowell, to be completely accurate you should sum that grouped by object_id, index_id. If the table is partitioned, there will be multiple rows in there for a single table.

    As...

    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!

    July 26, 2011 at 11:50 am

    #1358706

  • RE: Best way to find the number of rows for a view

    i suspected what gail said, where you have to use a SELECT * FROM VIEWNAME was the only way to do rowcounts for views.

    for tables, you can use the indexes...

    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!

    July 26, 2011 at 11:43 am

    #1358700

  • RE: Delete data older than 30 days, char to datatime conversion.

    I've inherited situations like this as well.

    this is common issue when you store datatime in a non-datetime field; sometimes you can hope implicit conversiosn will work, but the format...

    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!

    July 26, 2011 at 9:44 am

    #1358628

  • RE: 3 views similar data into 1 report

    i saw that no one name was in two or more of the groups, so i'm assuming they have no relations? is that right? or should they be joined on...

    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!

    July 26, 2011 at 9:29 am

    #1358609

  • RE: Asymmetric Encryption Trigger to Automatically Encrypt

    yes exactly...at the data entry level, they would actually type the value in...but the data would be processed by the stored proc, and stored in an encrypted fashion.

    here's a really...

    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!

    July 26, 2011 at 8:35 am

    #1358567

  • RE: sql server optimize statement

    wendy the devil is in the details;

    we'd proably need to see the actual execution plan of the "new" query hitting those 9 tables to offer concrete advice;

    that actual execution...

    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!

    July 26, 2011 at 8:27 am

    #1358558

  • RE: Cannot insert a non-null value into a timestamp column

    the name timestamp column is very misleading...it's synonym of ROWVERSION is more descriptive.

    change your insert to not include the timestamp column...a new value will be created for you automaticaly, just...

    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!

    July 26, 2011 at 8:23 am

    #1358548

  • RE: Asymmetric Encryption Trigger to Automatically Encrypt

    typically i've used a stored procedure to do the whole CRUD operations for tables which contain encrypted values...or at least when the encryption is handled at the SQL server level.

    then...

    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!

    July 26, 2011 at 8:18 am

    #1358542

Viewing 15 posts - 7,066 through 7,080 (of 13,460 total)