Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 13,460 total)

  • RE: Developing a comprehensive database metadata report

    well, there is a few contributions here on SSC that does some of what you are after and much, much more:

    http://www.sqlservercentral.com/search/?q=database+documentation&t=s&sort=relevance

    one of the four links for "Comprehensive Database Documentation" 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 13, 2013 at 8:18 am

    #1673276

  • RE: Reclaim space following column drop

    you have to rebuild all the indexes on the table, including the clustered index i believe in order to free the space to the database again.

    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 13, 2013 at 7:36 am

    #1673258

  • RE: Why asp.net app run very slow?

    not enough information for us to offer more than vague things to check.

    performance tuning is a wide subject, and the tiny bit you gave us so far isn't enough 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 13, 2013 at 7:24 am

    #1673251

  • RE: Create link server for Microsoft Access2000

    pietlinden (8/28/2013)

    Wouldn't you use JET4.0 instead of ACE? ACE is the filetype for Access 2007 and beyond.

    the ACE drivers are required for a SQL server 64 bit version 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 12, 2013 at 12:00 pm

    #1673061

  • RE: Data Dictionary

    i've heard the data dictionary as being the Extended Properties comments that are potentially included in a database to describe objects/tables /columns, but only if someone has gone 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 12, 2013 at 11:31 am

    #1673050

  • RE: display columns with no data

    you have to change your query to query first from a Calendar table of some sort, which contains all possible dates.

    then your CTE left joins to that Calendar table.

    with 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!

    December 12, 2013 at 9:10 am

    #1672997

  • RE: error with stored procedure

    in the procedure itself, do you have something like RETURN @MyDateValue

    the return of a stored procedure only can return an integer, and it typically means success(0) or failure(non zero) ,...

    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 12, 2013 at 6:59 am

    #1672936

  • RE: Error not resolved? SQL 2K8R2

    since it's happening on the server itself(local machine), look at the running processes, and see if there's an additional application or scheduled task or something that is running/trying to connect...

    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 12, 2013 at 6:24 am

    #1672925

  • RE: How to check characters from string

    there is some support for patterns/regular expressions in SQL

    this does what you are asking, i think. one expression tests exactly ten characters, the other test the first ten characters

    WITH mySampleData(val)

    AS

    (

    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 12, 2013 at 5:54 am

    #1672912

  • RE: How can I return a bitmap image from a custom assembly to an SSRS report?

    Stan for the portion where you stick the image into a table, you can do it via a CLR function;

    the CLR would look like this:

    [Microsoft.SqlServer.Server.SqlFunction()]

    public static SqlBytes CLR_GetFileImage(SqlString RetailerId)

    {

    try...

    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 12, 2013 at 5:43 am

    #1672908

  • RE: Memory Buffer says table occupies upto 6x more memory space than physical table size

    my first guess is that the table is a HEAP.

    if the table is a HEAP (meaning it does not have a clustered index) when individual rows are deleted from the...

    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 11, 2013 at 2:56 pm

    #1672771

  • RE: setting up variables to be used for an IN clause

    the function found at the end of this article is very highly rated among my peers here on SSC:

    http://www.sqlservercentral.com/articles/Tally+Table/72993/

    select * from table

    where numberColumn in

    (SELECT Item FROM dbo.DelimitedSplit8K(@x,',')

    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 11, 2013 at 1:39 pm

    #1672745

  • RE: Sequence in PDW 2008

    it looks like not in Parallel Data Warehouse 2008, no sequences, sorry.

    they are appear to available in Parallel Data Warehouse2012

    Sequences were introduced in SQL server 2012, and each PDW...

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

    #1672732

  • RE: "Public" roles

    this can be a little misleading, especially when it comes ot using sp_helpprotect.

    that procedure lists the objects that the public role,(in this specific example) can see,

    if you look at the...

    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 11, 2013 at 7:51 am

    #1672637

  • RE: add the internal email field to the view

    ramyours2003 (12/11/2013)

    How to add add the internal email field to the view on a database ?

    i'm lost in the terminology here: what's "the internal email field"?

    my first guess would be...

    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 11, 2013 at 5:54 am

    #1672584

Viewing 15 posts - 2,791 through 2,805 (of 13,460 total)