View Full Version : answers

Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 [18] 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
  1. Group By Query Help
  2. Converting Traceid issue
  3. How to avoid cursors
  4. Create New Table advice
  5. page life expectancy=0
  6. Urgent opening for dwh informatica
  7. sql server efficient
  8. LDAP interface to SQL Server 2000
  9. Installer differences - SQL2K under W2K versys W2K3
  10. Error using UPDATE statement
  11. sqlservr.exe memory usage
  12. Script SQL 2005 database to individual files?
  13. Send 2 SQL statements using Integrated services
  14. Automating record selection parameters
  15. Query Analyzer and Profiler won't start from EM Tools menu
  16. Simple SQL Distinct...!?
  17. Import/Restore/Transfer, Only Updated/Changed/New Values Between Two SQL Server Over Dialup Connection.
  18. workgroup information file does not exist
  19. workgroup information file does not exist
  20. tools for analysis relations
  21. Announcing Yellowfin BI reporting Version 2.4 release now available.
  22. International Settings for SQL 2000
  23. advice
  24. MS SQL export / import data
  25. DELETE FROM - Somethings not right
  26. unknown column 'state' in field list
  27. Detroit SQL Server User Group.
  28. Question about Joining 2 tables??
  29. Fields in my tables are disappearing!
  30. Subquery -> slowness
  31. <ANNOUNCE>Building XML Workflow Applications
  32. log/log10 functions truncate my resultset
  33. median query without using function
  34. scheduled dts suspends...
  35. Webserver request invalid query
  36. Linked Server SQL to SQL
  37. linked data bases
  38. long SQL lines for osql
  39. copy a table
  40. How to create SELECT?
  41. Script needed to edit open objects in Sybase
  42. SQL command needed to edit table data
  43. Joing Multiple Columns
  44. Virtual Servers cannot connect to host PC Database
  45. Tricky SQL question
  46. Setting a value for a boolean
  47. export SQLServer2000 DB to Access
  48. UPDATE Statement Involving Tables in Different Databases
  49. select statement returns null in stored proc
  50. Backup users
  51. how to call a stored procedure in an insert command
  52. Merge Replication
  53. How to Determine the unique IDs of duplicated records
  54. Order By
  55. normalization
  56. Lock database to update
  57. DTS Rounding problem
  58. ms sql server
  59. Script to reverse engineering schema
  60. [SQL2000] permissions to use view based on tables from many databases
  61. How to tell how many times an SQL executed in v7 or v2000?
  62. How to tell how many times an SQL executed in v7 or v2000?
  63. Synchronize data between 2 instances of SQL Server Express?
  64. Table spool/Lazy spool question
  65. Query analyzer error message - Cannot generate SSPI context
  66. full text search on doc files
  67. Trigger problem no rowlevel support, please help!
  68. Connecting to SQL server
  69. DB shrinks without request
  70. Loop / Cursor help
  71. Getting closest matching values
  72. Returning Values from a Dynamic SQL
  73. truncating
  74. sql server and membership provider
  75. Embedded Queries?
  76. Store Procedure Query
  77. Tough Sql Query
  78. Can SQL Server work with a Paradox table?
  79. Formula problem
  80. Stored procedures, linked servers, and cursors
  81. Business-to-Business Data Integration in a SOA World
  82. sql query help join
  83. with nolock problem
  84. what are cursors in sql???
  85. SQL query help
  86. SQL Server 2000 conferences
  87. How to correctly update a table which values can be either inserted/updated/deleted on update?
  88. IT tests. SQL, XML, ASP.NET, C, C++, C#, VB.NET, HTML...
  89. Splitting directory and file name
  90. Torn page problem
  91. Recovery model problem; db properities
  92. torn page detection and auto shrink: performance?
  93. Relational Database
  94. Last Year Month to Date Function
  95. Transaction isolation levels
  96. SQL Server float data type
  97. Query Help with Update statement, thanks!
  98. Record Counter
  99. limit resources per user
  100. very slow query (select count(*) from table)
  101. More efficient than LEFT JOIN
  102. Client Web Browser & Remote SQL Script Error?
  103. installing apache, php5 and mysql 4
  104. About Join OR Where
  105. Query Help!
  106. concatenate two fields in a view?
  107. Importing Access database into Sql Server Express
  108. Capturing Mysterious Truncation/deletion of a table
  109. Need Senior SQL DBA
  110. Administration tool web for SQLserver database
  111. IsNull and aggregate functions
  112. Slightly off-topic topic
  113. Select command with multiple tables
  114. select another column where max
  115. fetching unique pins...
  116. Indexing issue, inconsistent performance
  117. sp_executesql question
  118. Java method invocation support
  119. Job Executes Only First Step
  120. Dynamic query help SQL 2005
  121. Design Tool
  122. Errors on DBCC SHRINKFILE(2)
  123. Resolving duplicates entries in table among 10 databases
  124. Why the log file is growing too much upon running nested stored procedures (MS SQL 2K)
  125. Non-English Characters
  126. SQL Server 2005 - Save tran save point name case sensitive?
  127. SQL Sever 2005 - Full Text FormsOf Inflectional
  128. BACKUP LOG cannot be performed because there is no current database backup
  129. Can't reference a Group Field in Footer SUM expression!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  130. How to configure a JBOD disk array (PowerVault) for Performance
  131. Transaction reading from Linked Server without DTC? (Isolation Level?)
  132. Show Server Trace Missing in SQL Management Studio?
  133. SQL Server 2K Linked Access 97 Server not working
  134. Tuning sql in SQL Sever 2005 using the dta utility
  135. 100% CPU Usage (Part 2)
  136. Removing Duplicates rows from Inner Join
  137. Removing Duplicates rows from Inner Join
  138. Testing UDFs with TSQLUnit
  139. How do I NTH Select in SQL????
  140. Interview Questions Feb 09, 2006
  141. Design idea Help for Database
  142. Rollback transaction after connection lost
  143. Performance Problem
  144. Deadlock within select?
  145. interdatabase trigger possible??
  146. Ms Sql Blob ??
  147. SQL question
  148. Help with tricky T-SQL
  149. Class does not support aggregation
  150. REPLACE function doesn't work with null-bytes
  151. Why does SQL2005 automatically insert TOP 100 PERCENT in views?
  152. one for the SQL experts - dare I say TRICKY SQL!
  153. Great Job Board
  154. Full Recovery Model - log doesn't grow?
  155. Best Job Search Site...
  156. Searching/Estracting numerical data
  157. Any T-SQL advice?
  158. how do i replace a substring in sqlserver ?
  159. how do we tune a large sql query
  160. (Hopefully) Easy SQL 6.5 Question - Getting Table Structure
  161. How to go around the SQL Server 2005 User Instance problem when using Remote Desktop
  162. SQL Server DB installation
  163. ms sql equivalent of this oracle
  164. I can't find sql server on my computer
  165. can you tell me why this causes a deadlock?
  166. Developers needed for Healthcare software
  167. MS SQL 2000 SP Query Plan
  168. MS SQL 2000 SP Query Plan
  169. sql server and access
  170. Interview Questions Feb 03 2006
  171. Trigger not firing on update
  172. Read, modify table (locking) question
  173. Database views hierarchy
  174. Performance and data structure question
  175. perf
  176. Deleteing large bulks of data
  177. Int to char conversion
  178. T-sql
  179. Table variables
  180. Interview Questions Feb 01 2006
  181. Monthly date range substitution
  182. Getting the database name in Server-Side trace event
  183. SQL Server 2005: setup problem
  184. SQL Consultant, Minneapollis,MN
  185. Replace chars in any field of a table
  186. Session
  187. do I need a DBA for SQL Server?
  188. Invalid Data for 'Numeric' when EXEC returns empty row
  189. update statement not to fire trigger
  190. help
  191. Set SP parameter
  192. how to restrict data insertion upto 50 MB in a table
  193. URGENT : Help -1
  194. Get Data From CSV to MS SQL DB
  195. Msg 107, Level 16, State 2, Line 1
  196. front end options for entering data into an oracle database
  197. Cant seem to find IUSR_MachineName in users using SQLEXPRESS 2005
  198. Workstation date
  199. timezones in select statement
  200. Connection to sql server 2000
  201. Interview Questions Feb 01 2006
  202. getting rid of trailing zeroes from a decimal output
  203. Database normalization
  204. moving tables
  205. date + 1 ???
  206. UPDATE on a column with a set default
  207. T-SQL ROUND(decimal, int) vs C# Round(Decimal, Int32)
  208. Rqst for Inventory Database Best Practices
  209. SQL Server Interview Questions Jan 30 2006
  210. IT tests. SQL, C, C++, XML, HTML, .NET...
  211. Example of binary data type in SQL Server
  212. SQL Server client tools
  213. How to find first not null value in column
  214. What is the right datatype to store Hours up to the minute precision?
  215. Data Connections for SQL Server Express in Visual Studio Express
  216. MS Access Frontend for remote sql server
  217. SQL Server 2000 Audit for login
  218. Database instance
  219. Views vs Stored Procedures, whats the difference?
  220. New bie
  221. New bie
  222. Formula Parsing
  223. Query out an xml element from a field containing xml data
  224. Problem Building Script with Int
  225. select cast help needed
  226. Truncate table if exists
  227. Scalability questions for extended stored procedure
  228. Insert/Update with dynamic database name
  229. ASC Result Set with Nulls at the bottom
  230. Can i debug/watch on the trigger's INSERTED and DELETED records/values?
  231. Conditional execution of DTS package task
  232. Help creating a SELECT statement for "today"
  233. SQL Server does not exist or access denied
  234. SQL Server does not exist or access denied
  235. Difficult SQL Statment
  236. Question on SQL Server 2000 - 2005
  237. export sqlserver database to ms-access by sql script
  238. configuration/load balancing
  239. Importing from Oracle 10g
  240. Ignore Some Errors
  241. Trigger?
  242. Outer Join problem
  243. ORDER BY in VIEW not working
  244. Commit Transaction Gets Deleted - Unable to save SP
  245. Joining tables in different databases
  246. SQL Server could not configure 'Server\Instance' as a Distributor.
  247. Web based sql server connection
  248. 6.5 to 2000 upgrade problems
  249. Default value: ISNULL()
  250. SQL2K5 Database Engine Tuning Advisor
  251. Linked Server to SQL-Server Question
  252. Connections to SQL server are slow on one machine
  253. ODBC Connection to a linked database
  254. Urgent rek
  255. Want to be able to create or view database diagrams
  256. Conditional Column Name On Insert
  257. Linked Server setup - SQL 2005 RTM
  258. Reporting Services
  259. Question about converting bigint field to int field
  260. Link to DB2
  261. remote permissions
  262. Need Junior SQL Server DBA in McLean, VA ASAP
  263. Odd connection problem (proxy + internal)
  264. How can I update several (not all) fields in table A from table B for replication?
  265. Server Feedback
  266. need help
  267. Failed KB909544 installation
  268. This query must be easy but need help
  269. Advanced Data Shaping - Multiple Relate clause
  270. Querying joined tables with 0 results
  271. Help wanted msaccess PIVOT-query --> MS-SQL view/sp
  272. Can I use stored procedures with PHP via ODBC bridge?
  273. Problem ith DTS and delimited file with empty last column
  274. how to get tables involved in constraint
  275. splitting a comma seperated column into multiple rows
  276. DTS Failed To Run
  277. Audit Logon / Audit Logoff problem with SQL 2K
  278. To Create Unique table names and access them in code...
  279. ODBC in Stored Procedure
  280. Variabe Error
  281. system information about indexes
  282. Facing Problem
  283. database migration
  284. osql batch processing without -i
  285. Truncated Decimals
  286. Unable to Update Table Even After Dropping Constraint
  287. question on inserting a record on sql server with identity column as key
  288. Does SQL Server save any metadata in registry or home folder?
  289. Is it a complex sql query?
  290. problem with filtering data
  291. isql / osql / Windows XP / disable "Automatic ANSI to OEM conversion"
  292. Seeking correct syntax to pass a NULL value for a datetime field from an asp page to SQL
  293. Deadlocks, why?
  294. Baffled! Can't figure out how to do this query. Is it even possible?
  295. Full-text search across multiple tables
  296. SQL QUERY HELP
  297. Why would adding dbo. cause my function to run forever?
  298. Requirement for- ATG Dynamo Developer at Minneapolis, MN
  299. Requirement for- ATG Dynamo Developer at Minneapolis, MN
  300. SQL Query
  301. Advanced Sql-Shape Query - Help
  302. Job oppurnity
  303. NEW @ DTS
  304. Searching a datetime field by time
  305. Searching for a partial match in a varchar field
  306. mesage in Sql Server 2000 log
  307. selecting only numeric data from a string
  308. Convert Text to Int
  309. Store procedures
  310. Record count in all tables
  311. show stored procedure
  312. show stored procedure
  313. Simple SQL query question
  314. SqlCE Synchronization Issue: Native Error 29006, The process could not deliver the snapshot to the Subscriber
  315. change home and data directories
  316. Can LOG PI or Log Explorer recover deleted records BEFORE
  317. Requirement for peoplesoft CRM at SFO,CA
  318. bcp into view with derived column
  319. View Permision sql 2000
  320. Preventing the message 'Duplicate key was ignored'
  321. standard sql: update multiple rows.
  322. Adding column via sp_repladdcolumn...
  323. Unicode Conversion
  324. Testing (Please Ignore this message)
  325. Hot requirements at Spectraforce Technologies Inc.
  326. vs MySQL
  327. Experts Profiels
  328. Browser as Front-End
  329. Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
  330. How to omit Schema name when referrring to Tables?
  331. How to mit the Schema name when referrring to Tables?
  332. nested joins - joining one table to another multiple times
  333. Combining 3 SQL statements
  334. Combining 3 SQL statements
  335. Cursor loop is broken
  336. Cursor loop is broken
  337. Cursor loop is broken
  338. Environment and Application Domain between ASP.NET & SQL Server
  339. Help
  340. Default Template for User Defined Function
  341. Is there any performance loss if i have all my columns preceeded with dbo.Tablename?
  342. QUESTION: Exporting data into SQL statements
  343. Problems upgrading to 2005 Trial from 2000 Standard Edition
  344. SQL Server 2000 License Query
  345. *Very Urgent Rek - SQL Server DBA from Direct Client: Full time* @ New Jersey
  346. How to get code of stored procedures ?
  347. "owner name" cannot be omitted in sql 2005 querries?
  348. SQL Distinct Value and Order by some Field......
  349. Configuration file
  350. SQL Server and Workgroup networks, how?
  351. managing users
  352. Connection to Oracle sometimes hangs
  353. Stuck - Cant figure out a Query for this situation
  354. SQL Query question
  355. SQL Query Question - JOIN or not to JOIN
  356. Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
  357. Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions
  358. No ending Rebuild master
  359. XML Data Processing
  360. Simple SQl question
  361. How to know the User who disabled a Job??
  362. XML data feed
  363. Deadlock on Update using temp table
  364. Ms Sql Query
  365. (Can't get) Media for SQL Server 2005
  366. Index for username/password
  367. Microsoft Distributed Blank CDs for Sqlserver 2005 and MSDN Library at Launch??
  368. dateformat is ignored
  369. Backup failed: Operating system error 112(error not found).
  370. Moving SQL Server to a new drive
  371. Need help with a join
  372. Is "name" a keyword?
  373. Oracle/MS SQL Interface
  374. Best way to interface with Oracle
  375. How many CALs for a web page?
  376. view with auto_increment field
  377. Visual Query Builder with unions and sub-queries
  378. Createa table like a existing table?
  379. SQL Server 2000 Installation error
  380. Synchronising/replicating access with sql server
  381. Synchronising with remote server
  382. C++ and SQL Server programming
  383. Temp Table Faster?
  384. SQL Server Std vs Small Business Server 2003
  385. Stored Procedure only works in when app uses trusted security
  386. How to execute a "batch file" using SQL Server 2005?
  387. Stuck with sorting columns
  388. Export SPs?
  389. Export SPs?
  390. Referential Integrity
  391. Business Analyst with i2
  392. intead of update/insert trigger on view question
  393. MS OLE DB for ODBC with Oracle ODBC source headaches
  394. Index on two columns doesn't allow NULL in both - HELP!
  395. How to schedule a stored procedure
  396. Breaking apart Column into rows
  397. Making a view that shows the results of several different queries.
  398. Where the !@?!@ is my Stored Procedure?
  399. Calculating 'time difference' between two records....
  400. LDIFDE csv import to SQL - looking for Ideas
  401. OLE DB Provider for ODBC and Oracle
  402. How to Restore an Archived Filegroup on Another Server
  403. operand type clash
  404. How do I use SELECT on a column with datatype TEXT?
  405. one transaction log per filegroup?
  406. TransferText dropping fractions
  407. SQL/ASP - Timout Problem w/ Particular Statement
  408. Update Web Form
  409. time format error
  410. arbitrarily delete transaction log
  411. Size of data-set passed back by a select
  412. Store Multi-Select values in an image data type?
  413. Lost Data
  414. Periodic run of stored procedure
  415. changing collations
  416. SQL 2005 Management Studio: Line Numbers in Query Window.
  417. Can't edit Linked Server General Properties after saving
  418. NetSearch the Business Intelligence Search Engine
  419. RESTORE an Old Filegroup into an UpTodate Database
  420. sqlagent.out
  421. Connection pooling
  422. trigger help
  423. database maintenace Plan location
  424. Maximum UNION statements in a query
  425. How to pass table names to a Stored procedure
  426. Concurrent users
  427. Reacting to DB events
  428. MS-DTC / SQL Server 2000
  429. Cannot resolve collation conflict for equal to operation.
  430. Multiple Apps on System DSN on Server from One PC
  431. Regarding table Order
  432. SQL Best Practices Analyzer Rule: Use of Schema Qualified Tables/Views
  433. Can't connect to Oracle Dbase with SQL Server 2005 Express
  434. SQL Server Express Edition vs MSDE
  435. Converting INT datatype to BIGINT datatype
  436. Grouping Dates
  437. Stored Procedure to change default
  438. links for fields
  439. Temp tables vs table variables
  440. Access to SQL Server
  441. Indexing a View
  442. Log shipping and DTS pakages
  443. Fuego, Tomcat, JDBC & SQL Server 2000
  444. Problem in Accessing SQL Server Views from Oracle Using TG4MSQL(Transparent gateway Connectivity)
  445. trigger simple question
  446. un-registering a server
  447. Question: Recording login access to SQL Database
  448. Error when setting up ODBC Connection
  449. Performance monitors
  450. Help with phoneBook db design
  451. Text datatype as local variables in Trigger
  452. Migrating to SQL 2003
  453. Adding Time Totals in SQL
  454. Why I can't drop a table
  455. query plan in clear text
  456. How to copy data from backup or data files to new SQL installation?
  457. dynamically trasnpose rows into columns
  458. Sync to databases nightly with BLOB data
  459. Strange FK relationship - how, and is it right?
  460. maintenace plan question please
  461. Deadlocks and Parallel Query Processing
  462. SQL Debugging Tool
  463. Export Data from SQL Enterprise to SQL Express 2005
  464. *=
  465. 1 question about psql table
  466. Please help the performance issue.
  467. When Linking A Server; Only System Tables Are Accessible!
  468. Database security (crosspost)
  469. Database security
  470. datetime
  471. Help with blocking on querying two joined tables
  472. XOR and foreign key constraints
  473. Toad & S2K5
  474. Transactional Replication
  475. SQL relationships and identities
  476. listing SQL Server databases on a network
  477. Disabling Constraint for Bulk Loading
  478. How to Load SpreadSheet in AxSpreadSheet object in VB.NET or C#.NET
  479. Regarding Index Rebuilding
  480. Help with SQL Query !
  481. Role/Person Table?
  482. Should I worry
  483. Concatenation Limits in SQL Server 2000?
  484. Reporting Services
  485. fix for long running transaction problem
  486. Help with select query
  487. Lock table problem
  488. Need Material for "Sybase to Sql Server Migration"
  489. Replication of several satellites into one central db: adding location key ?
  490. Query Optimization: CPU speed or Logical Reads better?
  491. Query Optimization: CPU speed or Logical Reads better?
  492. Using muliple smaller SPs and Functions better than using 1 big SP?
  493. Nested Nodes in XML from a table
  494. Compile/combine the contents of several records.
  495. Is this an efficient way to create a comma string
  496. Excel file import problem
  497. MSE
  498. Get previous record
  499. help with grouping query...
  500. User Loggon Password Changed
  501. 1 SP with dynamic input parameters and multiple rows as the source of the query
  502. Nested Triggers
  503. Getting data from multiple rows into one column
  504. SP and ADO Page Property Not Working Properly
  505. SLEEPING/AWAITING COMMAND question
  506. error handling and bulk insert
  507. Inserting dummy lines and padding
  508. Planning multiple queries
  509. Mini Index?
  510. Select *
  511. cannont create SSPI context (SQL connection problem after 30 minutes)
  512. Databases not showing up in Enterprise Manager
  513. upgrading to SQL 2005
  514. Help needed by deadlock problem
  515. Can REPLICATION on SQL Server 2000 allow dirty reads
  516. 2000 Replication with DB in 65 Compatibility Mode
  517. Application & Database Security Consultant
  518. Can I install VS.net 2005 / VS.net 2002 / SQL 2005 / SQL 2000 in one PC win2000 sp4?
  519. Why upgrade to MS SQL Server (be it 2000 or 2005) from Access (say, 97)?
  520. Extracting and joining header from denormalized table
  521. HELP: Strange Blocking Performance Problem with Simultaneous Queries
  522. Indexing and Queries
  523. problem creating DTS package
  524. splitting a string
  525. Help needed with query syntax
  526. Clustered versus Create table on high speed FILEGROUP
  527. big log file
  528. String case problem
  529. accessing mssql in linux through c++ code
  530. Index Design Recommendation - Examine Column Uniqueness
  531. Index Design Recommendation - Examine Column Uniqueness
  532. PAGEIOLATCH is a lead blocker
  533. Query question
  534. SQL-SERVER DBA- National Institutes of Health- Bethesda,Md.
  535. Monitoring replication
  536. Wildcards On Columns?
  537. Show owner of database
  538. Temp Table and SP Advise
  539. Subtracting two columns from diff tables
  540. LOAD .SQL file
  541. Regarding BCP utility
  542. STORED PROCEDURE - passing table name as a parameter
  543. Passing DateDiff rather than Actual Dates as Parameters
  544. log shipping
  545. Problem with spid by sp_who
  546. Format() Function in MS SQL
  547. Select into / Linked Server / Missing IDENTITY attribute
  548. SQL errors, trapping in Server Agent
  549. multi-field primary key
  550. Bulk Import with header in text file