21351:
Performance issues using Parameters
21352:
Problem Summing When joining a Sum from another Table
21353:
Alias Name...
21354:
SQLServer gets busy, users timed out, what does this Error Log mean ?
21355:
Dynamic WHERE clause
21356:
Dynamic SQL Problem..
21357:
text variables?
21358:
TIP:How to Eliminate duplicate rows??
21359:
-- Freelance Developers Community, who wants to help? --
21360:
Tricky Stored Procedure Question
21361:
Left (or Right) Anti Semi JOIN
21362:
Timeout - max pool size reached
21363:
decimal column to PIC9(09)V99
21364:
deleting comments
21365:
simple insert query
21366:
need urgent help to restrict TargetServerRole...
21367:
SMO Login and User Creation Fails SQL2005
21368:
Import Filemaker Pro data into SQL Server
21369:
CLR and Insert
21370:
Performance problem with SQL Server 2005
21371:
sql server 2000 sample scripts
21372:
deriving DB properties
21373:
Recover .DBD files from LTO tapes
21374:
Update with Where Exists problem
21375:
where download full version of report service 2000
21376:
Fastest way to translate data for normalization in MS SQL
21377:
How to do a restore a .BAK database - SQL 2005
21378:
problem using date in UNION query
21379:
How to caught unknown exceptions when parsing the XML in stored procedures
21380:
Concatenate with UPDATE?
21381:
server name woes
21382:
BCP error - "Unexpected EOF encountered" when using native format
21383:
Database performance question
21384:
BCP error - "Unexpected EOF encountered" when using native format
21385:
VS 2005 and SQL Server 2005 Remote Debugging Issue
21386:
Converting DateTime
21387:
Selecting the Top Nth Record and the Value of N increments by 1 Everytime
21388:
Help with query please
21389:
Insert with begin transaction without closing it.
21390:
Inserting data into a partitioned view via Linked Server
21391:
Join??????
21392:
views - necessary to index if underlying tables are indexed?
21393:
Finding if SQL is 32-bit or 64-bit.
21394:
Recovery model
21395:
Retrospectivly apply a default constraint
21396:
How to Copy a DTS Package to Another Server in Enterprise Manager?
21397:
Trigger. Check update on multiple columns
21398:
SQL Server 2005 timestamp
21399:
Date Conversion to YYYYMMDD
21400:
Inserting row into view???
21401:
Cursors
21402:
Incorrect Syntax
21403:
How to load a list of Integer into temp table by SP
21404:
Recognizing a function name without the Database and Owner
21405:
sp_recompile for user defined functions
21406:
Date manipulations
21407:
Date manipulations
21408:
using parameter for filename in stored procedure
21409:
Inheritance of related objects in a tree
21410:
Strange bug in linked servers
21411:
Check permission to run a statement
21412:
SQL Server 2000 (8.0) update stats doesnt work
21413:
Interpreting query execution plan in sql2000
21414:
Could not find stored procedure 'master.dbo.xp_smtp_sendmail'.
21415:
General Network Error: Please help
21416:
One small question
21417:
READTEXT as parameter for SP
21418:
Move Database to Another Server
21419:
Find missing numbers
21420:
How to Fill a Uniqueidentifier Field
21421:
TABLE_SCHEMA/OWNER QUESTION
21422:
Group by Date in DateTime field
21423:
NEWSEQUINTIALID()
21424:
SImple Delete Statment Help
21425:
Send email from MS SQL using xpsmtp.dll
21426:
sp_lock -> Exclusive Vs. Shared Mode
21427:
Newb Design Q: when to make table
21428:
Slow Stored Procedure Execution
21429:
Get system information about a database
21430:
Interesting Question
21431:
Crosstab
21432:
TSQL to read (and write) in the Active Directory
21433:
Esoteric problem - join to a view bypasses view conditions in date interpretation
21434:
Multiple-step OLE DB operation error in SELECT
21435:
Does for loop read files in a folder alphabetically?
21436:
Fulltime opportunities in Silicon Valley
21437:
Update table field removing all non-numeric characters
21438:
Join Question
21439:
how to specify a dynamic create string as backup name in job
21440:
KeyPress in C#
21441:
Add column names of a table as first row of a table for export reasons
21442:
Make a copy of live database
21443:
How to use "Not Exists" ?
21444:
CASE or IF statement?
21445:
Calling Stored Procedure from stored procedure
21446:
design question: deleting a customer record. archive / delete / flag?
21447:
Eliminate duplicates
21448:
Full Text Catalogues
21449:
log shipping not working
21450:
Selecting data from many columns to one
21451:
Replace a character
21452:
Generating multiple rows with xml data column
21453:
export from oracle
21454:
Deleting duplicates
21455:
NOT IN problem
21456:
Help in writing hierarchical query
21457:
Help in using index tuning wizard
21458:
delete rows timeout
21459:
Sign in comp.database.ms-sqlserver
21460:
UPDATE and SELECT INTO #temp table difference between SQL2000 and SQL2005
21461:
Extract a Unique value from a set of duplicate records
21462:
Inserting international characters
21463:
Have no idea how to do it!
21464:
Table statistics
21465:
Grant Execute
21466:
How to add return values from stored procedures?
21467:
Comments generator
21468:
how to create trigger and procedure
21469:
GET from URL with CLR
21470:
Internal Query Processor Error: The query processor encountered an unexpected error during execution.
21471:
Transaction (Process ID 53) was deadlocked.............
21472:
Full-text search, user instance, and SQL Server Express
21473:
Simple SELECT issues(?)
21474:
Selecting TOP 1 of each group
21475:
storing blobs in file system (as opposed to database)
21476:
Email Notification option not available on scheduled jobs
21477:
Where are the sample database files - 2005
21478:
Best way to make this Query
21479:
EXEC(@sDynamicStatement)
21480:
BULK INSERT
21481:
Stored Procedure question
21482:
SQL restore still Loading
21483:
logging
21484:
I am new, trying to create a complex view.
21485:
getting latest data within a group by
21486:
Need Helps for A Query
21487:
Data model: Comments...
21488:
Two blanks to be changed to one
21489:
Syntax problem with conditional field
21490:
Find first digit in numeric
21491:
Help with case when
21492:
How do i find all available login in sql server through query / sp
21493:
DateTime!!!
21494:
Interpreting SQL Server Error Log File
21495:
How to find stored procedures affected by table changes i.e column addition/deletion
21496:
How make OSQL execute ALL .sql files in a folder?
21497:
Want your opinion: ID vs Number
21498:
Help with having clause
21499:
SQL Server 2005 integration with Visual Source Safe
21500:
IDENTITY column expects a value
21501:
(Problem) DB-Library on SQL Server 2005 with named instance
21502:
New Stored procedure template in SQL Server 2005
21503:
query help
21504:
Update a memo field
21505:
SQL Server gets busy, users timed out, what is going on ?
21506:
Using Image Data Type
21507:
Variables and column titles
21508:
Update Query returns error
21509:
Query performance issue
21510:
Scalar functions and their limitations
21511:
How to group rows ?
21512:
Object Search
21513:
( The cursor is READ ONLY.The statement has been terminated), WHY???
21514:
Should I worry that my Access to SQL conversion has gone so well
21515:
More than 4000 characters in a variable used for a sqlqct statemen
21516:
Moitoring Performance
21517:
Selecting more than one row.
21518:
#temporary table in EXEC
21519:
[SQL Server 2000] Deriving a temp table out of an existing one.
21520:
How Can I Update DBF foxpro Table From Sp
21521:
Dynamic SQL error processing question
21522:
SQL Statement
21523:
Towel tossed in on use of BETWEEN
21524:
select count in 2 tables
21525:
Help with this
21526:
show all when parameters are null
21527:
How have one script execute several others?
21528:
DATEPART alternative in T-SQL that works similarly to VB6/VB.Net DATEPART
21529:
History Table Problem
21530:
How to show a progress meter of backup process
21531:
Unable to SET DATEFIRST to a variable within stored procedure
21532:
Stored Procedure problem
21533:
columns_updated() gets inconsistent values?!
21534:
How to do date formatting on Calendar Control of Asp.net with c# by sql server table for Fiscal year?
21535:
Date Time Format
21536:
What data type should I use, Varchar or Decimal/Numeric
21537:
Question: when/how does the filegroup of Tempdb database clear its
21538:
updating table without using cursors?
21539:
how to make sure the values returned for a particular field returns negative values instead of positves?
21540:
Checking if row exists
21541:
CASE WHEN not working
21542:
Index and Size
21543:
Problems with Dates and INSERT query
21544:
OLE DB data type to SQL Server 2005 conversion
21545:
Isnull - subquery
21546:
Error when Using : Exec sp_MSForeachDB
21547:
How to Merge Multiple Records in a Single Record
21548:
Urgent:601 - Could not continue scan with NOLOCK due to data movem
21549:
Hierarchical Data Retrieval
21550:
Management Studio keeps trying to recover files
21551:
SQL query as parameter
21552:
Advantages and Disadvantages of running a sotred procedure inside another stored procedue
21553:
simple query taking 3 minutes
21554:
Updating new column from a
21555:
Decimal returning integer?
21556:
Can you find the right T-SQL query for this ?
21557:
exception occurred in the TSQL subsystem.
21558:
Is there a better solution than this SP?
21559:
Getting data from sp_trace_getdata SP
21560:
cant get this sql right - please help!
21561:
Help with query
21562:
Select Syntax
21563:
SQLCMD
21564:
Cannot resolve collation conflict for equal to operation.
21565:
Where clause across multiple rows (Pivot??)
21566:
t-sql syntax, append 2 tables records into 1
21567:
SP to undo transaction
21568:
Use query governor to prevent queries exceeding specified cost
21569:
Email SP or View
21570:
Update + Join Help
21571:
Trigger Help for UPDATE
21572:
Database locked when a transaction is started?
21573:
udf newbie
21574:
beginner question - max of a sum of a column
21575:
Multiple ALTER TABLEs dont seem to work?
21576:
dts-copy database tables
21577:
Attach Database?
21578:
Can you LOOP through records with 2005 T-SQL?
21579:
Understand CREATE PARTITION FUNCTION/ SCHEME syntax.
21580:
sys.dm_exec_query_plan
21581:
Accumulating Aggregator?
21582:
WHY! WHY? WHY!?!?!
21583:
Using rownum in SQL Server 2000
21584:
Query Optimisation
21585:
Row count in a Transform Data task
21586:
Deep SQL .Net integration question
21587:
Stress Testing
21588:
Odd behavier
21589:
Standard naming convention for index and triggers?
21590:
Help with Update and logging
21591:
Server & DTS question
21592:
Create Rule
21593:
SQL distance between Latitude and Longitude?
21594:
Select Data from a stored procedure from within a stored procedure
21595:
Displaying output parameter in query analyzer
21596:
Question about summing up different fields in different records
21597:
any performance diff using -Between- or >= and <= ?
21598:
Stored Procedure executed from DTS
21599:
Too slow updates in a large table - Please help
21600:
Query Profiler
21601:
Query to reconcile data
21602:
CLR and datatable
21603:
Database with many tables or multiple databases with lesser tables
21604:
Spreadsheet totals
21605:
Use SSIS For split record
21606:
SQL Server not responding.
21607:
Exec in TSQL (SQL Server 2000)
21608:
parse again
21609:
Problem with UPDATE and IF
21610:
Save Schema Only
21611:
Tuning advisior
21612:
data from production to test
21613:
sql ERROR
21614:
Design Concepts
21615:
Foreign Key may cause multilple cycles
21616:
Bulk Insert from Excel
21617:
Filter Problem
21618:
Random Numbers
21619:
Sort Numbers in Nvarchar As Numbers
21620:
Query Optimisation
21621:
Problem of CPU time
21622:
CLR - User Defined Type - Variable Storage or Other ??
21623:
Dynamically import Outlook .pst file into table
21624:
Stupid permissions question
21625:
I want to take a Data Warehouse home.
21626:
As an Aside
21627:
How do I filter out unwanted rows by only one different column?
21628:
Problem replicating table has the same data (primary uniqueidentify) in both publish & subscriber
21629:
Orders Per Hour Count
21630:
sql 2k5 compatibility level option...
21631:
Count Customers FOr each month
21632:
automating database migration
21633:
Getting an average
21634:
Moving Users from one server to another in 2005
21635:
using BCP to create file inserts NULL fields
21636:
bulk insert issue (appeding next row data to previous row)
21637:
top of group
21638:
Declare and Set
21639:
Newbie update question-- take from one table into another
21640:
Date calculation
21641:
master..sysaltfiles in 2000 vs 2005
21642:
Several text datatype fields in a table
21643:
Grouping data...?
21644:
Configure default date/time parameter in query
21645:
ID's as an array
21646:
sp_testlinkedserver
21647:
OPENQUERY and ADO.NET
21648:
Error with sp_OAMethod
21649:
extracting data
21650:
Message to Email
21651:
Missing data
21652:
View performance when using UNION
21653:
TRUSTWORTHY
21654:
Wildcards
21655:
Using encryption with a user defined function
21656:
req. SELECT STATEMENT
21657:
Help Required on Performance Tuning
21658:
An Urgent help required on Performance tuning
21659:
How Can I Update DBF foxpro Table From Sp
21660:
Trying to match lowercase
21661:
SQL to get redo queue size
21662:
Junction tables
21663:
Client-Side Database Mirroring Details
21664:
too long...
21665:
i need one query
21666:
Index Tiff images using Sql Server 2000
21667:
.Net SqlException, RAISERROR and Remote machines.
21668:
LIKE and IN
21669:
UOW id and XID
21670:
Distributed pending transaction
21671:
total number of items selected
21672:
Querying a remote server
21673:
datetime between problem
21674:
Acessing database on another server from an SP
21675:
SQL Join question - getting most recent value in a history table
21676:
float and mismatch between real data and sql server
21677:
Error - Multiple step OLE DB operation generatied errors. Check each status value
21678:
Pros and Cons of Using GUIDs for Primary Keys
21679:
!MAKE MONEY USING PAYPAL- IT WORKS!
21680:
Parameters in the IN clause
21681:
Indexing a view -- help!
21682:
Select problem Msg. 156
21683:
Get stored proc or SQL from sysprocesses pre SQL2000 SP3
21684:
unable to rollback transaction help!
21685:
Getting records in pages from a table with Guids
21686:
What happens to rows when RETURN is invoked?
21687:
How are oters implementing data encryption in SQL Server 2005?
21688:
good books for sql server 2005?
21689:
how to get charindex of char between numbers?
21690:
suggestions for improving sortable, paging, filterable, fulltext non-dynamic query
21691:
Query Rewrite or Stored Procedure?
21692:
error message - what to do?
21693:
NEED HElP with Properly applying DISTINCT function to Count Aggregate.
21694:
Generating Sequential auto numbers
21695:
CASE function - result data type
21696:
Loop through column names, count values
21697:
Clustered index scans
21698:
SUM function
21699:
Pivoting in SQLServer2000 Again!
21700:
Getting schedules for certain DB backup