Forum Replies Created

Viewing 15 posts - 4,276 through 4,290 (of 13,460 total)

  • RE: Web enabled SQL Server Management Studio?

    david take a look at http://www.mylittleadmin.com/

    if that's not what you are after, I can give you a copy of a simple aspx page I slapped together a long time...

    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!

    December 5, 2012 at 7:21 am

    #1565749

  • RE: SQL Trigger for multiple columns - Insert / update

    I think your trigger model needs to look more like this.

    because triggers handle multiple rows in SQL server, you should never declare a variable in a trigger, because it makes...

    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!

    December 5, 2012 at 7:12 am

    #1565747

  • RE: Reduce database size

    Bhuvnesh (12/5/2012)

    Lowell (12/4/2012)

    HEAP tables never release the space taken by deleted rows.

    this is new to me ..can you give me any article reference here ?

    sure!

    take a look at...

    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!

    December 5, 2012 at 5:25 am

    #1565691

  • RE: trying to loop through all database on server to get a count of tables and stored procedures on each database

    it's because you have have to specify the database name in front of information_schemas, otherwise it's the current context.

    i personally avoid the information_schemas, and go for the SQL views instead;

    this...

    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!

    December 4, 2012 at 2:25 pm

    #1565503

  • RE: Reduce database size

    to get it to 10% of it's original size, that means deleting 90% of the data? i don't think that's what you are really asking.

    besides the points above, (and compresison...

    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!

    December 4, 2012 at 1:37 pm

    #1565483

  • RE: Querying Results From a Query

    we'd have to see the actual table structure and sample data (CREATE TABLE ...INSERT INTO)

    but you could do something as easy as joining with an "exotic" join...that is not with...

    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!

    December 4, 2012 at 10:52 am

    #1565434

  • RE: Login Auditing

    well, for the SQL log, exactly where the logs go is configurable...when you first install the server, one of the options is to decide on the folders.

    it defaults to 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!

    December 4, 2012 at 9:48 am

    #1565406

  • RE: Database Systems

    moh_ab1979 (12/4/2012)

    Just i want to know what do it mean exactly connectivity standard ?

    Does it mean the way to connect the database with application like ODBC engine or ........etc

    well...

    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!

    December 4, 2012 at 9:39 am

    #1565400

  • RE: Views based on tables on diff servers

    its certainly possible, you'd probably want to create a linked server to the other server, and then create the view with a full four part naming convention.

    CREATE VIEW

    AS

    SELECT ColumnList

    FROM MyLinkedServer.DatabaseName.dbo.TableName

    Where...

    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!

    December 4, 2012 at 9:26 am

    #1565393

  • RE: Database Systems

    ODBC (Open Database Connectivity)

    http://en.wikipedia.org/wiki/ODBC

    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!

    December 4, 2012 at 6:56 am

    #1565297

  • RE: How to retrieve Table Variable data in a Trigger

    Minnu (12/4/2012)

    Sorry for asking,

    my requirement is:

    i've to call the stored procedure based on "id" and get the corresponding Name from the temp table.

    Please suggest

    wouldn't that be a simple select?

    SELECT...

    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!

    December 4, 2012 at 6:54 am

    #1565296

  • RE: Collation

    it also gets a lot more difficult if you have any constraints on any of those 50 columns...unique constraints, indexes, defaults, etc could prevent the ALTER command from completing.... all...

    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!

    December 4, 2012 at 6:52 am

    #1565295

  • RE: Straight & Reverse Check - kcehc eserveR & Straight

    great job on providing sample ddl and data!

    does this do what you are after?

    With CurrencySplit(currencypair,rate_value ,ccy1,ccy2)

    AS

    (

    SELECT

    currencypair,

    rate_value,

    LEFT(currencypair,3),

    RIGHT (currencypair,3)

    ...

    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!

    December 4, 2012 at 5:32 am

    #1565244

  • RE: Data migration from sql to oracle

    as i remember it, MSDAORA is 32 bit, no longer supported, adn only works correctly on oracle 9 and below;

    10,11 and above changed the way they handle BLOB/CLOBS, and 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!

    December 3, 2012 at 1:46 pm

    #1565034

  • RE: SQL Query performing really slow

    this is what i would suggest first thing, since it's not a bad thing to update statistics:

    DECLARE @Exec VARCHAR(MAX)

    SELECT @Exec = ''

    SELECT @Exec = 'UPDATE STATISTICS ' + QUOTENAME(schema_name(schema_id))+ '.'...

    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!

    December 3, 2012 at 1:11 pm

    #1565027

Viewing 15 posts - 4,276 through 4,290 (of 13,460 total)