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. Will this query be optimized for a partitioned view?
  2. Number of foreign keys
  3. Can you add an Index to a table variable?
  4. Identity insert doubt
  5. Get one row from detail/child table
  6. Merged columns in OrderBy
  7. automatic process
  8. generating alter table script
  9. How to obtain just the last record grouped by
  10. stupid... simple question
  11. the most recent date and time
  12. Query too slow! Need some performance enhancing tips!
  13. SQL joins
  14. SQL Server Agent Question
  15. Database Trigger in MSSQL
  16. DB replication
  17. Tricky SELECT and ORDER BY
  18. counting the inserts and updates on a table in a sql server database
  19. How to change TrimTrailingBlanks from No to Yes
  20. DTS Help with Update?
  21. What is a cursor?
  22. question re process id's
  23. Is a subselect possible on a stored procedure
  24. dumbest question of the day: run a simple query and save the results into a text file
  25. MS Sql 2000 vs. Pervasive SQL
  26. Query to get all user tables with columns
  27. Select-into with identity
  28. Kaliedo
  29. Query that returns record that arn't duplicated in another table
  30. User Guest
  31. relationships as a table
  32. table columns storage
  33. Enterprise Manager: defaults lost in import/export
  34. use column alias in another calculation
  35. Help! SQL Collation
  36. combine 2 queries
  37. website hosting
  38. Data update
  39. email being sent, but no message
  40. SELECT and UPDATE in the same query
  41. Update Table
  42. Storing japanese characters
  43. Use TSQL to create a data matrix
  44. Help on DTS and selective dates
  45. Daily Devotion
  46. link to access.mdb
  47. Triggers
  48. Store procedure's debug
  49. MS SQL Server JDBC Driver Type 2 and Driver Type 4 Differences
  50. apology in advance for multiple post re AUDIT TRAIL...
  51. Audit trail..
  52. audit trail...
  53. Audit trail..
  54. Audit trail..
  55. Audit trail..
  56. Audit trail..
  57. Audit trail..
  58. Audit trail..
  59. Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
  60. if..then
  61. Technique for concurrent access?
  62. LIMIT in MS SQL ??!!
  63. sql7\sql200 connectivity
  64. locking and rowid
  65. Executing Script Files From Transact-SQL
  66. audit tables, delete triggers, and asp.net
  67. common UPDATE syntax for SqlServer and Oracle
  68. How to use a value from one recordset in another..?
  69. SUM function with negatives values
  70. good table design...
  71. Join stored procedures?
  72. Data replication from MSSQL to MYSQL
  73. SQL Server 2000 Enterprice Manager Error
  74. Table Rowcount question
  75. Peak During Time Period
  76. Seeking Testing Volunteers W2K MTS/DTC to VMS DECdtm Distributed 2PC Transactions
  77. SQL Delete Syntex
  78. When to use the NOLOCK hint.
  79. SQL 7: One column's value is repeated throughout entire result set
  80. Help Cursor Based Stored Procedure Is Getting Slower and Slower!
  81. Please recommend two good books to master MDX
  82. What's the best SQL book for an intermediate level database programmer?
  83. sql server - not enough storage
  84. Dealing with a null parameter in SP
  85. SQL Server 7 Backup Problems
  86. Error Authentication User Informations
  87. 2-table join where only need one row of second table.
  88. creating a view with columns not in another table
  89. query help: need to return 2nd from top record
  90. Beta testers wanted
  91. Qualified table names
  92. Mysql on different servers
  93. Linking Lookup Tables
  94. Help! Top N in SQL Server?
  95. MS sql server on workgroup not domain.
  96. SQL Server Analysis Services
  97. HowTo Update Date Field
  98. help with showcontig
  99. Alter table weird bug?
  100. Restore Database
  101. Query "hightest value" contents of each "folder"?
  102. Variable Table Name in a Stored Procedure
  103. creating a matching program
  104. Multiple Update with multiple condition
  105. Function to remove accent in string
  106. I found this great little site
  107. Domain vs Local
  108. Urgent; Incorrect Syntax Near Go Help
  109. collation problem
  110. Insert Into..Select Problem
  111. Dual Xeon or Dual P4 for SQL Server?
  112. Passing parameters to action stored procedures using ADO, in Access Project
  113. What is the value of this error?
  114. Transaction Log Auditing
  115. Sql 7
  116. logins
  117. Batch insert 10000 rows at a time and commit
  118. Appropriate Use of READ UNCOMMITTED?
  119. select row values to be column name
  120. SQL6.5 restore
  121. Lost deadlocks
  122. Basic Question on Join
  123. Data Access Pages and SQL-Server
  124. How do I Merge two databases?
  125. Dynamic sql - how to use 'if exists' with variable tables..?
  126. Moving SQL server from one domain to antoher
  127. unique constraint vs unique index in MS SQL 2000
  128. Moving from Accesss97 to SQL Server 2000
  129. Help with SELECT query
  130. Trigger to populate another table.
  131. Selecting current time stamp
  132. add leading zero to date column??
  133. Computed column
  134. SQL Query Help
  135. SQL Server runs out of resources or is it my client application. Handle count = 96k
  136. Calculating Row Size including blobs
  137. Errori SQL
  138. Select from a date range
  139. Adding Order by on clustered index
  140. Use SQL 2000 for this???
  141. Checking for transposed numbers
  142. Query Help: JOIN ON CONTAINS with FORMSOF
  143. Load SQL 7 database and transaction log backups to SQL 2000
  144. Cannot empty a data file to another using DBCC SHRINKFILE EMPTYFILE
  145. consolidate multiple records
  146. Transaction log error
  147. Creating Reports based on hierarchical XML file
  148. Access .adp :How to INSERT all but KEY violations
  149. SQL statement for a report...
  150. removing constraints without knowing the constraint name
  151. SQL Server 2000 - preventing multiple update
  152. sql server -- identity problem
  153. Default retrieval from table loaded by DTS
  154. 32643 Mining the Web: eigenVectors, Kriging, Inverse DistanceWeighting Searches 32643
  155. Compare Schema's...XSD
  156. RADiest client for SQL Server?
  157. SQL 2000 padding char with spaces for a type 4 JDBC driver
  158. Calculate Weekending date.
  159. inserting ole-object
  160. Database questions
  161. strange backup transaction log
  162. can I export tables so that existing tables in destination database will be modified?
  163. System tables fragmentation
  164. Using Parameter (@value) for "IN" function list
  165. Error message "String or Binary data would be trunicated", " The statement has been terminated"
  166. Insert Query on table with identity column
  167. How can you optimize duplicated work in views?
  168. Query Cache?
  169. stored procedures with parameters (in .adp)
  170. Lost 'in' SQL - need help with IN function
  171. Horizontal Partitioning question
  172. Problem:MS-Access.adp with MSDE link to csv file
  173. Recover Lost data files?
  174. sp_changedbowner gives error 15110
  175. Tip - speed up "Database Properties" in Enterprise Manager
  176. Insert a jpeg into a column sql server 2000 - desperately seeking help
  177. Performance degrading placing join in WHERE instead of FROM block (using =, =*, *=)
  178. Help joining tables properly.
  179. reboot notification
  180. Accessing Novell EDirectory from SQL Server Linked Server
  181. Error message using "Copy Database Wizard"
  182. OLAP (SUM)
  183. SQL SERVER 2005
  184. How to update if exists else Insert in one SQL statement
  185. SQLMail woes !
  186. SQL corruption
  187. Extract parameters from SQL statement
  188. Expose SQL Meta Data via ASP
  189. How to email completion messages from RESTORE commands?
  190. SQL : ORDER BY question
  191. import of multiple CSV files in one MS SQL table
  192. permissions on a column
  193. Import XML file to database (MS Server 2000) using procedure (transact sql) ???
  194. Can't install 2000 developer
  195. Please help speed up my query!
  196. Conditional SELECT
  197. Is there any guideline to reach the 5NF or above in database designing?
  198. Synchronizing stored procedures
  199. Seems Unavoidable multiple cascade paths. How to avoid?
  200. Cannot shrink the transaction log
  201. Windows Authentication problems after upgrading from 7.0 to SQL 2000
  202. Junction table design options
  203. Ordinal position
  204. dts : call 2 procs within one 'execute sql task'
  205. Parent-Child-Dimension in SQL Srv 2005 Analysis Services
  206. >> Can Google web search index the data in my database?
  207. SQL Syntax for distinct select
  208. Precomputed tables
  209. Stored Proc To Copy Unnormalized to Normalized Table
  210. Removing out of hours time
  211. Insert failed & set option error
  212. Problem - Using Visual Studio to connect to remote SQL server
  213. Help With a query
  214. converting a text field to number
  215. How to update the production database?
  216. Perfomance Enhancement through proper database designing
  217. ntext Question
  218. Help on multiple date range on sql statement
  219. Non Database Owner call to sp_addrolemember or sp_droprolemember
  220. ActiveX info
  221. time based performance decay
  222. time based performance decay
  223. Records newer than 90 minutes (smalldatetime)
  224. Full Backup
  225. SQL calculations different than on calculator?
  226. Connection Error
  227. CREATING TABLE USING SQL BASED ON SEQUENTIAL DATES
  228. Tricky Query Help
  229. Test
  230. Date Calculations...
  231. Connection Failed
  232. Splitting a field into two
  233. Info on data replication on sql server 2000.
  234. Syntax to Add 2 constraints using Alter Table?
  235. Indexing in SQL 2000
  236. Indexing in SQL 2000
  237. Indexing in SQL 2000
  238. Indexing in SQL 2000
  239. problem exectuing storded procedure
  240. Upsizing a db to SQL db
  241. Importing CSV data to MSSQL using PHP
  242. doubt
  243. Benefit of moving Master & TempDB to diff HD
  244. Help: Complex Select Statement
  245. Can 6.5, 7.0 and 2000 all co-exist on same machine ?
  246. Log restores fail after database backup
  247. Are transactional settings used only during updates?
  248. SQL - filter out duplicates but keeping all columns
  249. Help with Triggers
  250. Enterprise Mgr
  251. SQL Server 2000
  252. Optimize my stored procedure
  253. file import to SQL Server 2000
  254. Joining and grouping using SQL
  255. BCP command with arguments having special chars
  256. Wierd Problem with Enterprise Manager
  257. Returns TABLE based on a condition
  258. mysql installation problem in Xp
  259. ISNULL Function and String Concatenation
  260. merge replication without rowguid
  261. mdf file become smaller and smaller after shrinking db
  262. NEED SQL HELP PLEASE
  263. importing txt file to multiple table in sql 2000
  264. replication problems with structure/trigger/identity
  265. Summing
  266. SQL Server in single user mode??
  267. Adding times together
  268. Changing column size in existing databese?
  269. Connection without MDAC2.6
  270. problem with comparing 2 text columns in 2 tables
  271. Automation of running queries
  272. problem in installing mysqlserver n client on same machie
  273. probelm in installing mysql on win xp m/c
  274. removing spaces from an nvarchar column
  275. Help INSERT INTO query
  276. MS Scorecard writeback
  277. Table Description
  278. Pass to SQL Connections conference
  279. Upgrading from 6.5 to 7 or 2000 with 6.5 software
  280. sql statement help
  281. third edition of SQL FOR SMARTIES
  282. Installing, creating database, updating schema?
  283. Linked Server (Oracle 9i)
  284. Default Instance Files and Named Instance File Paths
  285. pb with a trigger
  286. Stored procedures with some IFs, performance issues
  287. First Post
  288. (Corrected) Opinion of Filegroup Backups
  289. Opinion of Filegroup Backups?
  290. read windows event log from sql server
  291. Query sort question
  292. How to convert to regular text, data stored in Image data type field ????
  293. how to improve performance in this query?
  294. Getting Memory Status through SQL Scripting
  295. Terminology question - set of related records in multiple tables
  296. Report Services Examples.. please.. VS.NET
  297. How to upload a table as sql?
  298. How to upload table to sql?
  299. How to find out workstation name from net_address
  300. Selecting All Parents in a Path Enumerated Tree
  301. Users, Roles, Permissions management
  302. View stored procedure permissions
  303. checkpoint command and backup log
  304. Still Trying to Figure Out Identification of SQL Server Stored Proc. Permissions via VB
  305. SQLserver programming using MFC CDatabase & Crecordset.
  306. Replication component not installed problem
  307. Problems with MSDE
  308. filegroup backup restore question
  309. Alternative to this clumsy effort?
  310. Partitioned view broken after moving table to new filegroup
  311. encrypt(string) Question!!
  312. DTS - help
  313. Transaction log file too early to apply
  314. Blocking MS Access linked tables...
  315. help needed converting C float value to DBNUMERIC ...
  316. SET options have incorrect settings: 'ARITHABORT'
  317. odbc index problem
  318. location coordinates query
  319. Any MS SQL server driver for JDBC for window NT ?
  320. Problems with enabling subscription.
  321. Character Field Formats
  322. query help
  323. Not applying the initial snapshot when setting up Tran Repl.
  324. Updating from a Text File?
  325. Extended Stored Procedure problem (srv_describe function)...
  326. inserting data into a database alphabetically
  327. JDBC for MS SQL server
  328. Stored Procedure Source Control
  329. SQL buffer size
  330. String Manipulation SQL
  331. Connection problems
  332. Are you looking for a Job?
  333. SQL 2000: Users, Roles, Permissions management
  334. sql server transaction logs
  335. behavior of SQL on joined queries
  336. VLDB Replication or Dev Copy
  337. Checking the type of a variable in SQL
  338. datetime JDBC date conversion
  339. Output Parameters versus Recordsets in Stored Procedures
  340. Cannot generate SSPI context
  341. WriteFileEx system function executed on file "db_.BAK' only wrote 112128 bytes
  342. Moving a database between two SQL Server with different patch levels
  343. please help
  344. rating system
  345. SQL Query Help
  346. variable scoping problem
  347. Execute without Insert
  348. Indexed Views - Group By Redundancy
  349. records won't delete
  350. Northwest Arkansas - Sharp T-SQL People needed.
  351. Storing Documents and Images - In the database or as a link?
  352. Updating text fields
  353. Convert MySQL script to SQL Server script
  354. Restore from SQL 7 to MSDE
  355. Same DTS Package giving different results on SQL 2k vs. SQL 7.0
  356. SQL Server to Oracle
  357. Hugo Kornelis - thanks
  358. help with celko's tree model
  359. Everyone can see the Master database?
  360. String or binary data would be truncated error
  361. Multi Value Values in Varchar field, to show each value separately in a view
  362. Cluster + SQL Agent
  363. SQL Agent + Cluster
  364. Cluster SQL Agent problem
  365. Looking for tools to monitor sql and applications
  366. "Show Execution Plan" and misleading query costs...
  367. Bulk insert stops half way through.
  368. Conversion of Oracle Version 0-1 from DEC Machine
  369. New IBM Laptop running SQL server cannot connect to another sql server on network
  370. MSDE version
  371. too many admins
  372. MS SQL 2000 and TCP protocol
  373. SQL 2000 Caculation
  374. SQL Server administration tools
  375. urgent deliverable
  376. reduce databse size
  377. Local Temporary Tables
  378. Best way of importing Excel to SQL Server
  379. Select * into removes defaults
  380. Point inTime restore
  381. Difference between Access and SQL Server
  382. BCP column insert question
  383. Feed stored procedure with SELECT resultset
  384. Lock:Timeout + urgent
  385. Function to create comma separated list from any given column/table.
  386. Copy Objects From a Linked Server
  387. Error - trying to get only latest
  388. where should I post questions on sql?
  389. MHT File Connectivity with SQL Server
  390. Database Schema Conversion
  391. Toad & SQL Server
  392. Transact-SQL Help - CASE statement and Group By
  393. SQL Server Connection Timeout
  394. nth subset of data from current table
  395. Restoring a database to a point in time
  396. sp_OA* ActiveX problem: reading property works not
  397. CR-V timing belt
  398. Enterprise Manager crashing after Jet sp8 install
  399. BCP question
  400. Help with delete
  401. Execute Big Dynamic SQL in Stored Procedure to Create View
  402. Restore SQL Server 6.5 database in SQL Server 2000
  403. does sql server collect stats on full table scans?
  404. Query Optimization
  405. Puzzled by Query Plan
  406. How to determine how much RAM my SQL server is actually using???
  407. SQL Server ODBC Read-Only Connection Problem
  408. Need help with a query
  409. ASP sp execution returning closed recordset
  410. Separating one field into two fields based on a character in the field
  411. dts, dtsrun and scheduled tasks
  412. Index Tuning Wiz recommends negative performance improvements?
  413. Stored Procedure Runs Slow In Query Analyzer
  414. HELP: Point in time restore : HOW ?
  415. stored proc runs with error after reboot.
  416. Automatic Creation and Modification log
  417. MSDE Question
  418. sql2k with windows 2003 SBS
  419. Strange processing times
  420. Dynamic sets? (i.e. where x in (@set))
  421. return val of stored procedure in query analyzer
  422. Insert query with nested select and parameter
  423. Difference between running MS SQL Server 2000 on a desktop PC and a Server
  424. Auditing
  425. Sql6.5 ODBC
  426. Dealing with large amounts of data
  427. Default value through ADO-SQLOLEDB
  428. Error when installing SQL Server 2000 - cannot configure server
  429. ntext
  430. New to SqlServer
  431. Installing Reporting Services for SQL Server 2000
  432. Return Primary Key on INSERT statement
  433. Hi Dan Guzman
  434. sql-problem
  435. problem in inserting date in sql server 7 through insert query
  436. Don't use clustered indexes?
  437. Google DB Engine ?
  438. logs getting full
  439. I'm dense on Density
  440. Performance question - Restarting the SQL server resolved my timeout problem
  441. executing sql code from text field or from multiple varchar(8000) rows in a table
  442. Data Transformation - hanging
  443. UNABLE TO CONNECT TO SERVER
  444. whats a "memory page faults"
  445. Advanced Transact-SQL Reference book - Need recommendations!
  446. A problem with bcp tool
  447. 'declare' syntax in a UDF
  448. OpenXML Query
  449. Lost Update Problem?
  450. can I return output from stored procedure into an HTA to display in browser?
  451. BitArray to binary
  452. Database change tracking software
  453. Updating tables via agent ?
  454. Erro trapping question
  455. Enterprise Manager Job Scheduler Vrs Query Analyzer???
  456. Problem with date
  457. Where to put ISNULL
  458. pocket pc mssql remote database admin
  459. Select in a transaction hangs when selecting from remote table
  460. AD
  461. No triggers, constraints
  462. Sparse Hierarchy T-SQL Help...PLEASE?
  463. No triggers, constraints
  464. EM - Open table - Return Top... -1000
  465. How to Identify Permissions for SQL Server Tables & Stored Proc. via VB Code
  466. Command works in DOS but not in xp_cmdshell
  467. Connecting to SQLServer 2000 using DNS alias
  468. export from mssql database
  469. Reordering entries in form
  470. Is this possible?
  471. Help! Dates and SQL
  472. Tables and Stored Procedures
  473. How Is The SQL2000 Desktop Licensed?
  474. Help needed with Backup and Restore
  475. Access a table
  476. Lock/block retained after commit
  477. Owner of the table
  478. Select returns one row from two
  479. Problem shrinking a database
  480. Table Name in Variable - Create Statement
  481. Is there an easy way to monitor (audit) who logs onto a database ??
  482. Is Yukon Beta2 download scalable up to 8 CPUs
  483. SQL Server 2000: How to handle licenses?
  484. MS GRAPH, PASSING PARAMETERS, ACCESS PROJECT
  485. Access crashes when updating a stored procedure
  486. SQL Server 2000: not enough storage is available to complete this operation
  487. Next Run Date column not sorting
  488. Application Performance advice please?
  489. Logging Errors
  490. how can i manage database on lan base[network base]software
  491. Recover Master database fron only MDF file
  492. Use a downloaded database
  493. Primary Key: I am trying to understand--please help if you can.
  494. SQL Server takes too long to run a query
  495. [MSSQL + VS.NET] Connection - sleeping
  496. Sql Server to MSDE - good choice?
  497. how do i use select statement in update query
  498. Trigger code
  499. ASP / SQLServer connection
  500. how to use select statement in insert query
  501. String searching
  502. how do i connect from one sqlserver7 to other sqlserver7 through internet
  503. Optimizing Database
  504. How to get back the value from exec() ?
  505. Change owner
  506. SQL Server Chat next Tuesday: SQL Server 2005 Beta 2 CLR Q & A
  507. Nulls being allowed when they shouldnt be?
  508. bcp API
  509. Variable in Variable
  510. Backup to remote pc
  511. Active Script OK But Scheduled Job Fails
  512. Reporting Services: Role Assignment without using Report Manager
  513. Vchar vs Char
  514. dynamic killer
  515. Removing non-printing characters ...
  516. Regex parser Text field
  517. Changing Column Name on a table
  518. Current user
  519. Desperate! - Need simple MSSQL server monitoring scripts, ideas, etc that can be performed by operator types (non-programmers)
  520. Relationships getting deleted (MS SQL)
  521. creating trigger to auto set create/modify dates
  522. Error when writing to SQL server through asp page using windows authentication
  523. Transaction through stored Procedure
  524. SQLServer 2005 Beta
  525. limit the access
  526. Indexed Views Vs temp tables
  527. how do you know what transation ID to play forward after restore?
  528. audit select on a table?
  529. Search Text in Database
  530. Log file of test database bloating
  531. Compare two column values with leading zeros
  532. Dynamic SQL and function
  533. Lookup value query joining two tables
  534. odbc sql server driver timeout expired
  535. auditing logins in Analysis server
  536. problems registering new database with EM.
  537. MS SQL Server client under linux/unix.
  538. Adding a day to a date.
  539. Basic SQL Server Question
  540. reporting on a DTS performance reporting
  541. Hiding Data
  542. View Users
  543. Restore DB procedure - date parameter
  544. password hash
  545. Transposing
  546. how to monitor for full table scans?
  547. DBA Responsibility
  548. DECODE in SQL Server?"
  549. Lookup value query joining two tables
  550. urgent - data type problem