TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
30101: Merge Agent takes all the CPU time
30102: Dynamic SQL weird stuff
30103: Prompt Parameter Query?
30104: Size of objects
30105: SQL 2005 & export stored
30106: Date Fields
30107: scope_identity Vs Parameters
30108: bulk import... SSIS VS custom job
30109: Memory Usage
30110: SCOPE_IDENTITY() / ADO.NET FAILS
30111: query no longer working??
30112: Performance problem
30113: Server Size on Ram
30114: String Manipulation
30115: Getting all users that using sql
30116: SMO Create Database SQLExpress Access Denied
30117: SImple DTS stuff
30118: Logical Design!!!
30119: Need help with trigger -novice-
30120: repost on subtracting date range data between tables
30121: problem with filtering data
30122: trying to implement simple while loop
30123: saving value of COUNT function result
30124: Update and Delete command
30125: newbie openquery question
30126: Outer Join and WHERE clause strange behavior
30127: MINUS operation between table date ranges, is my algorithm sound?
30128: Possible to get column number on a bcp_sendrow failure?
30129: Moving a database
30130: Verify existing Child Data
30131: SQL for custom paging solution
30132: Dynamic SQL and @@Rowcount
30133: Signalling between two applications
30134: Selecting Duplicates - all data
30135: Most recent data point?
30136: Replce SPACES in values
30137: "did you mean" feature
30138: "No more data available to read" error
30139: Help! Query Question.
30140: DB Change Deltas HELP!!!
30141: Performance of UPDATE commands on individual records
30142: Standard Deviation
30143: generic audit trail best practice questions
30144: sp_OAGetProperty procedure is giving error
30145: append a string to all the values in a column SQL
30146: BCP IN: create table on-the-fly
30147: Alter a constraint?
30148: SQL Syntax Question
30149: Constraint
30150: Moving tempdb
30151: Date query
30152: Statistics Deadlocking
30153: Why SQL2k and SQL2005 Return Different Order for sysindexkeys?
30154: Obtaining different timings for the same process??
30155: Is OR so bad?
30156: MTS Query
30157: handle errors in trigger
30158: Obtaining total of partial
30159: What's a good SQL server naming convention
30160: Extracting from linked tables into pivot
30161: SQL profiler
30162: Insert into table with union?
30163: Max question
30164: set theory operations on two tables containing date range data
30165: complicated Join - duplicate row problem
30166: question on inserting a record on sql server with identity column as key
30167: Journal table for a database
30168: Update Query!!!!
30169: Inserting same identity value into two linked tables
30170: Indexing datetime field for selecting dates ranges
30171: User Function Date parameter
30172: Optimizing an IN clause
30173: Can not create trace file
30174: Advanced Sql-Shape Query - Help
30175: NULL issue
30176: SQL 2k5 vs 2k - different results on same execution? ORDER BY prob
30177: IF UPDATE ( column)
30178: one ado connection object - multiple spids?
30179: grouping a few columns
30180: Looking for Query
30181: Division question
30182: DeadLocking
30183: Searching a datetime field by time
30184: Add the end date to record
30185: Searching on partial match in a text field
30186: Subquery Problem
30187: Override Checking...?
30188: scientific notation and CAST or CONVERT
30189: 1. print current count 2. decrement date 3. subtract previous count from new count
30190: Retrieve list of tables without triggers
30191: Installing SQL 2005 Beta
30192: upgrading to 2000 from 7.0
30193: Connecting to SBS SQL via Remote VPN (VB Application)
30194: Pivot Table
30195: What is this called, and how to do it?
30196: ASC/DESC as SP Keywords?
30197: Create record each day from time frame
30198: BACKUP DATABASE
30199: assign truncate rights to a user
30200: Syntax please
30201: How do I use ADO in VC++ 7.0 to get the size of the database
30202: Query Problem
30203: bcp issue
30204: Drive capacity
30205: Sql Server 2005 possibilities
30206: Index
30207: CREATE TRIGGER on system tables
30208: Is there an easier way to programitcally create a new database and login user
30209: Stored Procedures Permissions
30210: convert hex string to hex literal
30211: Access 2003 and SQL Server Development - Best Practices
30212: SQL Server vs the Competition
30213: MS DTS Object Package Library
30214: Filter on view Problems
30215: select * from inserted
30216: Stored Procedure Error - Newbie
30217: create a temporary table
30218: MSAS Meta Data
30219: reverse order of hex bytes
30220: Select Records which are not present in second table
30221: SQL Agent Mail and Outlook
30222: View Parameter problems?
30223: Retreiving multiple Output Parameters
30224: PIVOT Query Question - SQL 2005
30225: Date Only Data Type
30226: Parsing XML data and inserting it into the database... LOTS OF DATA
30227: Update
30228: Adding time
30229: Select Records Bases On Total Needed
30230: Max record
30231: Time Calculation - NEED HELP PLEASE!
30232: top x by hour for some time
30233: convert UTC date
30234: TEXTIMAGE
30235: Why doesnt this query work in SQL Server 2000, but does in 2005?
30236: Array?
30237: Best approach?
30238: 2005 SP1
30239: Mysql Vs Mssql query
30240: DTS Package
30241: help
30242: UniqueIdentifier, performance of Nonclustered indexes
30243: 10 seconds for MoveFirst on a rowset?
30244: copy from C drive of sql server to another sever!
30245: Function update
30246: SQL SERVER Set Up
30247: good db diagramming tool?
30248: Giving a total on a column value change
30249: SQL Thread-safe ?
30250: Bug with GROUPING keyword?
30251: How to convert a Base 64 string to an image
30252: Help with SELECT
30253: SQL Statement guru required please!
30254: temp store ids to delete later
30255: Returning indexed data with stored procedure
30256: Format date output
30257: Display data according to dates
30258: Execute Package Task
30259: EXISTS or other construct to achieve FK table record deletion
30260: Re: View with spaces in field names?
30261: Will encrypted SP under SQL2005 be un-encrypted?
30262: 13-Month Rolling Average
30263: Two DB Update
30264: Help! Problem with DateTime.Now and SQLServer 2005
30265: Set defalut value to previous collumn with changes?
30266: RESTORE just a table from backup
30267: SQL server programming tutorial
30268: SQL and informix
30269: add cariage return
30270: Normalization Question....
30271: SqlDependency and Updates
30272: convert datetime if... then... else...
30273: Sample Code in On-Line Help for SQL Server 2005 is Wrong
30274: SELECT Help
30275: Openquery Help Requested
30276: temp table and SP
30277: How to Set dynamic column name or Change column name dynamicly
30278: Advice on CASE statement
30279: Any quick way to find middle value out of 3?
30280: Comparing Two Tables Without a Cursor...HELP!!!
30281: SQL Server 2000 Trigger - Get value to be inserted
30282: Sum the individual digits in an integer
30283: derived table
30284: Split First name and last name if lastname is number
30285: Last year comparable Business Day
30286: View with spaces in field names?
30287: Deadlocks
30288: xp_readerrorlog
30289: check & limit number users
30290: Adventure Works?
30291: job script
30292: numbering each row
30293: can alter table drop multiple columns
30294: Update existing field to unique value
30295: Creating a Picture in CLR?
30296: How to pass a list of integer values to SP?
30297: Updated Version of SqlClrProject
30298: SQL Server 2000 inline comments
30299: Indexes and ADO.NET
30300: Checking if a SQLServer exists using SQL
30301: RAND
30302: Need Help with UDF's Please
30303: recompile time of an SP
30304: On any change or update
30305: SQL Express 2005 Supported Languages vs SQL Server Enterprise 2005
30306: Cursors
30307: Closing gaps in Celko-tree
30308: Connect to SQL Server 2005 Express Edition using SQLDMO
30309: calculate a sum
30310: The user is not associated with a trusted SQL Server connection.
30311: String parsing
30312: How can I find altered objects in the database?
30313: Regarding ETL, urgent
30314: simple TSQL problem
30315: Ceating new user in Active Directory from SQL
30316: psycho self-join necessary?
30317: SQL Server 2000 - SqlDataAdapter
30318: Just SQLing image data
30319: Converting string hex pair into character
30320: INSERT...EXEC prevents parallelism?
30321: Advice on T-SQL Solution using field expressions
30322: lost access to server through EM
30323: Importing file using SQL Import/Export Wizard
30324: Database projects in VS 2005
30325: lost access to server through EM
30326: Concurency: Oracle vs. MSSQLServer 2K
30327: Move Text Data
30328: Row to Column?
30329: Help finding group totals for year end
30330: Bug in DATEDIFF?
30331: Updating indexes/statistics question
30332: Logical name of the Transaction Log
30333: Change default DATEFIRST in SQL2000
30334: How can I put a row identity in my Select statement
30335: Help on print report or export to a file
30336: sp_executesql
30337: Can I index a table in View ?
30338: Using text field in group by clause and string functions
30339: Create Partition via TSQL or other way (i.e. dynamically)
30340: Script data to T-SQL
30341: Can not call SET ROWCOUNT in a UDF
30342: How to SELECT data from a stored procedure?
30343: Possible to update INSERTED table within trigger?
30344: how to reliably delete (or drop) tables
30345: further to problem with obtaining first/last occurance of contiguous blocks of data
30346: ROUND()
30347: Join in update?
30348: sql-problem
30349: why is my variable empty in this Transact-SQL loop?
30350: Automatically indenting/nesting sub selects in query analyzer
30351: CDONS.mail not working
30352: using * in where clause
30353: Need help with SELECT statement
30354: trigger on column
30355: how can I prevent all jobs start up at the same time?
30356: NULL IN JOINS
30357: obtain first and last occurance of contiguous blocks of data
30358: Redeploying CLR UDT
30359: Can a multi-column index be used for single-column searching?
30360: Client connectivity to SQL Server 2005
30361: Client connectivity to SQL Server 2005
30362: First INSERT in the transaction is not being committed
30363: service account
30364: ignore duplicates from joined tables
30365: ID Creation/ASP/SQL Server
30366: Sql Server Express and VS2003
30367: Calling sp_StartJob again when the job is running, what would happen?
30368: month and 2 digit year
30369: Detaching & Attaching Database
30370: Getting a stored procedures return value -- URGENT !!
30371: How to drop sql server object?
30372: Date
30373: There are some bugs for Management Studio.
30374: A little advice about locks with SQL 2000
30375: Access SubQuery Help Needed.....................
30376: create new table based on union of range data
30377: Connection closed durring application execution
30378: DateTime variables
30379: [OT] Job Posting
30380: duplicate number
30381: Cursor loop is broken
30382: sql profiler vs. query analyzer
30383: xp_SendMail & Char(13)
30384: Table load with duplicates on Primary Key in import file
30385: Check the continuity of dates
30386: SQL Server Instance Name
30387: identify 'next' pk value
30388: INFORMATION_SCHEMA.SCHEMATA does not return all rows on SQL 2005
30389: Alter column add constraint unique
30390: Function Returns Data Type Error
30391: Help with relational set division, please! Good challange!
30392: can this query be cleaner or written better?
30393: Most efficient way to write this
30394: Int vs tinyint
30395: finding length of text field
30396: Table grows at extreme rate but is not full
30397: How to send variable to Oracle in a distributed query
30398: xp_SendMail and CHAR(13)
30399: Update fails after IF EXISTS
30400: Tracking Employees LogTImes
30401: Case stmt
30402: JOIN with table valued function very slow
30403: create other index
30404: Link Server settings
30405: OPTIMIZER LOCK HINTS
30406: Select most recent date time
30407: A new group for statisticians has been formed. Request to join
30408: sysname
30409: trigger
30410: Managing DTS Programmatically
30411: What Are The Issues With MS Access Client to SQL Server DB
30412: Tool to find sqlserver and code dependences
30413: variable TOP value?
30414: trouble using a user defined function
30415: UPLOADING A TEXT FILE INTO A TABLE
30416: Performance - Joins vs Filters
30417: Help - I need a book on SQL
30418: Column X is same, column Y is different?
30419: Property QuotedIdentifierStatus is not available for UDF.. Help?
30420: Database backup stopped and Can't Kill SPID
30421: Imbedded subroutine prefix error
30422: Enterprise manager compatibility
30423: DELETE Trigger
30424: FOR XML performance question
30425: NULL in Joins
30426: extract non-unique records from a table
30427: default column value
30428: Memory problems using Sql Server 2000
30429: Installing Reporting Services on Win 2003 Server with error message "The key 'ReportingServices.WebServiceUrl' does not exist
30430: Rolling Back deleted Data
30431: strip nulls out of image column
30432: Using ADO to duplicate records.
30433: Median Calc
30434: Local Temporary Table Bottlenecks?
30435: Stored procedure creation terribly slow until reboot
30436: SQL Server Management Studio Express
30437: designing history tables
30438: Results of EXEC into table?
30439: Indexed Views in Enterprise Edition...?
30440: multiple inserts in transaction
30441: Need some feedback. What do you think about storing my data like
30442: Joing two tables but avoid cartesian product
30443: Dynamic SQL Column Total Help
30444: Datetime constraint: is there a better way to do this?
30445: Unique transaction identifier
30446: Calculate Median
30447: make 1 record with Union statement
30448: Self Referencing Table question.
30449: Add a field
30450: Problem - Division between floating numbers