View Full Version : Microsoft SQL Server
- Upgrade SQL Server 2005 from Developer to Standard
- Deleting records from Excel sheet
- Show reorder Stock
- Cool way to move tables between filegroups
- Alter Table Help
- DTS Workflows and Disabled Steps
- MS SQL Queries on ODBC from Informix
- SSIS: Combine and Control Direction of Flow
- Select minimum with multiple columns from one table joining two others
- Overriding System data types with User-Defined Data Types with the same name.
- Assigning records by percentage
- self join.
- Retrieve ONLY First Picture Record For Each Customer
- Copying data from server to local db
- SQL Query Help
- Dateadd function
- SSRS 2005 Database setup in configuration
- Trigger to update current row
- Maximum number of rows in a Partitioned SQL table
- T-Sql - Compare rows to determine if a column's values are different
- get max month and year from number
- SQL to output specific changing values from audit table
- SQL Server Management Studio - Execution Plan error: "Exception has been thrown by th
- Error when performing a case when task
- DBCC CHECKDB - Consistency Error
- Sync databases manually
- Comparing data of Text columns
- substring ands charindex
- how to get special symbols in sql
- Update database ONLY through the app and avoid back end tampering
- How to Extract Multiple tables using SSIS
- Help viewing calculated and Non calculated measure in SSAS 2008
- SQL query help
- TSQL 2008 Microsoft Coding Best Practice Guidelines
- update query... help
- Pricing matrix in a database
- backing up a DB that is made up of multiple files
- Pivoting data
- How to view sysdiagrams
- How to define our own format for our field in database programming
- Suggestions? - SSIS export then import data from stored procedure
- count problem
- Server 2008 R2 with SQL 2008 SP2 Encryption
- Select minimum from one table joining another...
- write a sql select
- How to sum up datediff result into one?
- T-SQL or ISO
- Different ways to insert multiple rows at one go.
- View life cycle
- uniqueidentifier and RowGuid for one click unsubscribe
- DB latency creation
- ALter Queries
- "The maximum size of a row is 8kb?"
- Sql Query for top 15 records, 1 per category
- Unioning Two Tables and Selection Only Top 'n' Records
- Bulk insert from non-delimited file
- Exporting data from SQL Server to another using BCP (character conversion problems)
- MSSQLSERVER version error in windows event viewer
- Backup and restore issue (complex)
- I think I just reproduced a SQL Memory Leak
- backing up large pre-grown DB's
- how to add all constraints and DB schema from physical table to Temp Table
- 2008 sqlexpress and sql server developer edition coexist?
- 1 to 5 rating between Intermediate and Senior SQL Developer
- Join performances, when is each join best.
- Retry database error
- Grouping query
- 'OR' broke my query
- Can a Table Valued Function also return a flag?
- SSRS Page Break
- Profiler Trace showing "Testing Connection..." every 3 milliseconds
- Elevate warnings to errors
- DB restore requires Identity reseed?
- SQL Query to calculate variance?
- bcp and identities
- Query Oracle vs SQL Server
- Restore db with less files
- insertion in a table by deleting records from another table.
- to select nth row
- XML parsing|sp performance
- Database stuck In Recovery
- Transactional replication failing
- How to concatenate string with variable
- MS Access 2007 and SqlServer 2008 express
- SSRS 2008 Basic Authentication - HTTP 401 error on preview in Report Builder 2.0
- Group By Help
- Updating table from excel sheet
- User cant connect to database
- SSRS 2008 Report builder not showing primary key columns in table
- Problem creating a (simple) date query
- Resource Database
- problem with dates
- Problem w/ Charindex and Reverse
- SQL join problem
- Python over Powershell?
- Unable to setup sql 2008 sp2
- migrating password protected excel file
- LazyWriter: warning, no free buffers found.
- transform data file based on field value
- Function to Prefix Escape character to special charcater
- Join syntax
- Checking Active DBs
- Moving the Cluster Quorum to a new drive
- Removing offsetting records from table
- Distribution server crash
- any idea what generates this SQL?
- Urgent Help Needed
- tempDB.mdf grows unexpectedly
- Can this be done without using a cursor?
- different column depending on other columns
- UPDATE with CASE Not Working
- Internal representation of DATETIME (SQL 2005)
- Clustered SQL 2005 to SQL 2008 upgrade
- Users Creating queries in sql
- Query to identifying parent and child tables
- Problem with Last funtion of access in Sql server
- SQL within SQL
- Exporting data from a table in SQL Server to Excel...
- [SSRS 2008] Insert Blank Rows
- [SQLS 2008] SP Fast When Run Direct, Slow As Job
- So what makes for a GOOD database developer?
- bcp/bulk insert question
- Is it new in 2k8?
- lock pages in memory error pls help
- Calculations in select statement
- Retrieve used queries
- identifying duplicate by comparison
- Fuzzy Search
- Programatically save SSRS report to Excel and passing Parameters
- Help Need Urgent
- Restore databse Problem
- Import data from csv to a table in sql server db
- [SQLS 2008] Query For Database Object Names
- Problem with Self Join
- Triggers, Stored Procedures, & MS Access UI's
- Help formatting a variable's contents for a SQL Select statement
- 5 day expired query
- Textfield mismatching order
- Error when 2 same key names on 2 same column names in different tabels
- IIS and SQLServer Coexisting
- Database connectivity in VBA Excel 2007
- how cani improve the scope of this project?
- Backup Error
- Need som help on joining
- INSERT INTO -action with a constraint...??? Help?
- Outputting data to csv file
- What is the best method for backup and restore VLDB and auto-delete data from the bac
- Group By
- New Task today ( batch job using osql for multiple password change)
- Pivot table for non aggregate table
- Join table design
- Reporting Services Excel Unreadable
- Need help writing a query to display all records
- Proximity Search Query - HELP!!!
- Problem in stored procedure
- Select Convert To MM-DD
- Please Help! Im badly stuck in this complicated query
- How to solve the NULL value problem?
- DB experts Plz help me
- How to connect ms sql with java
- Casting Varchar to Time in Sqlserver 2005
- anyone good with batch files to add a SQL Alias programmatically? (I'm 95% there)
- need help in creating procedure
- Update Trigger Help . ( table structure & insert included)
- importing .mdb table
- Version Control System - Database Records in a Course scenario
- How to make tables in a schema as views with readonly permission
- Merge Replication filteration
- Vpn
- backup/truncate ?
- How to query .DAT filedata through SQL server
- this query can be converted into CTE or not?
- Delete trigger.
- Two Design Decisions
- DOS Attacks
- Sum With Records Displayed?
- Using Between Condition With Multiple Tables?
- setting up two copies of the same database with SQL server 2008
- Error: Initializing SQL Server Reconcilier has failed. Try again
- Problem Restoring Backup on Different Machine
- Query running slow, new to SQL
- providing time scheduling to temporary tables.
- Good idea/Bad idea Hosting web and db in same place
- Urgent Help required in procedure
- Database Compatibility issue
- Login falied for user(null)
- SQL Query
- SQL 2008 Mirroring running out of disk space due to transaction logs
- is this a useless index? (on a bit field, including pk-indentity)
- help needed!
- Text to BLOB
- Import data from Microsoft Excel to Microsoft SQL Server 2005
- storing Byte Array in SQL 2005 size problem
- SQL Server Reporting Services sucks because...
- Convert INT and LTRIM not working?
- Transactional Replication Subscriber is unable to catchup after 2 days
- choice of clustered index
- How to do UNPIVOT with dynamic column names within a FUNCTION
- User defined aggregate function clr
- Strange SP Inconsistent Performance Issue
- Am I a SQL snob?
- partitioning data using the Schema?
- How to fix suspect pages
- Enterprise manager|space available
- SQL Issue
- What to do with DBF database?
- SQL Mail Server With Outlook
- Query Help
- creating multiple records with one column changed
- COunt how many kinds of Text
- Trigger on view?
- where do i begin?
- Working with dates and weeks...?
- Toad for MS-SQL and SQL Magazine - Are they good choices??
- Get the file path
- Create range from list of numbers
- Working with dates and updates... Help, again?
- desired dates type
- SSIS zip file
- SQL 2008 - Replication
- SQL help? INSERT INTO with subquery...
- SQL starter question(s)
- XQuery Return All Occurrences of an ellement
- A question about data in view
- Hypothetical Indexes: What I know and don't.
- Measurement And Unit Of Value
- SSIS MSDB Access - alternative to viewing and deleting SSIS Packages
- calculating sum.
- Advance auditing in SQL server 2008
- SQL Server Memory Usage - Server Locks Up
- converting column feild values in a table to column names in other table
- Storing Document in Sql, plz name the Procedure steps
- SQL Server 2005 Replication error Immergency
- Retrieval of formated data
- how to import data from excel file to sqlserver database
- Selecting records when a matching record not in another file
- SQL Trace
- moving data from SQL Server to linux/DB2 in client server mode
- storage folder not visible in Management Studio
- SQL Server 2005 can't remove the publication - error: (Microsoft SQL Server, Error: 1
- how to get optimal driver performance for a DB?
- SSRS Report History today() vs Execution time
- Stored Procedure and If Statements
- Is it possible to perform four different criterias in the same join?
- Can you backup/restore schema only?
- IDENTITY Crisis: Converting an identity column to non-integer datatype
- table partitioning primary key question
- Plz Help:Which Database tool support me to Store Documents and Videos??
- Is there any way to group databases in custom folders in SSMS?
- Restrict Update if Seat greater than Invites
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.