View Full Version : Microsoft SQL Server
- do you have a dba checklist?
- Is it possible to dynamically add duplicate rows to a set of data?
- Point in Polygon function using parameter values not a table
- SSIS problem:Package connection error to DB2 host
- Login falied for user(null)
- Displaying previous monthly totals
- Maximum Length of a SQL Query
- what is the alternative of exec in function
- SQL auditing
- Cancelling purchase orders
- What is the most efficient and professional model?
- new line
- Query doubt
- monitoring user activity
- looking for VLDB resources (books / sites)
- Query Analyzer; transactions and temp tables
- School Work(regarding Case)
- Data Segregation in SQL Server
- Is using master.dbo.spt_values dangerous?
- DisplayTop2RowsPerType
- Join in SQL
- Non clustered index performance
- Select shop sales which intersect
- Update or insert of view or function 'V1' failed because it contains a derived or con
- Query Problem Need help
- usage of MERGE
- Top2rowsInGroup
- copyfiles from remote systems using xp_cmdshell
- time intervals - set operation
- Convert VarChar to DateTime
- getdate function
- Update Efficiency / Method Question
- Identify record in period
- sql view
- sql storedprocedure problem
- Calculating active periods
- 1st year IT student - HELP with concept
- changing structure of the table
- How to reset lost sql sa password?
- Add a total to a query
- Query with date
- Cannot create a row of size 8069 which is greater than the allowable maximum of 8060.
- Tempdb
- composite constraint
- Something error
- Security for sql server 2008 ..on public server
- Foreign key error
- generate AccNo in SQL(select min AccNo from table where AccNo>300000000
- Subquesy or Inner Join?
- Sql server 2008 failover cluster installation
- getting max(date) in a view
- cannot restore database
- Unique Sequential Numbers
- Converting ole objects and packages to native format
- Help, SQL Multiple Pivot
- SQL Server DeadLock problem
- Data manipulation in SQL or c-sharp ?
- MS support vs. security updates
- Change the DSV of a dimension
- Convert correlated subqery to join?
- install sql server 2005 express
- EXEC statement not returning data when select xml nodes function is used
- solve for error
- Should ERP databases be stored on clouds?
- DBNETlib preloginhandshake error
- "Subquery returned more than one result" when it's desired
- error in SQL
- CROSS APPLY a FREETEXTTABLE
- Adding Check for Existence of File
- Converting a comma-separated list to new rows...
- need help with a query
- Stored procedure using vba and ado command object or access pass through
- upgrade to new version
- Need Help in Databse design for "Bus Route System"
- Can a SQL Server 2008 stored procedure import a Sharepoint list as input parameters?
- Inserting dynamic rows, calendar table?
- Table and filegroup question / confirmation
- Summed Daily totals giving different amounts from Monthly totals
- Can I select multi recs from single recs without cursor?
- Query question
- [help] INNER JOIN QUESTION
- BI Dev as a Job
- Combining two queries?
- Regularizing time intervals
- Schema Name is changing automatically
- VLDB, Merge Replication, is it ok to use GUID as PK?
- Data conversion error
- Getting started with MS SQL 2k8
- can a sql deadlock cause db connection problems?
- More elegant way to write this w/ CTE's?
- Replace Double Space with Single Space in data
- Changing Database collation
- calculating the size required for backup of database
- Consume Corticon Web Service
- why sql server don't have same problem,even same version
- Needs totals from two unrelated tables
- Search
- SQL Triggers for Multi-Row Operations
- [SQL2008] User Defined DB Roles and Stored Procedure Permissions
- Cannot upgrade SQL 2005 SP2 to SP3
- Aggregate Incorrect with INNER JOIN
- SQL Function slow improvement
- sqlcmd fine, but bcp can't connect
- Subtracting records from the same column
- Instead of Delete
- Copying NTEXT data from one record to another
- Error accessing the site
- SSAS Calendar Week commencing with split at month
- backup database from server pc to client pc
- Error Using CASE statment in SQL Server 2008
- Question on Efficiency of Subquery
- Writing values back to a database
- unable to run stored procedure using data from linked server via VBA
- Reterive timestamp data
- Identity
- Database migration
- MSSQL Database Security issue
- oracle query required
- table Script with Data
- Change Carrier
- display order when table is viewed?
- Performance and the size of tables
- How to show more verbose information when running a ddl sql script in "Microsoft SQL
- Merging Databases
- SQL Query and SSRS Help
- Problem with database copy
- Updated View from Stored Procedure
- Restoring DB from MSSQL 2008 to 2005
- sqlserver , restore , Backup
- Cannot initialize MSDAORA error
- Inserting a field from one DB to another.
- How to get SQL logshipped databases concurrent?
- Who's starting the DTS Package (SQL 2005)
- how to add column values?
- Need help in creating a BankERP database
- Slow SQL Server
- how can I make fulltext search
- XML - IIS SQL Server 2008 support ?
- About Exam
- Replication: problem of connecting interruption
- User Mapping
- INSERT INTO and UNION
- Replication Set up
- IF EXISTS syntax quick question / Agent Job
- Msg 213 Column name or number of supplied values does not match table definition
- How to Get Time Portion From DateTime Field
- export database as .mdb
- Date in tsql
- how to code TSQL?
- Replication switching integer PK to UniqueID
- Duplicate record Count
- Replace Characters
- How to connect SQL2000 to Oracle 11g
- dynamic mapping in SSIS
- Do I actually need Microsoft SQL server 2005 installed on my PC?
- Data base corruption
- Named Pipes Provider: Could not open a connection to SQL Server
- Server 2000 Automatic Number issue
- Help with Database Design
- Reusing calculated vales in Analysis Server 2000
- Access to Database Objects
- SQL Server 2K8 backward incompatibities
- Cant see SQL Server with Client ODBC
- invalid query runs anyway
- SQl peformance issue--High disk queues at fault??
- SQL server error 18452
- SSRS 2008-How to autosave the pdf file at server
- Select one column in table 1, if it meets all conditions...
- Index
- Test: Server performance
- Absolutely mystifying bug
- Question regarding T-shirt Database design.
- Help in using joins
- SQL Express Express 2008 Storage Limit
- installing ss2005 standard
- SQL Server 2005 max size/record limit
- Use TABLOCKX to control data export consistency?
- Uniquely identifying who logged-in to the MSSQL Server via Citrix
- finding records within set number of days
- Using SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF option in SQL Server 2000
- How to restor in Ms-Server?
- SQL Server Time out Error
- Getting An Error Message
- SqlWb.exe : The directory name is invalid.
- TSQL for regular expression
- Operand type clash on trigger
- Discrepency's between MDX query and Excel Pivot
- Help with UNION
- Trigger Problem
- Select help - multiple conditions
- Insert code from loop into SQL insert into statement
- data transfer from old sql server databse
- How to get SS2005 to use all cores
- Transaction log backup fails....
- Looking for front end that lets client search existing database and view pdf files
- Efficient subtotalling
- SQL Server - SQLServerCE / Merge Replication Hosting / Licensing / Expected Costs
- Joining complex SQL tables
- Trying to add data
- Query doubt
- How to alert if table grows more than 10000 records
- update the column default (relation)
- DB Mirroring and LogShipping
- Sp_rename or any
- When will the key/value madness end?
- SQL error in Application accessing SQL database
- ODBC Daisy chain
- Use of Temporary Tables Vs Cursors
- Time Dimension: From Months to Days
- Calculated Column not display correctly in SSAS Dimension
- Tracing SQL statements and number of records affected
- latest date using join
- Is my db read or write intensive?
- SSIS (SQL SERVER 2008 R2) parse SQL Query result with delimiter
- SQl Server Reporting Services Aggragrate Function
- Perfmon Memory Performance with Multiple SQL Instances
- dbo.table prefix
- Merge replication-SQL Server 2K - Duplicate rows in MSmerge_XX system table
- Extract a certain sentence / group of words from a string
- Project Server 2007 Database
- Multi-part identifier <alias.column> could not be bound in UPDATE
- More Efficient Inserting of Bulk Data
- logon audit
- Remove Unallocated space & Server level audit
- Connect Using Different Windows account to SQl Server DB
- sql server 2005 suspect database
- Diff b/w select & declare
- New to SQL Server
- help with the SP
- SQL Server status
- What does this indicate ???
- Combining date fields from two tables for complete range of dates
- Faulting application SqlWb.exe
- Need help with SQL Select statement
- Multiple where clause
- Stored Procedure based on user input parameters
- How to become SQL DBA
- DeadLock - analysis, please help
- sql syntax for select duplicate data in same table
- Insert into - combine select and coded field
- Backup database taking unrealistic time
- retrieve ID, possible for script to be too fast?
- How to check MSSQL trace settings
- Sql Server Certificate and symmetric key
- Difference between top with ties and percentage with ties
- Create login via SSMS, defaults to db_owner
- Stored Procedure based on user input
- Load csv data into table
- Help with my first Stored Procedure
- Help with Backup Procedure Step
vBulletin® v3.8.6, Copyright ©2000-2012, Jelsoft Enterprises Ltd.