For Programmers: Free Programming Magazines  


Home > Archive > SQL Server Programming > April 2005









Pages: [1] 2 3 4 5 6 7 8

Posts(6)April 30, 2005, 9:01 pmRe: Sort > understanding prob. or Is it sql server bug or any cons
Posts(6)April 30, 2005, 9:01 pmXML, XSD in sql
Posts(2)April 30, 2005, 9:01 pmTrigger question
Posts(1)April 30, 2005, 4:01 pmTrigger question
Posts(3)April 30, 2005, 4:01 pmDB locking up when adding indexes programmatically
Posts(3)April 30, 2005, 4:01 pmQuery Roles and User per SQL
Posts(8)April 30, 2005, 4:01 pmHelp with table total record count
Posts(4)April 30, 2005, 9:01 amSQLExpress And CLR and .config file
Posts(4)April 30, 2005, 9:01 amdata
Posts(2)April 30, 2005, 9:01 amQuestion on, usage of NOT IN
Posts(2)April 30, 2005, 9:01 amStoring string data
Posts(7)April 30, 2005, 9:01 amTransaction in Stored Procedure
Posts(4)April 30, 2005, 4:02 amASCII CR/LF
Posts(8)April 30, 2005, 4:02 aminternal SQL server error
Posts(5)April 30, 2005, 4:02 amconverting default check constraint messages to friendly ones
Posts(4)April 30, 2005, 4:02 amnewbie ?
Posts(9)April 29, 2005, 9:01 pmoutput 2 table data to a text file
Posts(2)April 29, 2005, 9:01 pmSort > understanding prob. or Is it sql server bug or any constrai
Posts(8)April 29, 2005, 9:01 pmAlias not recognized
Posts(12)April 29, 2005, 9:01 pmSchedule a Stored Procedure to run overnight
Posts(3)April 29, 2005, 9:01 pmQuery: WHERE Clause/Dates
Posts(26)April 29, 2005, 9:01 pmHow to store Zero length strings, numbers, dates?
Posts(9)April 29, 2005, 9:01 pmExtended stored procedure?
Posts(6)April 29, 2005, 9:01 pmhelp deleting SIMILAR records (not duplicate)
Posts(17)April 29, 2005, 9:01 pmHow to debug user defined functions???
Posts(3)April 29, 2005, 9:01 pmCritical. How can I do a fast deploy of Analysis Manager
Posts(2)April 29, 2005, 9:01 pmRe: SQLDMO - Generating scripts for granting database access to lo
Posts(8)April 29, 2005, 9:01 pmexclude blank records
Posts(6)April 29, 2005, 9:01 pm"Best" error messages contest
Posts(6)April 29, 2005, 9:01 pmRecognize null in sp
Posts(3)April 29, 2005, 6:45 pmHelp, can't retrieve a function source.
Posts(1)April 29, 2005, 4:04 pmRe: SQLDMO - Generating scripts for granting database access to lo
Posts(2)April 29, 2005, 4:04 pmPass text (or, best, ntext) type value to an OLE Automation function call
Posts(4)April 29, 2005, 4:04 pmStored proc output parameters
Posts(2)April 29, 2005, 4:04 pmReplacing Database Template values
Posts(5)April 29, 2005, 4:04 pmDateTime Data Type
Posts(3)April 29, 2005, 4:04 pmIF Statement
Posts(3)April 29, 2005, 4:04 pmCOLLATION
Posts(2)April 29, 2005, 4:04 pmNewbie: Separating the Date from the Time part in smalldatetime
Posts(7)April 29, 2005, 4:04 pmproblem with bcp using format file
Posts(1)April 29, 2005, 4:04 pmRe: Hierarchies problem
Posts(1)April 29, 2005, 4:04 pmRe: Hierarchies problem
Posts(15)April 29, 2005, 4:04 pminto clause
Posts(2)April 29, 2005, 4:04 pmwhere clause issue when referencing multiple columns
Posts(5)April 29, 2005, 4:04 pmOpening a microsoft application from a stored procedure
Posts(4)April 29, 2005, 4:04 pmServer: Msg 8152, Level 16, State 9, Line 1
Posts(4)April 29, 2005, 4:04 pmConcurrency problem
Posts(1)April 29, 2005, 4:04 pmUser-Defined string Functions Transact-SQL
Posts(6)April 29, 2005, 4:04 pmComparison with multiple tables
Posts(4)April 29, 2005, 4:04 pmWhats this SQL doing?
Posts(4)April 29, 2005, 4:04 pmQuery suggestion
Posts(3)April 29, 2005, 4:04 pmMultiple queries with multiple attachments in xp_sendmail
Posts(5)April 29, 2005, 4:03 pmError handling - web application
Posts(5)April 29, 2005, 4:03 pmIndex questions
Posts(4)April 29, 2005, 4:03 pmnewbie - Decimals
Posts(2)April 29, 2005, 4:03 pmRE: "[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForDa
Posts(5)April 29, 2005, 4:03 pmSyntax for 'USE @dbname CREATE VIEW ...' in a SP ?
Posts(8)April 29, 2005, 4:03 pmRule: Max Number of Lines Per SP
Posts(5)April 29, 2005, 4:03 pmThis is one for the pros
Posts(4)April 29, 2005, 9:03 amSQLDMO - Generating scripts for granting database access to logins
Posts(2)April 29, 2005, 9:03 amThe raging debate re: partitioned views (creating & dropping table
Posts(4)April 29, 2005, 9:03 amQuestion about UDF
Posts(5)April 29, 2005, 9:03 amDTS - With Conditions
Posts(8)April 29, 2005, 9:03 amUser-Defined Functions That Return a table
Posts(3)April 29, 2005, 9:03 amRE: What is the best approach for fetching few records from a table ha
Posts(1)April 29, 2005, 9:03 amRe: What is the best approach for fetching few records from a tabl
Posts(2)April 29, 2005, 9:03 amodd server behavior
Posts(1)April 29, 2005, 9:03 amWhat is the best approach for fetching few records from a table having millions of re
Posts(1)April 29, 2005, 9:03 amHierarchies problem
Posts(5)April 29, 2005, 9:03 amHelp in UDF!!
Posts(2)April 29, 2005, 9:03 amsp_sdidebug "Unable to communicate with debugger (Error = 0x800700
Posts(2)April 29, 2005, 9:03 amclient application bug?
Posts(2)April 29, 2005, 9:03 amRe: Max Number of Lines Per SP
Posts(2)April 29, 2005, 9:03 amrestore filelistonly from disk
Posts(2)April 29, 2005, 9:03 amSQL Profiler Event
Posts(5)April 29, 2005, 9:03 amBulk insert Unicode data
Posts(3)April 29, 2005, 9:03 amcursor or query
Posts(5)April 29, 2005, 9:03 amCorrelated Subquery
Posts(2)April 29, 2005, 9:03 amBreak up Record
Posts(1)April 29, 2005, 9:03 amRe: dblib bulk copy ( empty string VS <NULL>)
Posts(1)April 29, 2005, 9:03 amRe: Why Same SP on same Database diff. duration
Posts(17)April 29, 2005, 4:04 amADO query restricting to SELECT
Posts(6)April 29, 2005, 4:04 amDTS Log Difference
Posts(8)April 29, 2005, 4:03 amDistinct on Text Column
Posts(6)April 29, 2005, 4:03 amText File
Posts(5)April 29, 2005, 4:03 amRename Table
Posts(3)April 29, 2005, 4:03 amoriginal value in an update trigger
Posts(2)April 29, 2005, 4:03 aminset table using sp
Posts(2)April 29, 2005, 4:03 amDTS and MS Access Workgroup
Posts(4)April 29, 2005, 4:03 amPerformance Issues using Aggregate MAX function within a temp table
Posts(5)April 28, 2005, 9:02 pmExtended stored procedures and UDP sockets
Posts(1)April 28, 2005, 9:02 pmRe: Query run very fast in Query Analyser but extremely slow in client application t
Posts(21)April 28, 2005, 9:02 pmCASE vs. JOIN lookups performance difference?
Posts(10)April 28, 2005, 9:02 pmT_SQL Problem
Posts(8)April 28, 2005, 9:02 pmLocking records
Posts(10)April 28, 2005, 9:02 pmmultiple deletes cross tables
Posts(7)April 28, 2005, 9:02 pmRe: The stored procedure executed successfully but did not return
Posts(11)April 28, 2005, 9:02 pmit doesn't correlate
Posts(5)April 28, 2005, 9:02 pmRe: dblib bulk copy ( empty string VS <NULL>)
Posts(4)April 28, 2005, 9:02 pmJoins
Posts(13)April 28, 2005, 9:02 pmSP takes 30 seconds to finish, any tips?
Posts(5)April 28, 2005, 9:02 pmCatch Duplicate records
Posts(4)April 28, 2005, 9:02 pmNee help - How To get AVG in his situation?
Posts(8)April 28, 2005, 9:02 pmHow to Get Averages instead of Totals?
Posts(1)April 28, 2005, 9:02 pmCatalog of Arbitrary Items
Posts(1)April 28, 2005, 9:02 pmRe: Max Number of Lines Per SP
Posts(1)April 28, 2005, 9:02 pmRe: Max Number of Lines Per SP
Posts(3)April 28, 2005, 9:02 pmdocument for the {fn UPDATELINEAGE(0x0, 1)}
Posts(3)April 28, 2005, 9:02 pmmoving logins and password to new server
Posts(1)April 28, 2005, 9:02 pmRe: Max Number of Lines Per SP
Posts(7)April 28, 2005, 9:02 pmuser Permissions on sprocs..
Posts(3)April 28, 2005, 9:02 pmturn off output
Posts(2)April 28, 2005, 9:02 pmRemove hex from database
Posts(2)April 28, 2005, 9:02 pmalter table
Posts(5)April 28, 2005, 9:02 pm@@servername gives old name
Posts(2)April 28, 2005, 4:05 pmReading outlook address book
Posts(7)April 28, 2005, 4:05 pmEncryption problem
Posts(8)April 28, 2005, 4:05 pmCounting Stored Procedures
Posts(4)April 28, 2005, 4:05 pmDeleting min value from grouped records
Posts(7)April 28, 2005, 4:05 pmMultiple Table Problem
Posts(5)April 28, 2005, 4:05 pmDatagrid: date_time column only showing date part
Posts(4)April 28, 2005, 4:05 pmshow all values from my database
Posts(2)April 28, 2005, 4:05 pmcall a program (activex exe, dll or something) from a script
Posts(4)April 28, 2005, 4:05 pmautomated emails based on SQL Queries
Posts(2)April 28, 2005, 4:05 pmTesting SQL code
Posts(6)April 28, 2005, 4:05 pmCount(*)
Posts(3)April 28, 2005, 4:05 pmLevenshtein Edit Distance
Posts(2)April 28, 2005, 4:05 pmDBCC SHOWCONTIG & DB Performance
Posts(3)April 28, 2005, 4:05 pmcollation issues
Posts(3)April 28, 2005, 4:05 pmGenerating Unique Check Digits
Posts(2)April 28, 2005, 4:05 pmTransaction Stuck the system
Posts(1)April 28, 2005, 4:05 pmRe: Good morning born again spammer
Posts(6)April 28, 2005, 4:05 pmRegarding modify property but its not happen...
Posts(3)April 28, 2005, 4:05 pmdatetime update
Posts(1)April 28, 2005, 4:05 pmProblem regarding implementing of DTC
Posts(3)April 28, 2005, 4:05 pmhow check the existing index
Posts(4)April 28, 2005, 4:05 pmIF @@ROWCOUNT > 200 Return Nothing
Posts(4)April 28, 2005, 4:05 pmFormating Strings using SQL
Posts(1)April 28, 2005, 4:05 pmChanging primary key
Posts(7)April 28, 2005, 4:05 pmConverting to datetime...
Posts(1)April 28, 2005, 4:05 pm"[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
Posts(3)April 28, 2005, 4:05 pmusage of statistic on non-indexed columns
Posts(3)April 28, 2005, 9:00 amUDT Question (might be a simple one)
Posts(62)April 28, 2005, 9:00 amTable Design
Posts(6)April 28, 2005, 9:00 amWhy Same SP on same Database diff. duration
Posts(2)April 28, 2005, 9:00 amPbm with CONTAINS
Posts(3)April 28, 2005, 9:00 amIs there any wizard for sql query tuning?
Posts(2)April 28, 2005, 9:00 amComparison of words within a column using "Like" keyword
Posts(1)April 28, 2005, 9:00 amRe: Stored Procedure gives error "Server: Msg 7202, Level 11, Stat
Posts(4)April 28, 2005, 9:00 amStored Procedure gives error "Server: Msg 7202, Level 11, State 2"
Posts(4)April 28, 2005, 8:59 amCLR Trigger in Problem in Sql Server 2005 april ctp
Posts(1)April 28, 2005, 8:59 amRe: dblib bulk copy ( empty string VS <NULL>)
Posts(4)April 28, 2005, 4:05 amdifferentiating between MSDE and other SQL Server editions
Posts(4)April 28, 2005, 4:05 am**Restore error**
Posts(5)April 28, 2005, 4:05 amHelp in Query
Posts(4)April 28, 2005, 4:05 amBlocked Process Command
Posts(2)April 28, 2005, 4:05 amFile storage in databases
Posts(3)April 28, 2005, 4:05 amHow To Export with full sql syntax?
Posts(4)April 28, 2005, 4:05 amTime left for an update statement
Posts(5)April 28, 2005, 4:05 amadding dbo before tablename
Posts(1)April 28, 2005, 4:05 amADODB::Connection Autocommit Isolation Levels??
Posts(3)April 28, 2005, 4:05 amUNION with a column merge
Posts(3)April 28, 2005, 4:05 amEnterprise Manager Freezing up
Posts(9)April 28, 2005, 4:05 amHow to implement a custom Order Column?
Posts(4)April 28, 2005, 4:05 amSet variable to result of query
Posts(6)April 28, 2005, 4:05 amDynamic Query
Posts(1)April 27, 2005, 9:00 pmConverting Row Column to String
Posts(3)April 27, 2005, 9:00 pmConecting linked servers using VB6.0
Posts(1)April 27, 2005, 9:00 pmRE: Converting Row Column to String
Posts(7)April 27, 2005, 9:00 pmLast Day of Month Function
Posts(3)April 27, 2005, 9:00 pmGroup by Max Count ? how to do query?
Posts(4)April 27, 2005, 9:00 pmCount by matching first two letters
Posts(2)April 27, 2005, 9:00 pminsert/update procs
Posts(2)April 27, 2005, 9:00 pmConcatenating strings in a Select statment
Posts(1)April 27, 2005, 9:00 pmForeign key constraint
Posts(12)April 27, 2005, 9:00 pmstring REPLACE problem
Posts(5)April 27, 2005, 9:00 pmprint @variable probem
Posts(1)April 27, 2005, 9:00 pmRe: Good morning or good evening de
Posts(3)April 27, 2005, 9:00 pmTime left in while executing a query
Posts(2)April 27, 2005, 9:00 pmpermissions in proc
Posts(2)April 27, 2005, 9:00 pmUploading a text
Posts(1)April 27, 2005, 9:00 pmRE: Foreign key constraint
Posts(7)April 27, 2005, 9:00 pmNovice Struggling with Query
Posts(5)April 27, 2005, 9:00 pmComplicated Task Please Help
Posts(1)April 27, 2005, 9:00 pmMerging application database into one suite?
Posts(2)April 27, 2005, 9:00 pmRE: Set variable to result of query
Posts(10)April 27, 2005, 9:00 pmUPDATE Query problem
Posts(1)April 27, 2005, 9:00 pm=?iso-8859-1?q?Re:_Good_morning_or_good_evening_depending_upon_your_location._I_want_
Posts(6)April 27, 2005, 9:00 pmTrigger question
Posts(2)April 27, 2005, 4:02 pmNew to SQL
Posts(22)April 27, 2005, 4:02 pmstored procedure inserts: can i get the value of the identity column?
Posts(9)April 27, 2005, 4:02 pmUDF performance
Posts(7)April 27, 2005, 4:02 pmquoted_identifier
Posts(2)April 27, 2005, 4:02 pmHow to encrypt sp
Posts(27)April 27, 2005, 4:02 pmTable variables are they bad?
Posts(5)April 27, 2005, 4:02 pmFinding column use with syscomments
Posts(3)April 27, 2005, 4:02 pmNewbie: Indexing and speeding up querries
Posts(3)April 27, 2005, 4:02 pmBackup database creates smaller files....
Posts(2)April 27, 2005, 4:02 pmHow to force 'lazy spool'
Posts(5)April 27, 2005, 4:02 pmConfiguration file for dts package



Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com