Other SQL Server Blogs around the Web

Browse by Tags

• bcp
• best practice
• best practices
• constraint
• databases
• dba
• error
• information schema
• kba
• length-prefix
• native client
• parameter
• performance
• query
• requirement
• results
• schema
• sql server
• sqlexecute
• stored procedure
• system
• tablename
• table-valued
• terminator
• testing
• triggers
• tsql
• udf
• user-defined
• values
• views

• SQL Server Performance patterns of a UDF with datetime parameters

  There was an interesting discussion about User Defined Fuctions (UDF) performance and patterns, the actual phenomenon is that UDF has got parameters to pass on during the execution. Just to talk about introduction of such options in the SQL Server history... Posted May 11 2009, 02:10 AM by <P>SqlServer-QA.net</P> Filed under: sql server, performance, testing, best practices, function, udf, user-defined, table-valued

• FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect results in SQL Server 2008

  Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: When you call the SQLExecute function to run a query after you set the SQL_ATTR_ROW_ARRAY_SIZE attribute, you may obtain incorrect... Posted Oct 21 2008, 09:38 AM by SqlServer-QA.net Filed under: sql server, kba, query, results, function, sqlexecute

• SQL Server TSQL to find complete CONSTRAINT information on a table catalog?

  I have had a requirement to see a detailed information about a constraint on a table that includes table fields, type, rules, referenced table and fields for FOREIGN KEYs, etc. Found this useful TSQL to get such information: SELECT k.table_name, k.column_name... Posted Jan 09 2008, 07:26 AM by SSQA.net Filed under: sql server, dba, tsql, databases, requirement, tablename, function, constraint, values

• How do I find the parameters for a specified stored procedure or function?

  USE < database_name >; GO SELECT SCHEMA_NAME ( schema_id ) AS schema_name , o . name AS object_name , o . type_desc , p . parameter_id , p . name AS parameter_name , TYPE_NAME ( p . user_type_id ) AS parameter_type , p . max_length , p . precision... Posted Dec 10 2007, 05:21 PM by SSQA.net Filed under: parameter, schema, function, sql server, tsql, stored procedure

• FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"

  The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications... Posted Oct 27 2007, 09:45 AM by SSQA.net Filed under: sql server, error, kba, bcp, function, native client, terminator, length-prefix

• Ways to make best use of INFORMATION_SCHEMA Views - Stored procedures & Functions?

  How many of you took help from using INFORMATION_SCHEMA views in SQL Server? Have you ever wondered in returning the informaiton of a Stored procedure or function, you may be thinking using SP_HELPTEXT would get you. Parts of the solution is yes with... Posted Oct 15 2007, 07:59 AM by SSQA.net Filed under: sql server, tsql, stored procedure, system, information schema, best practice, views, triggers, function