Forum Replies Created

Viewing 15 posts - 11,266 through 11,280 (of 13,460 total)

  • RE: msdb bloated to 4 gig with no jobs

    ok that returned this info for that database:

    Database Name Log Size (MB) Log Space Used (%)

    msdb 0.4921875 81.74603

    so...

    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 8, 2009 at 7:36 am

    #974272

  • RE: msdb bloated to 4 gig with no jobs

    oh and i did do my due diligence before posting; i googled and went thru all the steps found here:

    http://www.mssqltips.com/tip.asp?tip=1461

    but with results like 135 rows of data, nothing there jumped...

    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 8, 2009 at 7:29 am

    #974262

  • RE: sp_dates add this proc to your code collection

    Florian thanks for your function;

    one format, the ISO one, is really handy for me, as I have to do a lot of that conversions;

    ISO8601 (XML) ...

    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 8, 2009 at 6:21 am

    #974203

  • RE: sp_dates add this proc to your code collection

    florian i named it with sp_ on purpose in this case, and then placed it in the master database; that way i can call it from any database i happen...

    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 8, 2009 at 6:15 am

    #974200

  • RE: sql server reverse engineering

    by data mmodel you mean a diagram, where all the tables are shown with likes representing foreign keys?

    if you have the database, the schema is wide open for you 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!

    April 8, 2009 at 5:25 am

    #974165

  • RE: Convert DateTime to Epoch

    ok my google-fu is strong tonight;

    SELECT DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --<<SQL Date to Epoch Date

    SELECT DATEADD(s, 1239156328, '1970-01-01 00:00:00') --<<Epoch Date to SQL Date

    found that over at http://www.epochconverter.com/%5B/url%5D

    im...

    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 7, 2009 at 8:09 pm

    #973963

  • RE: Convert DateTime to Epoch

    duh...format 121 does exactly what you need, sorry i misread:

    FormattedDate Code...

    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 7, 2009 at 7:01 pm

    #973943

  • RE: Convert DateTime to Epoch

    just use a combination of two built in CONVERT formats:

    SELECT CONVERT(VARCHAR,@date,112) + ' ' + CONVERT(VARCHAR,@date,114)

    --results: 20090407 20:58:00:280

    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 7, 2009 at 6:59 pm

    #973942

  • RE: A very complicated Date query

    nuts with over 100 posts, you know you should post the schema and data in a format everyone can use to help!

    a wag of my finger at you!

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

    April 7, 2009 at 6:42 pm

    #973939

  • RE: Turning auto close OFF for all the databases

    i typically use this cursor to do the same thing...besides autoclose, i don't need to have the recovery at FULL on my developer machine:

    USE MASTER

    declare

    @isql varchar(2000),

    @dbname varchar(64)

    declare c1 cursor 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!

    April 7, 2009 at 3:54 pm

    #973867

  • RE: find carriage return in data

    something like

    SELECT * From YOURTABLE

    WHERE FIELDNAME LIKE '%' + CHAR(10) + CHAR(13)+ '%'--vbCrLf

    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 7, 2009 at 12:15 pm

    #973708

  • RE: Select all tables from all databases using T-SQL

    how about his:

    exec sp_MSForEachdb 'SELECT ''?'' as DBName, ?.dbo.sysobjects.name AS TableName from ?.dbo.sysobjects WHERE ?.dbo.sysobjects.xtype=''U'''

    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 7, 2009 at 9:02 am

    #973469

  • RE: Script out the entire database in SQL 2005

    I've got an upcoming article on how to do this in TSQL, with a complete solution:

    all objects in dependancy order, along with the data.

    while you are waiting for the article...

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

    #973313

  • RE: Learning about backups and restores

    oops bad info removed. I'll read up and come back.

    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 7, 2009 at 5:26 am

    #973224

  • RE: mySQL 4.1.2 Length of query??

    i had to google this, because i didn't know either;

    http://lists.mysql.com/mysql/187971

    you can find out your current setting with this comand

    SHOW VARIABLES LIKE 'max_allowed_packet';

    +--------------------+---------+

    ¦ Variable_name......¦ Value...¦

    +--------------------+---------+

    ¦ max_allowed_packet ¦...

    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 7, 2009 at 5:24 am

    #973222

Viewing 15 posts - 11,266 through 11,280 (of 13,460 total)