PDA

View Full Version : SQL Server

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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
  1. Which is more efficient, join or straight select
  2. importing from .txt
  3. How to send data from a remote Client to my FTP site
  4. How to send data from a remote Client to my FTP site
  5. How to send data from a remote Client to my FTP site
  6. How to Copy and Rename a Database: same server
  7. SQL query - highest rated or least voted items
  8. FK on a column to a table where the column is not the PK but a Unique Index
  9. Could not find the index entry for RID...
  10. Script for comma seperated values
  11. Output Select results to a text file.
  12. Storing pdfs in an image field
  13. compare data
  14. ntext and update/insert triggers
  15. A query runs fast in Query analuser but slow in APplication
  16. Cannot start MSSQL Server 7
  17. Insert datetime problem
  18. Why....'PRIMARY' filegroup is full????
  19. insert current date/time
  20. How to insert new rows to master table
  21. storing text data in a binary field
  22. dynamic SQL variable with Output ??
  23. Need hardware suggestions for SQL 2000 server
  24. Basic Syntax explanation
  25. lookup table relationships best practice
  26. Serverwide Rollback
  27. Troubleshooting failed job
  28. Insert Trigger to Update table
  29. Split a field
  30. Date Format Conversion
  31. Creating SQLServer Jobs in Enterprise Manager
  32. Can't create table
  33. SQL Syntax - group by and having count
  34. Can I recover from the database files?
  35. BCP and SQL Server 2K
  36. Sending data to a Stored Procedure with ASP error
  37. Syntax question
  38. Theta join or equijoins??
  39. Importing from PL/SQL to MSSQL
  40. How to convert binary or hexa to decimal?
  41. WHERE clause delima
  42. XML Problem in SQL Server 2000
  43. Syntax Question
  44. removing data
  45. varchar only up to 256 characters?
  46. Xquery Support in SQL-Server 2005
  47. equivalent Oracle rownum in SQLServer
  48. Memory leak in SQL Server
  49. Create Second 'sa' Account ('sa2') on SQL 6.5?
  50. SQL Databases compare tool
  51. Need help relocating transaction log file.
  52. C# SQL-DMO ExecuteImmediate
  53. Propagation of event notification when tables are updated.
  54. Which is better for making a copy of a database, restore or DTS?
  55. testing a connection string
  56. Process Info (SQL Server Enterprise - Management - Current Activity)
  57. Slow MDB Linked View
  58. delete last added row -how to
  59. Memory Running Out
  60. Help With Some SQL
  61. Global temp table permissions
  62. How to restore database to point in time (no full backup)
  63. time from datetime
  64. XP_SENDMAIL problem after windows trust with exchange server established
  65. xp_sendmail problem
  66. SQL Server 2000 2GB memory limit?
  67. Formating Numbers with Commas
  68. Formating Numbers with Commas
  69. How to synchronize 2 tables on different sql servers
  70. Constructing Email message
  71. SQL Replication
  72. Does DB-Restore on a different machine omit user/login information ?
  73. make money for nothing
  74. SQL DTS package to process a remote OLAP database
  75. How To set delimeters and text qualifiers in a file
  76. How To write An Sql Crosstable Select statment
  77. How To write An Sql Crosstable Select statment
  78. Using DTS to move data to a new table with some datatype changes
  79. HexToInt, vbintoHexStr - fun with CAST
  80. how to add 1 to the field
  81. Help with SELECT Query
  82. Is this correct use of INSTEAD OF Triggers?
  83. Tunneling enterprise manager over https ASP.NET?
  84. Conecting over the Internet for getting data from clients.
  85. Number Data Types...
  86. openrowset - problem in reconnecting to oracle
  87. Help ! Database Still says loading after restore
  88. Help ! Database Still says loading after restore
  89. Select JOIN problem
  90. Wrong syntax in where smth in case ?
  91. Query Analyzer Template files, object browser bug
  92. wil s2k developer edition really work on XP Pro box?
  93. SQL Profiler
  94. DTS of data between two tables, same field names but differnt datatypes
  95. Sending external email from within a Scheduled Job
  96. What is purpose of N in SQL examples?
  97. cursor insert with like '%'
  98. DTS vs Datastage or Informatica
  99. Connecting for entire session, or just when performing an operation?
  100. How do you lock an entire table?
  101. Crosstab queries
  102. User interaction with SQL
  103. BULK INSERT row terminator
  104. Help Please - Backup FileGroup and Restore
  105. MDX Query Book
  106. Stored Proc not updating multiple rows
  107. DBA on mulitiple databases
  108. 7.00.1078_enu.exe on msde
  109. Problem returning a datarow
  110. Storing binary files in MS SQL 2000
  111. simple SQL update
  112. How can I INSERT w/Constraints in other tables?
  113. Loop through a recordset to populate columns in a temp table
  114. SQL 2000 - 450+ Databases
  115. HexToInt and HexToSmallInt
  116. update from ...?
  117. SQL update statement in VB
  118. Field not being updated within Stored Procedure
  119. Complicated SELECT Problem
  120. Book and class
  121. How to delete rows in a table when no primary key is defined
  122. Primary key
  123. Database Modelling in UML
  124. Mails are stuck in the Queue Folder
  125. odbc errors on terminal server
  126. XML to View
  127. SQL problem
  128. DTS package doesn't execute
  129. Totally shameless self-promotion
  130. Sql server authentication not set
  131. Error while running xp_cmdshell
  132. timeout expired w/SQL2K SP3
  133. any SQL guru's out there?
  134. DEFRAG disk drive
  135. Need good idea
  136. Problem using CAST with Zeroed out Field Values
  137. How can i get the details of the error
  138. Very large number of rows
  139. Will MSSQL DB Server perform better with 2k3?
  140. Database design, inherit
  141. How to get the status?
  142. User-Defined string Functions Transact-SQL
  143. Changing the default port number and still connecting
  144. Need advice for process of swapping DBs
  145. How to convert recursive function into recursive stored procedure
  146. Crosstab query
  147. Database Backup Security
  148. Separate an And/Or parameter
  149. Best way for a Set-based query
  150. Recovery and Backup
  151. ODBC and MSDE
  152. Customer IDs without identity
  153. SQL Server -> MS- Access VBA
  154. persisting data for a pluggable tree
  155. What hardware to get?
  156. generating auto sequential numbers
  157. case, joins and NULL trouble
  158. Improve a very large T-SQL query
  159. Filter a text field for only numerics
  160. PRIMARY Files
  161. Install Client Connectivity (SQL Server 2000) Only w/ Less Files?
  162. Write only database
  163. sp_elpuser rights
  164. Mail Profile disabled in SQL Server Agent Properties
  165. Ignore Triggers
  166. Linked Servers - Postgres 8.0.2
  167. checking success of a request in a stored procedure
  168. Session State InProc. HELP??????
  169. can't print variable
  170. Timeout Expired Error
  171. Monitoring Data file size
  172. Splitting of database
  173. don't permit manual access to database
  174. Frontpage 2002 & passing an SQL variable
  175. Snapshot replication
  176. SQL - query improvement MAX(date), IN
  177. Problem with dbo.sysindexkeys in SQL 2000
  178. Creating a trace file with the date appended to it's name
  179. SQL Server & MSDE on same machine?
  180. Help with DTS script
  181. Linking Two SQL Servers
  182. Can I ghost an SQL server?
  183. Tables get Locked
  184. Count of related records??
  185. MS SQL 2005 Express
  186. Net Send Failure
  187. Monitoring Deadlocks
  188. Best way to create dynamic update statement
  189. Job openings for scientifically-oriented programmers
  190. Edit .mdf database
  191. importing a .txt file
  192. SQL Backup procedures...
  193. Installing MSDE2000 for Remote Connection
  194. Noob: Why does this Query work?
  195. concatenate where clause
  196. Moving db across the country- full copy, then differential?
  197. Inserting Records with limited privileges
  198. Scripted delete rows
  199. SCOPE_IDENTITY with ASP
  200. A query that chooses non-matching items
  201. Counting based on a field combination
  202. Re: DBCC SHOWCONTIG inconsistency????
  203. SQL Server Hot Fix Install Error - dbmslpcn.dll is WRITE LOCKED
  204. Database Architecture: product catalogs pricing and promotions
  205. Enterprise Manager Collision
  206. Views Are Deleted
  207. quey help
  208. Storing a month
  209. Storing a month
  210. problem with OUTPUT params in Stored procedure
  211. not exist in place of outer join
  212. Dates incorrectly being saved incorrectly. DD and MM swapped round ?
  213. Primary key on combination of nullable fields, at least one not-null
  214. SQL statement
  215. create database at shared hoster site
  216. Refresh data from production to development
  217. SQL datetime from incorrect char(10)
  218. Interesting Problem
  219. SQL Server on Windows XP Workgroup
  220. Win Group vs Win User and Jobs
  221. paradoxical query results?
  222. Int versus Char primay key performance
  223. Tables seem too big - timeouts happening
  224. SQL Server Distribution Server Licensing
  225. SET FMTONLY being added to in-line SQL
  226. Proyectos de Inversion en IT en la UTN
  227. web hoster only allows 1 sql server database
  228. what does [dbo].[Accounts] mean?
  229. problem in registering sql server in enterprise manager
  230. query result as comma-separated list
  231. Last edit time?
  232. Installation Issue
  233. VB.NET Web Programmer in New York $40/hr
  234. compare
  235. Question with filegroups
  236. help with query
  237. I need help connecting Access 97 to SQL Server 2000
  238. IsNull Evaluation within EXEC
  239. SQL / ASP Newbie Question
  240. Parameters in Reporting Services
  241. Database Environment Naming Production -vs- Development
  242. restore from command line
  243. SQL to find short, fat and stupid people
  244. Strange Problew with user defined function or stored procedure
  245. Get lowest date
  246. How to reinstall RS Standard Edition on top of expired RS Eval edition
  247. Format display of current row
  248. Connecting Access Front End to Remote SQL Server
  249. Connecting Access Front End to Remote SQL Server
  250. Connecting Access Front End to Remote SQL Server