Forum Replies Created

Viewing 15 posts - 4,246 through 4,260 (of 13,460 total)

  • RE: Remote Query Speed Issues:

    I think SQLHeap has got the core issue. linked servers have performance issues you need to be aware of.

    try these two things on the server witht eh linked server 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!

    December 10, 2012 at 9:40 am

    #1567093

  • RE: Last Modified Dates on Database & Tables?

    raotor (12/10/2012)

    Hello,

    I'm sure this is an easy one for all you knowledgeable people out there.

    How can I find the modification date of a database or table?

    BTW, by modification date, I...

    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 10, 2012 at 6:46 am

    #1567009

  • RE: How To Generate XML File....From the Table...

    great job providing sample data!

    edit because another post by a different user posted the Identical xml, I've removed my post because it looks like homework

    http://www.sqlservercentral.com/Forums/Topic1394445-392-1.aspx

    And Another Edit:

    oops ok since...

    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 10, 2012 at 6:33 am

    #1567005

  • RE: Continually running SQL Trace

    rama.mathanmohan (12/10/2012)

    Is the rollover option will limit the size of the files used in total with out stopping the trace from collecting data ? Please note, Since this 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!

    December 10, 2012 at 6:18 am

    #1566999

  • RE: Sending Emails From SQL Server

    sure ; setting up database mail is very straightforward.

    a query that uses an EXISTS clause can decide whether to send or not.

    from there, you need to decide if it's...

    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 7, 2012 at 2:23 pm

    #1566774

  • RE: need help with tuning

    since it comes from EF, i assume you cannot fix the query, but must instead fix the tables and indexes to improve the query?

    it's a big job, you need clustered...

    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 7, 2012 at 2:13 pm

    #1566769

  • RE: hours,minutes Between Date Format Of Type Yyyymmddhhmmss

    you will hear this about a million times, but the number one rule is to store datetimes as datatimes; not as strings or bigints or any other datatype;

    when you don't...

    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 7, 2012 at 1:43 pm

    #1566752

  • RE: Alter statement

    what you posted is the syntax for Oracle, I believe.

    SQl server is like this:

    alter table TableName

    add constraint df_ConstraintNAme

    default 'SANDNES' for [ColumnName]

    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 7, 2012 at 12:59 pm

    #1566737

  • RE: Distributing the greatest value by rank in SQL

    based on the first post, here's the table, but i think that's already been created by an existing select statement;

    we need data like this to generate a working query to...

    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 7, 2012 at 12:54 pm

    #1566733

  • RE: Grant user access to only create view

    well if they are going to create views, then they need at least two more permissions don't they?

    VIEW DEFINITION, so they can see other table structures,and db_datareader (which 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 7, 2012 at 10:16 am

    #1566693

  • RE: oracle to SQL conversion

    almost identical, only some fucntion names are different:

    --SUBSTR(TARGET_ID,6,INSTR(SUBSTR(TARGET_ID,6,LENGTH(TARGET_ID)),'.',(-1))-1

    SELECT SUBSTRING(TARGET_ID,6,CHARINDEX(SUBSTRING(TARGET_ID,6,LEN(TARGET_ID)),'.',(-1))-1)

    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 7, 2012 at 9:35 am

    #1566675

  • RE: Storage Space for Table, Column, and Index

    look in the scripts section; there's lots of examples where somone has wrapped sp_spacedused in a cursor,

    For an example of using sys.dm_db_partition_stats that gail mentioned, if you pick...

    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 6, 2012 at 2:13 pm

    #1566353

  • RE: Storage Space for Table, Column, and Index

    sp_spacedused 'Tablename' is pretty good for at a glance info.

    sp_spaceused 'MyTable'

    /*

    name rows reserved data index_size ...

    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 6, 2012 at 1:53 pm

    #1566341

  • RE: Understanding Inline TVFs

    itvfs are applied once to the set, and not against each row.

    an inline TVF will always out perform a multi line TVF;

    ITVF's are really just a special JOIN type in...

    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 6, 2012 at 1:17 pm

    #1566333

  • RE: A quick and easy way to pull up table names, column names, and specific data structure

    jarid you could streamline the use even further if you put that in a stored procedure.

    for example, I created a proc sp_GetDDL which returns the table structure of a table,...

    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 6, 2012 at 12:56 pm

    #1566325

Viewing 15 posts - 4,246 through 4,260 (of 13,460 total)