View Full Version : Microsoft SQL Server
- sql Date Time Problem
- how to configure snapshot isolation for selects?
- FK constraint -vs- custom constraint for role reference?
- Replication!!!!.......Need help
- datamodel design patterns / your design opinion
- Access Frontend, SQL Server backend
- get Stored Procedure Signature?
- Parenthesis in CURSOR declaration
- How to update records in a table from Excel sheet?
- Selecting Next Appointment Date
- shrink or reset corrupted log file
- Exporting Multiple Tables to Excel
- If exists Update else Insert
- colation settings
- SQL Running Subtraction and Deviation
- Showing Second or Null record
- Loop Thru a Table
- doubt - it's urgent :(
- fetching second maximum value, third maximum value...etc etc
- Define Complex T-SQL
- Converting Access to SQL
- Parsing Data into Additional Columns
- problem with SQl server data insert
- SWITCH-ing partitions and foreign keys
- int vs varchar columns - performance
- Odd query
- Santa
- division
- SSIS populate object Variable
- Optimization Links/Articles/Books
- Organize data by years and dept, please help, thanks
- Recurring database snapshot using variable in filename
- Same Name for Replication Database
- quick table partitioning question, checking for existence of data within part.
- Format Length of time to 00:00:00
- Trying to update a record after insert
- Problem with fetch and cursor
- ssl in sql2000
- Can i transfer users and user logins using GUI ?
- XML Data Import
- SQL Server 2008 R2 Edition Upgrade on the Cluster
- Delete duplicates........How?
- SSMS 2005 Cannot Register SQL 2008
- Problem about Buffer cache hit ratio
- Do i need to use pivot?
- Help needed on wrting SQL query
- XML encoding and collation
- join from one table to another two tables
- MDX Parallel Period & Current Period
- How to copy a replicated database?
- Multiple Foreign Keys to Same Table
- master.dbo.sysprocesses
- Data Transfer from one server to another
- SQL Server HIGH I/O config
- table with 14 FK-ID's, does that mean I need 14 1-column indexes?
- how to copy a database from the server to a standalone PC?
- collections and package
- Error While Insatlling Windows Cluster for SQl Server.
- Rich Text in sql server.
- Figured out an annoying DTA issue (bug?)
- PIVOT on month name when field is a timestamp
- Need help with PIVOT
- Number of tables per schema
- trying to minimize transaction log growth during DB Reindex job
- SQL 2000 Enterprise Manager
- Group By Problems
- Display Data of a Table vertically in sql server
- Inserting Values with Identity and Delete columns
- How to improve speed for query?
- Database Copy from sql2000 to sql2008
- scheduling a blackout period for a job
- Do I need SERIALIZABLE isolation level for this maintenance task?
- Install an app that uses MS SQL Server
- ODBC Link From Access Not Showing Tables
- Help: Turning an audit table into a joinable table
- Problem with '&' character, not able to update ID in SQL table from front end
- Report model security in report builder ..?
- Duplicate a record
- Bulk Insert with Double Quotes in one field
- Divission in sql when case statement is involved
- problem with BCP
- How to update year?
- Select Table Problem
- conenction of two servers
- Creating a new View combing columns
- Failed 2008 install
- migrating principal and mirror on new physical servers
- subquery returned more than 1 value ???????
- fixing a 32-bit installation with a 64-bit installation of sql 2008
- Help With FOR LOOP
- reviewing Index usage
- How to make join match NULL to NULL and more
- Restore .BAK file SQL 2008 R2
- Linked Server Mysql and MSSQL
- SQL equivalent decode function - issues
- PL/SQL or MSSQL BI Developer
- Sql 2008 Snapshot / Database triggers
- Creating rows of records from a STRING.
- looking for a reverse engineering tool from this forum
- Conditional Join
- large table with activity
- Shrinkfile
- UPDATE Help
- Merge Tables
- Running SSRS 2000 having ReportServer database on SQL Server 2008 (64 bit)
- Reindexing script making my applications hang
- Concurrent SQL Update
- regarding sp_OACreate (et al) permissions/grants
- How to avoid aggregate functions and TOP/BOTTOM ?
- Import data from a foreign database using a stored procedure and a ODBC connection
- Normalization
- Exception Handling
- Sending out a mass e-mail from SQL Server at a certain time
- Issue With Updating Column From JOIN
- Please help rural Doc
- Variable Assignment
- Get the number of checks and total by week
- LIKE problem
- getting values based on date
- Access and SQL Server won't play nice
- Loading large data in to transactional plublication
- I created new DATABASE
- Data Mirrioing Or Log Shipping.
- Poor performance
- Building a new SQL Server (machine), RAID questions
- Abmiguous reference message triggered by VS database projects compiler for an SQL XML
- data tier applications in SQL2KR2 and VS2010
- LDF Files
- I need urgent help
- Query only Last Entry for Specific Column
- SQL Case Statement Question
- Needs SQL Query
- deleting duplicate rows in a table
- SSRS question
- Bizarre performance problem
- Centralize the Backup
- Nested Select SQL Question
- Prevent User from Changing Password
- Advanced, complex and interesting search dilemma...
- How to find table name from column value
- access issue - urgent
- Urgent!!! read the table content
- Generate series from a range using procedure
- Two questions on combining multiple rows for output and id's
- merging rows
- Update all Foreign Keys on Migration
- Workflow assistance
- SSIS Package Issue (Odbc driver)
- Weird Delete / Keeping 1 row
- SQL Server 2000 - Auto numbering format
- ASP Connection String to MS SQL DB
- Does deleting rows save space?
- Assigning dataset Equally
- Documentation on administration SQL SERVER 2008.
- Problem Creating Diagrams
- Help with calculations of hour day min .
- Data extraction issue?
- Why inner join?
- back up of a single table
- Accessing Data on a Remote Server
- SQL Query help needed..
- Checking when the the last time a table was up dated
- transaction log backups
- BCP for xml
- deleting table is possible?
- Query to search the field in database
- checking date greater then today
- make cells a column
- Subquery to return Max Date of field with same Id
- Multiply 2 fields then SUM?
- Newbie
- Howto check for Database BCNF violations?
- Planning Capacity planning
- Aggragate by date time
- adding results from 2 tables
- Problem writing T-SQL function - gives error 170
- Using Microsoft Analysis Services with ORACLE
- SQL Server connects only with admin rights
- Space Available information
- Subquery returned more than 1 value.
- Can't Start MS SQL 2005 Service
- delete procedure
- Copy a nvarchar field to a date field?
- Write a report to text file, where is the option???
- How to send an email using msdb.dbo.sp_send_dbmail without a profile name?
- Select first and last row data for each group in SQL 2000
- Catch a select and execute a different one instead
- Selecting a distinct car with the lowest cost and displaying just one owner.
- Power Outage SQL SERVER 2008 FAILOVER CLSUTER ON Windows Server 2008 r2
- date interval help
- how to check if picklist is used in other teble
- Weird Case Then problem
- Schedule SQL query
- efficiency question
- SQL-Script to modify data
- SQL Query Help
- days count
- call stored procedure
- join between two tables in different databases
- Uninstall of SQL Server 2008 on Windows XP fails with null parameter sddlForm
- x64 2005 installation fails
- Tricky data import - suggestions
- urgent - help help help
- how to fetch records
- Job notification
- is transaction in that case enought ?
- insert into a timestamp column
- tree in database - I can't make a function
- Simple (complicated to me) SQL Query with SUM
- Stored Procs and linked servers
- how to connect two sql servers
- Updating a Datatable Using an Excel Spreadsheet
- Linked Server woes (Login timeout expired)
- Combining multiple tables into one
- SProc results as parameters to 2nd SProc
- What am I missing
- view link if a document is there,else don't view it
- Creating a complicated View
- Problems in developing ERD for inventory system
- No Of Record return form Stored Procedure is Not Consistent
- SQL Database Data Type problem
- Insert data into a table from another table
- Database design with MVC framework
- Database in "suspect" mode (SQL Server Management Studio 2005)
- SQL 6.5 Backup
- Help with sql server query
- Updation in table
- SQL 2008 Replication - Subscriber limit?
- Access query to View convertion
- how to get current date with no time
- Stored Procedure
- READ COMMITTED vs. READ UNCOMMITTED - educate me
- How do I change the NEXT USED filegroup on a partition scheme?
- Records are not saved in a XMLMSSQL file
- Stored Procedure vs. UDF vs. View vs. Computed Column
- connection to another sql server
- Building a invoice number SP in MS-SQL
- Distributed Transaction
- sql query help ++
- Conversion of JBase files to RDBMS tables(MSSQL)
- table structure - Friends
- read images from database and write to filesystem
- call store procedure from trigger
- Hello! Activating a product group, if number of products for sale are greater than 0
- NOT IN slows query down the first time but subsequent times
- Linked Table error from Access 2003 to SQL Server 2000 database
- Custom Date Key???
- How to Improve performance of SSRS report?
- Need query help: price change
- Help on inefficent SQL query
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.