Search:

Type: Posts; User: kaffenils

Page 1 of 13 1 2 3 4

Search: Search took 0.14 seconds.

  1. Re: Lock and unlock store procedure by manually

    Are you thinking about the WITH ENCRYPTION option. Ref http://msdn.microsoft.com/en-us/library/ms187926.aspx

    Specifying WITH ENCRYPTION in the CREATE PROCEDURE statement will render the procedure...
  2. Replies
    1
    Views
    1,693

    Re: MSSQL equivalents of mysql commands

    select * from sys.databases
    select * from <dbname>.sys.tables
    sp_help 'tablename'
  3. Replies
    6
    Views
    741

    Re: How well does Soundex perform

    The only thing that you should be concerned about is the fact that SOUNDEX causes table/index scans, which of course will hurt performance depending on the number of rows in the table. If you want to...
  4. Replies
    6
    Views
    741

    Re: How well does Soundex perform

    As long as you have an index that contains the column you are SOUNDEXing, and that index is smaller (in # of pages) than the clustered index/table heap, then it is much cheaper for SQL Server to do a...
  5. Replies
    12
    Views
    1,006

    Re: Perfomance Question on the Following Query

    I agree that putting an index on a large column is really not a good thing, and I don't know the size of this column. It could be 50 chars or 8000 chars. And an index has a size limit of 900 chars.
    ...
  6. Replies
    2
    Views
    596

    Re: Recover from .MDF file

    The structure of an MDF file is not really a secret.

    But back to your problem with the missing log file. You can attach a database and have SQL Server create a new log file.
    ...
  7. Replies
    6
    Views
    741

    Re: How well does Soundex perform

    Are you sure you're not confusing index scan with index seek? Index seek is the "good" way, in which SQL Server will do lookups in the node and leaf structure. A scan on the other hand will read the...
  8. Replies
    12
    Views
    4,183

    Re: Problem with adLongVarChar type

    This is probably because the data in Oracle is unicode.

    Use adWLongVarchar (or was it adLongWVarchar) instead.
  9. Replies
    12
    Views
    1,006

    Re: Perfomance Question on the Following Query

    @vuyiswamb: Two things come to my mind.

    #1: Parameter @Letter is char(2), but your left/right/substring returns only one charachter. How can that work properly?

    #2: Once you start using...
  10. Replies
    3
    Views
    664

    Re: Altering table used in replication

    As others have stated, it's a pain in the ass on SQL Server 2000.

    As I see it you have to options.

    1. Create a new column (for temporary storage) with the same data type as the existing. Copy...
  11. Replies
    4
    Views
    7,864

    Re: I need a Simple ER Diagram For Bookshop

    Give Me Teh Code!!!
  12. Re: Tutorial: SQL Server recursion - Parent child relations

    Can you post the dat ayou insert, and the sql you run that fails to work.
  13. Replies
    6
    Views
    556

    Re: Monitoring SQL Server 2005

    Use SQL Server Profiler.
  14. Replies
    10
    Views
    741

    Re: What is wrong with this UDF? MS SQL 2K5

    What you want to do is create a Multistatement Table-valued Function.

    The function returns a table representing the splitted values, and you reference it as any other table in an INSERT statement.
  15. Replies
    3
    Views
    1,174

    Re: MySQL queries with apostrophes?

    No, no, NO. Never build dynamic SQL statements like this. You are opening up your system to SQL injections. ALWAYS use parameterized queries.



    http://imgs.xkcd.com/comics/exploits_of_a_mom.png
  16. Re: guys help!!!!about sharing database over LAN in sql server 2005

    Are you kidding me??? What is the title of this major subject? I really hope it has nothing to do about computer science, for your sake.
  17. Re: how to create log in user in sql server 2005

    create login edgarbenilde with password=N'mysecretpassword'

    This will create a login but will not grant access to any databases.

    To create a database user for the login you just created you...
  18. Replies
    3
    Views
    696

    Re: Sql2005 - Create Assembly

    You'll have to set the database to allow EXTERNAL or UNSAFE asseblies. Take a look at those keywords in BOL.
  19. Replies
    8
    Views
    689

    Re: Sequence in SQL Server 2000

    It's not unreliable if you use proper locking and isolation level.

    Use SERIALIZABLE to protect against other inserts in the range when you get max(columnname). Also put a UPDLOCK on the...
  20. Re: [SQL 2005] Exporting all data as SQL Scripts

    Don't think there are any built-in features in SSMS.
    You can build a program that scripts out the schema and creates INSERT statements for all the data. The "problem" is that you will have to...
  21. Replies
    1
    Views
    498

    Re: SS2K5 error messages

    It is not stored anywhere.
  22. Re: Arranging the values of column

    If the interviewers asked for a query that would return the sequence in the "natural" (meaning the original sequence that the data was inserted) order, they have absolutely no clue of how SQL Server...
  23. Re: Arranging the values of column

    The question is pretty simple as I see it.
    "Number in order" means ascending. SQL Server has no knowledge of what rows where inserted first or last, so "number is original order" is impossible to...
  24. Replies
    2
    Views
    577

    Re: Using SELECT TOP Statement

    Put the variable @xNoOfRows in parenthesis:

    select top(@xNoOfRows)
  25. Replies
    16
    Views
    1,105

    Re: Read Log Files

    There are no MS shipped tools to do this, but 3rd part products exists. For example http://www.lumigent.com/products/le_sql.html
  26. Replies
    5
    Views
    471

    Re: Tuning statement again

    Can you execute

    set showplan_xml on

    .. your sql here

    and post the xml output.

    Also execute
  27. Replies
    2
    Views
    555

    Re: how to make triggers

    Show us the code that builds the strTrigger text. I suspect that you are missing some spaces or line breaks.
  28. Replies
    9
    Views
    1,003

    Re: open connections

    If we're talking about SQL Server you can kill a spid by using the KILL statement, or if you want to kill all users you can execute
    ALTER DATABASE MyDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE
  29. Replies
    2
    Views
    538

    Re: server problem

    If this is SQL Server 2005 Express you must also give the instance name SQLExpress in the "server" property:

    SqlConnection("server=localhost\SQLExpress;database.....")
  30. Re: SQL Server 2005 view question

    I did a little test (why didn't you think of that:D ) on how CAST rounds the value, and it seems like it rounds it correctly.


    select cast(1.233 as decimal(25,2))
    returns 1.23


    select...
  31. Replies
    2
    Views
    443

    Re: recursion without loops?

    This tutorial should get you started
    http://www.vbforums.com/showthread.php?t=366078

    No cursors are involved, and the number of loops is equal to the depth of the thread.
  32. Replies
    10
    Views
    905

    Re: In over my head SQL to XML

    Bad idea.
    XML has five special characters and the are <>"&'
    You don't replace them with empty string. Instead you use the defined escape characters.

    strValue = strValue.Replace("<", "&lt;")...
  33. Replies
    29
    Views
    1,404

    Re: Which language to use??

    How is data in your exmplae related?
  34. Replies
    4
    Views
    530

    Re: array in sql 2005

    As brucevde says, there are no arrays in sql server. I have used xml when I've needed arrat functionality.
  35. Replies
    5
    Views
    584

    Re: MSDE 2 Gigs Limit question

    You could try, but I'm pretty sure the limit is per database, not per file.
  36. Re: Backing up the log file with truncate_only

    Full backup=Backup of the whole database.

    A transaction log file is split into several virtual log files.
    In FULL and BULK_LOGGED recovery model, the transaction log must be backed up in order...
  37. Replies
    6
    Views
    590

    Re: [sql 2k5] what is path

    You are correct that PATH is a reserved keyword in SQL Server 2005. I originally wrote the script for SQL Server 2000 where it is not a keyword.
  38. Replies
    6
    Views
    590

    Re: [sql 2k5] what is path

    Path is just a column name. You can name it blablabla if you like.
  39. Re: Backing up the log file with truncate_only

    You use the log backup if you need to restore the database to a specific point in time. You also need a full backup in order to be able to restore log backups.
  40. Re: Backing up the log file with truncate_only

    Use single quote ' instead of double quote " in the file name.
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width