Forum Replies Created

Viewing 15 posts - 5,461 through 5,475 (of 13,460 total)

  • RE: Limiting the records?

    first a gentle reprimand: you've seen enough posts about providing code...posting pseudo code gets you a psuedo-answer that you have to adapt and ask more questions about...if you posted your...

    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!

    May 29, 2012 at 6:12 am

    #1494119

  • RE: Unable to shrink datafiles

    truncating or deleting never returns file space to the server; it merely clears the internal tables so SQL can reuse the same space. SQL continues to reserve all that space...

    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!

    May 27, 2012 at 3:12 am

    #1493581

  • RE: stored procedure library

    another option:

    if you use a common naming convention across related procs/tables etc, SSMS has the little used option to filter the results in the Object Browser to limit the items...

    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!

    May 25, 2012 at 7:04 am

    #1493125

  • RE: Dynamic SQl error - I might be doing something wrong.

    michael vessey (5/24/2012)

    and please re-read the thread yourself - lowels reponse was to change the "query results to text" - which is nothing to do with a select 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!

    May 24, 2012 at 8:43 am

    #1492603

  • RE: Dynamic SQl error - I might be doing something wrong.

    the truncation is because by default, to save memory, SSMS limits the Results-To-Text to the first 256 characters, regardless of the results.

    change it in your options to 8000

    not that no...

    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!

    May 23, 2012 at 11:57 am

    #1492008

  • RE: SQL 2012 developper edition

    express 2012 is free, and you can get it straight from microsoft;

    the enterprise evaluation edition is also free, but it expires after a while.

    both of those you can google 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!

    May 22, 2012 at 3:25 pm

    #1491448

  • RE: Manual UnInstall for SQL Server 2008 R2 standard edition

    SQLKnowItAll (5/22/2012)

    Just saw this link in another post from Lowell: http://msdn.microsoft.com/en-us/library/ms143412.aspx

    I was going to paste it here two! two questions on the same subject just a couple of minutes apart;...

    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!

    May 22, 2012 at 1:30 pm

    #1491344

  • RE: Problems With if And else.

    simple syntax issue.

    you have BEGIN ( and ) END; the parentheses are not allowed

    cthis is syntactically correct:

    CREATE PROCEDURE Casino.SP_SLOTMACHINE

    @User NVARCHAR(10),@bet INT

    AS

    BEGIN

    DECLARE @L_Wheel...

    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!

    May 22, 2012 at 1:29 pm

    #1491341

  • RE: Restore a database with a used space only

    not natively no. if the database is set to 60 gig, even though it's 10% used, you need 60 gig to restore it.

    that said, Redgates SQL virtual restore will...

    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!

    May 22, 2012 at 1:20 pm

    #1491333

  • RE: Column naming convention

    in our shop, all the identity columns contain the tablename + Id, so repeating the tablename would be repetitively redundant 🙂

    so for example TBAddress would have an identity TBAddressID...

    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!

    May 22, 2012 at 11:44 am

    #1491257

  • RE: How do I link 2 records in the same table with no apparent link?

    the data presented formatted as select statements:

    SELECT '805880' AS TC_EMPNO,'2012-05-20 22:41:00.000' AS DateTime,'IN' AS PunchType,'1' AS tc_type,'8831916' AS TC_ID UNION ALL

    SELECT '805880','2012-05-21 07:15:00.000','OUT','11','8837290' UNION ALL

    SELECT '805880','2012-05-21 22:46:00.000','IN','1','8850645' UNION ALL

    SELECT '805880','2012-05-22...

    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!

    May 22, 2012 at 9:42 am

    #1491175

  • RE: Rewriting Stored Procedure from Cursor to SET-based

    it looks to me like the cursor is calling a stored procedure [STAT_LK.dbo.stat_v3] for each row;

    to change this to a set base, wer would need to see the defintiino of...

    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!

    May 22, 2012 at 7:51 am

    #1491089

  • RE: select permission denied on object

    still sound slike multiple roles are hitting the user;

    i would test as that user and see what roles that login was in;

    --see what windows roles the windows user belongs...

    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!

    May 21, 2012 at 2:45 pm

    #1490729

  • RE: Does the database with huge ldf file takes long time to restore?

    i think it has to do with applying the logs prior to teh database being marked as ready to use.

    that for a big MDF/Small LDF, the restore just has...

    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!

    May 21, 2012 at 2:20 pm

    #1490713

  • RE: Missing Index Information DMV.

    PradeepVallabh (5/21/2012)

    Thanks for your good explanation....I was just playing around without using include statement while creating a non clustered index(analysed the execution plan), it give's a RID Lookup 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!

    May 21, 2012 at 2:14 pm

    #1490708

Viewing 15 posts - 5,461 through 5,475 (of 13,460 total)