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. Senior Infrastructure Database Administrator - Calgary, Canada
  2. "Storing an image into Sql Server Database "
  3. Convert Seconds to hours:minutes:seconds
  4. SQL 7 SP 4 Installation Hangs
  5. Connecting to SQL Server from ASP
  6. SQL Statement Tuning
  7. Cloning a table
  8. debugging stored procedures
  9. Enabling Microsoft EFS in a SQLServer 2000 Cluster
  10. character sets in SQL server
  11. collate SQL_Latin1_General_CP850_BIN to SQL_Latin1_General_CP1_CI_AS
  12. syntax question whole word finding
  13. SQL Connection Log
  14. Stored procedure deadlock on self with subquery
  15. Insert Into Column problem ...
  16. T-SQL too big for Task Scedule - HELP!
  17. Using LIKE with underscore and forward slash..
  18. Identity In SQL VS Autonumber In Access
  19. Client connection to SQL Server on shared hosting
  20. SQL Statement Help
  21. Speed cost for using "or" clause and functions on join statement
  22. Design question: Nested views and functions?
  23. various working with dates issues
  24. Another DTS question
  25. Lock:Timeout events
  26. Update query
  27. slow performance on specific query
  28. curious result
  29. Anyone interested in getting Microsoftt, CISCO or any other IT CertificationzzzZ
  30. Help, im new to MSSQL
  31. Asking Email Address Up David Portas and Erland Sommarskog
  32. SQL Server/PeopleSoft DBA Needed!
  33. Is there a way to autoincrement a field with mixture of alpahbetic characters and numbers?
  34. Stored Procedure Not Returning Recordset in ASP
  35. SQL Server on chared hosting with client connections
  36. Column calculations
  37. Database performance degrading (again)
  38. Permutate rows based on table
  39. BCP Issue w/Right Truncation
  40. SQL 2000, AS400 and Client Access
  41. Get the field value after INSERT
  42. Question on aggregate statement
  43. Query/Report Help needed
  44. Stand alone client tools installation
  45. Mystery Database IDs in Profiler
  46. Query - check for a string in stored procedure
  47. Report Containing Sequential Dates (removing date gaps)
  48. Update Time Out?
  49. Null & String Ops Again
  50. MS SQL Server - User Rights
  51. Login Confusion
  52. SQL Query - Aggregate data
  53. Script to lock down a regular user?
  54. Concurrency issues with "Tree" structures.
  55. get the description of a column
  56. Problem backing up Database and Transaction Log due to disk space limitations
  57. TSQL: I want to use a SELECT statement with COUNT(*) AS 'name' and ORDER BY 'name'
  58. Complex query help needed....
  59. DTS Package and ASP.NET
  60. Urgent deliverable
  61. Update Query
  62. How to remember last record read
  63. multiple foreign keys on same field, based on other field
  64. ASP to SQL Connection Prob, Same Server, IIS
  65. Using select results in a stored procedure
  66. DB2 User Group Italy - next meetings March 2005
  67. simple division problem
  68. How to Backup Read-
  69. How to Backup Read-Only databases
  70. Dr. Michael Rys on Microsoft SQL Server 2005 and XQuery
  71. Cannot Drop Database
  72. Select first type problem...
  73. 'NETWORKDAYS(start_date,end_date,holidays)' in SQL ?
  74. Database design question
  75. A Query-Transpose of Data
  76. Some Queries
  77. Delete data, but file size increase
  78. Log all commands executed in QA
  79. Profiler not reporting reads accurately
  80. SQLServer Redirector Port 1434
  81. Get list of files in directory using a SP
  82. Format result of sp_helpdb
  83. SQL Monitoring
  84. backing up read-only database
  85. Conversion between Date Formats
  86. Conditional JOIN
  87. Timeout expired
  88. execution plans
  89. list of databases in Analysis Services
  90. Full Text Indexes do not fully populate
  91. About SQL field Type
  92. New Question Regarding LOG SHIPPING & MASTERDB
  93. using DTS question
  94. Looking for MCDBA certified individual with a TS/SCI Clearance
  95. Slow SQL Query - Case in Where Stmnt
  96. Help needed to improve the performance of the query
  97. SQL Server reports
  98. Can I EXPORT tables to a backup DB and delete them from my production server?
  99. How to remove WITH FILLFACTOR = 100 when Generate Sql Script ?
  100. How do I get uppercase values returned only.
  101. BCP Beginner - Please Help
  102. Failing replication requiring restart of SQL Agent
  103. aggregate sql question
  104. DataSet Update Problem
  105. Pivot table not showing blank value column ...
  106. Problem with Excel Pivot Table
  107. Security and access rights using local and global groups
  108. Best practices for field sizes
  109. sp_executesql vs. stored proc.
  110. sp_executesql vs. stored proc.
  111. Tricky group by order by query
  112. Tempdb gets out of control when inserting records
  113. How to create a new serverinstance but with old datafiles?
  114. [DBNETLIB]ConnectionCheckForData (CheckforData())
  115. forcing dbsqlexec to exit cleanly
  116. Stored Procedure and multiple keys which could be NULL
  117. Efficiently joining same table twice
  118. Problem Installing SQL 7 or SQL SERVER 2000 on Laptop
  119. Converting Decimal to String W/O Decimal Point
  120. Help with update query please!
  121. BCP Format File
  122. BCP Utility - Skip rows..
  123. Importing CSV files
  124. MS SQL 6.5 Unable to connect.
  125. How to check when a stored procedure was last called/executed
  126. error 7965 not a valid recordset property
  127. Date query question!
  128. Simple select question!
  129. SQL-problem
  130. data transform and compare with in a query
  131. Parameterized order by clause: doesn't work
  132. 2 Questions: license Installation and Speed
  133. Spinning Image
  134. Need help / suggestion
  135. 2005 Express - Concurrent Connections
  136. passing a field name into a parameter
  137. Machine Name In Trigger
  138. Assigning column types in select into
  139. Delete rows in Excel From DTS package
  140. Key Lock Hashed Resource Text Value not unique?
  141. Importing Access DB
  142. [mssql][ant] Failed to execute: GO
  143. Syntax problem
  144. Syntax error in update?
  145. Update using an Inner Join
  146. Error with the trigger
  147. Sql Server Developers Licence
  148. Query to tranform rows to column
  149. Need help in log shipping
  150. Using SELECT LIKE with ADO Parameter in ASP Page
  151. access data in remote SQL server with trusted authority
  152. open query help
  153. orphan recods
  154. user defined functions & default parameters
  155. SQL DATEADD function
  156. What's a significant LockTimeout measurment in PERFMON?
  157. What's a significant LockTimeout measurment in PERFMON?
  158. Date Compare in SQL Server Stored Procedure
  159. Date Compare in SQL Server Stored Procedure
  160. Cannot DTS connect to SQL Server 2005
  161. Datatype
  162. Seek method, table-direct, and sql server2005
  163. pass hash (#) table with different structure to stored procedure
  164. Date Compare in SQL Server Stored Procedure
  165. Group by Problems
  166. list schema's of a sql server
  167. Question about SUM and Nulls
  168. SQL Query Help
  169. Auto-increment PK - Use MS or Grow your own ?
  170. Query Analyzer does not see Enterprise manager database and vise versa
  171. Find Missing data from table
  172. SP To create table
  173. T-SQL Cursor Variable..
  174. IF (SQL server)
  175. checking the existance of fields and types
  176. I need help with SELECT statement
  177. tab character
  178. Books on Data Warehouse Performance Tuning for MS-SQL 2000
  179. Backup - Solution Needed
  180. Email on insert in a table
  181. Question: Upper row limit of 6080 characters
  182. Bizarre case behavior.
  183. SELECT-how to get only the last 20 records?
  184. Will OSQL Produce SQL Backup?
  185. Can't Export Fields w/ over 255 characters
  186. Large binary writes slower than expected
  187. "Hill Climbing" -- a More General Question on Systematic SQL Skill Upgrade
  188. Import MS-Excel to SQL-Server
  189. Semistructured data
  190. looking for a tool/ middleware tool which...
  191. Win xp sp2
  192. Help needed
  193. Anyway to recover delete stored proc?
  194. Query help with 2 tables plus one more - easy I think
  195. SQL JOIN help
  196. SQL 2 tables ask
  197. IF statement in DML
  198. Creditwrench
  199. sql LEFT JOIN and IN question
  200. restore db stuck loading
  201. Multiple Table Joins Makes Query Go To Sleep
  202. SQL ask 2 tables
  203. Writing your own aggregate functions
  204. Using the same View repeatedly
  205. A story of incorrect syntax
  206. ASP.NET/IIS/SQL help !
  207. SQL Debugger Problem
  208. SQL Transaction Processing - Learning Resources
  209. Execute same statement for each value in result set
  210. Export
  211. Question:Killing sessions before nightly CHECKDB
  212. Question:Killing sessions before nightly CHECKDB
  213. SQLMail does not start
  214. stored procedures/security
  215. simple problem, it's friday...
  216. Return most recent membership based on year stored in joined table
  217. DB design thoughts??
  218. execute proc on stopping mssql server
  219. Having Clause won't run on Linked Server
  220. importing DB from another SQL server
  221. SOX Solutions?
  222. incompatiable data sync
  223. Sending file contents in the body of the email with xp_sendmail
  224. Cool File Encryption Software Released.
  225. VB and SQL Reporting Services
  226. ms sqlserver chat room
  227. Impossible to use a scalar UDF to pass a parameter to another UDF?
  228. How to build Gui or forms to wrap SQL queries that are normally run in query analyzer
  229. What's wrong with this View? Duplicate columns?
  230. VB6 connection problem to MS SQL Server 7 table
  231. Planning for SQL Server 2005: 64-bit, OS, processor, memory
  232. SQL Server Agent Job History
  233. Obtaining timezone offset in T-SQL.
  234. T-SQL script for tran log with - in database name
  235. Select * from something where field1 = N'literal'
  236. Agregar una tabla a un filegroup existente
  237. Select * from something where field1 = N'literal'
  238. language-font problem
  239. osql feedback
  240. Error converting data type varchar to float
  241. MS SQL connection could not be established
  242. Between Question
  243. SQL 2000 whitepaper?
  244. Merging Duplicate Rows
  245. comparing data between two tables...
  246. DLookup equivalent in SQL Server
  247. How to get the last occurence of rows containing disticnt value in one column
  248. Alternatives to SQL *Plus
  249. strtdb80.exe has encountered a problem
  250. searching for any data string in database
  251. SQL Server Backup
  252. Help optimising SQL Query
  253. Is user logged-on?
  254. accessing the database remotely from non-microsoft platform
  255. Select for Cursor Returns 0 Same Select Highlighted Returns 2,000+
  256. Quick SQL Server 7.0 index question
  257. How do I format an integer
  258. why does this deadlock?
  259. Capture Records That Failed Insertion From XML
  260. SQL Server 2005 Datetime data type
  261. How can I avoid table lock in SQL2000?
  262. @@servername returns NULL
  263. Odbc - binding sql server binary field to a wide char field only returns 1/2 the daat
  264. Help - Corrupted SQL Server 2K Log. Is this serious
  265. Access Data Projects Uniqueidentifier problem
  266. Find Table Size
  267. LogPI performance
  268. Moving log files
  269. Conditonal SUM function, or similar conditional aggregates
  270. As a Beginner's I'm having trouble finding a sample DB on which to learn to model my own.
  271. SQL Server Table Backup
  272. SQL 2000 Linked Server Hangs Due To Trigger
  273. How pass column to udf in join
  274. Validating and updating colums
  275. Managing DB updates to client DB servers
  276. Select data from table an return all all months
  277. Accelerating MS SQL Client
  278. Output an SQL Query to a text file
  279. SQL SERVER REPORTS ANALYST - Dallas
  280. Which Sql Server error number is used when a table has a deadlock?
  281. HOWTO: Installing SQL 6.5 on Windows 2000 Server
  282. Very strange behavior of SQLServer with connection from CGI
  283. Conditional summaring
  284. Finding out all the User Tables being used by an application
  285. Performance decrease after OS upgrade
  286. Need help speedig up query
  287. CRecordset + char + stored procedures inoutParam
  288. Shrinking database files
  289. Updating a text field in SQL Server
  290. Sequence no group wise
  291. best practices for writing SQL server stored procedures
  292. avoid using cursors
  293. High Performance SQL Server (article)
  294. SBS 2003 Monitoring Database
  295. Beginning SQL Server Book?
  296. sql 2 tables ask
  297. problems trying to import data from excel file
  298. Procedures v. Functions
  299. Build ID w/Incrementing Digit
  300. Problems when trying to rebuild indexex
  301. Unable to connec to SQLSERVER server from client
  302. Detecting (local) sql-server
  303. don't understand the following locking behavior
  304. How to recover SQL database from a removed laptop hard drive?
  305. Create User Function w/Case
  306. Connecting to Webservice from DTS
  307. Changing lost SA password
  308. cannot edit text cell
  309. Create variables with same format in one single step?
  310. Loading db & Read-Only db
  311. Sql puzzle
  312. What is the best way to create a script to update a new version of a the DB
  313. Convert RTF to plain text
  314. Recommended Stretagy for Bi-Directional SQL DB Synchronization
  315. Local SQL Service Not Starting but SQL Server is running?
  316. DROP_EXISTING
  317. Help! - Query On Time Field In SQL Server - How?
  318. Representation for Heterogeneous Attribute Set
  319. MS SQL Server Service Manager does not find instance
  320. Basic SQL question...
  321. Performance of views accessed by multiple SPIDs?
  322. Retrieve Manager/Subordinate hierarchy from Self-Referencing table
  323. query that select extended procs
  324. using logins
  325. Connecting to SQL Server OVer Internet
  326. A Query Help!
  327. Linked Servers to Lotus Notes
  328. UPDATE a variable to different categories by a single step?
  329. When is procedure cache flushed or cleared?
  330. problems with a stored prc
  331. Local variables in stored proc
  332. FYI: a weird performance problem with MSDE and possibly SQL Server 2000
  333. Automatic Execution of a Stored Proceedure
  334. Cleaning unused stored procedure best practice?
  335. Uninstall second instance
  336. Log backups - what does a database name of 0 mean?
  337. WHILE loop speed compared to cursors?
  338. Ye Olde GUI display/sychronization problem...
  339. Can 98SE read files from NTFS Drives?
  340. Regarding a sample query
  341. SQl server connection from another location
  342. Scan count
  343. authorization error in reporting services on win2003
  344. Strange SQL Question
  345. SQL Server and Automated Emails
  346. Need advice on best way to make dbase record updates
  347. SQL Server BIGINT and MS ACCESS...
  348. What datatype to use for PK?
  349. SQL Server 2000 performance counter
  350. Log IP Address of attempted logins
  351. Is it MS SQLServer or something else?
  352. Accessing SQL Server Databases from Networked PC
  353. Error in store procedure
  354. relocating transaction log
  355. Advice on table design which will allow me to enforce integrity
  356. Database back end - SQL Server or Access
  357. .
  358. Optimization technique
  359. Store Gitar Codes
  360. New setup of MySQL on my machine....
  361. How to dedicate a cpu for SQL Server?
  362. linked server referred by insert trigger
  363. Database Setup and Design
  364. BCP and treatment of NULLs when export to fixed format text file
  365. How do I programatically acces a database with a '-' in the name?
  366. How to have a batch transaction?
  367. Strange OSQL behavoir.
  368. Now if a update worked in a SP
  369. Enterprise Manager Problem with registering connection
  370. ISO 6346 Check Digit Calculation in T-SQL
  371. Problem with Parallel Query Execution
  372. Varchar vs Char in 1st field of composite clustered index
  373. IN (subquery) slower than calculation @VAL and then IN (@VAL)?
  374. using application roles
  375. using application roles
  376. using application roles
  377. using application roles
  378. permissions to see design view
  379. using application roles
  380. Selecting the same column twice in the same where clause
  381. using application roles
  382. using application roles
  383. using application roles
  384. Select
  385. australian postcode db with longitude/latitude
  386. Replication and sql server 2005
  387. Copy permissions of a database role
  388. Compare datetimes
  389. select from subquery
  390. Chosing the right hardware configuration for SQL server
  391. Extended Stored Procedure - ODBC Loopback Connection Problem
  392. iif stored procedure
  393. Move Log File Locations
  394. sql server backup job timeout
  395. Data casting, casting operations
  396. Merge Repliction - Run Stored Procedure when merge agent starts
  397. Bring db online/offline
  398. WTD: Data Base/Application Needed
  399. SQL Server for data processing
  400. Winter SQL Server Gurus Event at UCLA
  401. Numbers and Crystal Reports 9
  402. Question: Date field
  403. How to update just one record
  404. online questionnaire w connection to database
  405. MSDE and ODBC Tables
  406. characters encoding
  407. Is bookmark in a nonclustered index ordered?
  408. Database server will not expand mdf or ndf files
  409. Imbedding a Select Statement within an Update
  410. Vanishing parallelism
  411. How to update a table with SUM function?
  412. Sort Results by Number of Hits
  413. Table Corruption?
  414. Is @@IDENTITY really unique in multi-sessions scope
  415. Extract data from SQL 6.5
  416. Odbc unstabil
  417. [22003][0][Microsoft][ODBC SQL Server Driver]Numeric value out of range
  418. SQL 2000 Physical Layout Question
  419. Gripe: interoperability
  420. Urgent Deliverable
  421. Passing Paramenter to SP for Column Name
  422. Using SQL Server (T-SQL) to parse text
  423. Conditional WHERE statement?
  424. Aggr
  425. When Export to Excel
  426. Record Locking in Access ADP
  427. Return rows where column is less than 10 characters
  428. Ordering varchar column numerically
  429. sql server database installs
  430. Error in connection with database
  431. Simple MAX query?
  432. Database Normalization/Design Question
  433. Reclain space after DROP COLUMN
  434. Adding Execute permissions on Stored Procedures
  435. large arrays, UDFs and the text datatype
  436. How to learn sql from beginning?
  437. SQLXML - Soap/Any Authentication? Exporting SQLXML IIS Settings?
  438. How to return large amount of data in the XML format
  439. Extract data in "Insert Into..." statement format
  440. Does Alter Column do work if column already the same as desired?
  441. ODBC in SQL Query Analyzer
  442. Inconsistent Database Performance
  443. Search for a field name in stored procedures
  444. MDF Disk Fragmentation - Backup and Restore
  445. How to tell if AWE is actually working?
  446. help with query
  447. Numeric overflow . No errors. Insert the wrong number
  448. How to add a do loop in sql? Thanks a lot!
  449. IsLogin problem
  450. List of Logins
  451. bcpinit problem
  452. Full Text Search - Ranking Algorithms
  453. Reindex maintenance plan fails after adding secondary data file
  454. 16 gig of memory (AWE or WSRM)
  455. Fastest way to execute aggegate functions on a table?
  456. How to determine if stor proc parameter is output or input
  457. Query Analyzer. Align/indent stored procedure script
  458. Help Needed!!
  459. importing and archiving
  460. Need details on Query Profiler
  461. How do you improve SQL performance over large amount of data?
  462. Particularly Challenging SQL Problem.
  463. how do you know indexes have been fragmented?
  464. How do I write a point-in-time record to another table?
  465. Capture Returned Value From Exec(@Build) into another variable
  466. sql query syntax
  467. Executing a DTS Package using an ASP (VBScript)
  468. Indexes and File groups
  469. Need help figuring out SHOWPLAN_TEXT help
  470. assigning each record to one string
  471. From excel file into MS SQL server
  472. JDBC: calling a stored procedure with multiple return values.
  473. Query joins problem
  474. Evaluating Lumigent Entegra
  475. Querying data from multiple views
  476. Reporting Services security issues
  477. Table export removes primary key
  478. Stored procedures and Visual SourceSafe
  479. Microsoft Exchange to Microsoft SQL Server
  480. Multiple Deletions From Different Tables in SQL Server Trigger
  481. database prioritizing
  482. How to copy Database Structure from one db to another w/o affecting data
  483. Query timeout problems
  484. Any easy way to change column length like varchar 30 to varchar 100?
  485. Any easy way to change column length like varchar 30 to varchar 100?
  486. Any easy way to change column length like varchar 30 to varchar 100?
  487. Any easy way to change column length like varchar 30 to varchar 100?
  488. SQL Server 2000 cannot listen on TCP/IP!
  489. changing the default value for a column
  490. Update remote table from local table
  491. integration betwenn Analysis Manager and GIS applications
  492. website problem with mySQL data base
  493. Determine which user has locked a record
  494. Two questions about SQL Server 6.5
  495. Running Cognos from SQL
  496. Disabling Named Pipes
  497. group by clause query help
  498. SQL Server Network Utility - where is it?
  499. SQL instances ports
  500. CommandText issue - SQL Reporting Services
  501. Index creation causes error "The conversion of a char data type to a datetime data type resulted..."
  502. Connecting to Sql Server from Application
  503. Incrementing or updating a TIMESTAMP field.
  504. BCP Large Table.
  505. Slow performance of like operator
  506. SQL Database design question
  507. Update Query (Access vs. SQL Server)
  508. Reporting Services security
  509. schema extraction for multiple interdependent databases
  510. Using Visual SourceSafe with Sql Server
  511. ETL: OLTP -> DATA Store
  512. ignored words in full text indexing
  513. Implementing read-write locks
  514. Poor Performance on Dual Xeon Machine
  515. How do I reinstall the SQL Server ODBC drivers?
  516. need help
  517. How stopping and restarting full text indexing?
  518. Solved
  519. Avoid caching image datatype
  520. How to get the date part of Datetime
  521. Possible?: Count(*) returned by EXEC
  522. Connection string OLEDB - SqlServer
  523. Help with query plez
  524. Sql Server ODBC applet won't start can't configure problem
  525. Query problem
  526. Replication with Triggers
  527. Third party reindexing utilities
  528. How To Round With Negative Numbers?
  529. Create table with 15,000,000 default rows
  530. Making a Stored Procedure in MS-SQL 2000
  531. Time Function?
  532. Can we use details hard coded into exe directly in reports without storing in DB
  533. Sql Server does not exist or access denied issue again
  534. Replication issue
  535. insert double quotes into sql server table
  536. SQL Using LIKE Command with Subquery
  537. Triggers and Replication
  538. RS ASP.Net code
  539. "organize and view datasets using toad"
  540. Very small table incredibly slow
  541. 6GB 2 row table????
  542. Question about debugging
  543. organize and view datasets using toad
  544. Quick question: how do I get the name of the current database?
  545. Collation problem with SQL 2000
  546. But the documentation is NOT correct
  547. Need to change IP address of server
  548. EXCEPTION_ACCESS_VIOLATION: Odd Error in Event Viewer
  549. Keywords
  550. Storing result of EXEC into a variable