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. Group newbie: question on parsing a field value
  2. Full-text Indexing
  3. Stumped by a BCP problem
  4. Newbie in SQL Server admin
  5. this is driving me nuts - solicit help from the gurus
  6. DTS error
  7. FULL OUTER JOIN
  8. Book suggestions for studying for MCDBA
  9. Incremental output in QA and writing to files
  10. Re: what is the impact of Database size on Performemce
  11. Can't upgrade to SP3 in Win Server 2003
  12. Load balancing and clustering
  13. Update statement performing table lock even though where condition on clustered primary index?
  14. MS SQL 2K server on windows 2K
  15. data synchronisation
  16. Auto created statistics and missing statistics
  17. trigger before delete in firebird or mssql
  18. Execution plan of UDF
  19. primary key autoincrement question.
  20. Helpdesk database statistics crosstab report
  21. SQL Statement for generating expired customer
  22. Advise on Multiple Column Updates
  23. 2 Qs
  24. ADO Recordset's object method Open
  25. "Tracking"
  26. Returning random records and NOT similar (random questions)
  27. Script, Save, Export SQL Database Diagrams
  28. Retrieving an Answer from Mulitple ResultSet statements
  29. Count of Columns <> 0
  30. Type 'adCmdStoredProc' is not declared
  31. Generate insert script
  32. Problem: must detect db changes
  33. SQL Server Agent confusion
  34. Sorry for dbl post but previous post was damaged somehow (WAS SQL Server agent weridness)
  35. SQL Server Agent
  36. Prepared Statement where value IS null or value = :x
  37. selecting x records from table n times according to variable criteria?
  38. Executing a DTS from another DTS...
  39. Using Image data type in a SQL Server 2000 table
  40. Trapping BCP error from SP
  41. newbiw SQL 2K DBA
  42. Common Table Expression?
  43. Problems using xp_smtp_sendmail
  44. Sending email from sql server
  45. About Store Produre
  46. Marrying SQL, XML, web services, grid computing (2 audio programs)
  47. Converting Number to Text
  48. Convert Punctuation to Spaces?
  49. SELECT MAX statement
  50. How to make self-backup log in msde?
  51. output parameter with text data type in stored procedure
  52. Best way to install a database at a remote site
  53. Anyone recently installed SQL Server 2000 Eval version???
  54. Inserting data into tables having triggers...
  55. Doubt in " HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET"
  56. Delete record based on existence of another record in same table?
  57. Re: Assertion: SQL Server 2000 can't issue a SOAP call
  58. When denormalizing is essential
  59. Communication link failure...
  60. Help - Recovering a deleted job
  61. SQL 2000 performance
  62. Help with this script!
  63. Update table row by row
  64. Re: Index Performance Numeric v Char
  65. Transaction...
  66. How to extract data from one database to another.
  67. No log operation
  68. Select datatype of datetime
  69. What's your compensation for carrying a pager???
  70. stored procedure denies EXECUTE permission
  71. Access2K Connection to SQL Server2K
  72. Re: formatdatetime inserts 1/1/1900 instead of current date
  73. Value of @@Error after performing update that finds no records?
  74. DECODE?
  75. Re: what is the impact of Database size on Performemce
  76. Counting items and returning values
  77. Query performance with order by clause?
  78. Excellent Job Opportunities in Baton Rouge, LA
  79. MS-SQL issue with server browsing
  80. Should I split this 175 Million record table?
  81. Re: Difference Between Output Parameter & Return Parameter - SP
  82. Retrieving updates made within a transaction?
  83. Re: Native logical ordering of table?
  84. web content database. Is there a limit?
  85. Re: SQLServer Datawarehousing Book
  86. Select boolean values merged in a text statement
  87. Re: Querying one column for two different data?
  88. Re: how do I convert rows to column headings + a few complex calculations!
  89. Re: POLL - I want your opinion on DBMS independence
  90. Re: Microsoft and SAP
  91. Re: Help: How to detect inserts, updates, deleted on a table from within C++ application?
  92. Re: Translate sql statement into SQL-92 standards
  93. Can't edit table design in Enterprise Manager without dialing in to internet! :(
  94. Re: Unknown Token Received
  95. Re: SQL Error in Application Log File
  96. Re: How To Do An Average Of A Count
  97. Microsoft SQL Server 2000 Standard w/ 5 CALs
  98. data loss
  99. Re: Translate sql statement into SQL-92 standards
  100. Re: Why Cluster a Primary Key?
  101. Re: Why Cluster a Primary Key?
  102. Re: Design to accomodate entity based schema versioning
  103. Re: bcp_moretext & NULLs
  104. Re: bcp data to a txt file
  105. Re: DTS for insert/update
  106. Using CHARINDEX vs LIKE in WHERE?
  107. challenging sql queries
  108. Re: Runtime build sql in stored procedures with output param Q?
  109. Re: Translate sql statement into SQL-92 standards
  110. Re: Why Cluster a Primary Key?
  111. Re: How To Do An Average Of A Count
  112. Re: Runtime build sql in stored procedures with output param Q?
  113. DISTINCT QUERY
  114. Re: Rebuilding indexes
  115. Stripping non-numeric chars from a field string - SQL 2000
  116. Something wrong with "select max" in this query?
  117. select statement that returns the column names and keys
  118. Application roles
  119. i need help please
  120. ODBC Memory Leak
  121. DTS Select using record position
  122. My guess is stored procedures
  123. Avoiding time-outs
  124. Multiple conditions in "IF" statement in T-SQL?
  125. Point-in-time backup of database & filesystem
  126. expanding databases in SQL 6.5
  127. SQL between Problem with dates
  128. Problem is forming Query
  129. how to configure connection pooling
  130. BI tool users - message for u
  131. complex SELECT
  132. calling Stored Procedures from different DBs
  133. SQL Query - Find block of sequential numbers
  134. space used by a table?
  135. Finding affected tables
  136. DTS package
  137. SQL Server Backups
  138. I want to restrict the my clients to access database through EnterPrise Manger Or Quer analyser
  139. Calculated Member uisng a Member Property
  140. strange optimizer
  141. Looking for a reporting tool for sql views
  142. Handling # (temp) table
  143. March 15: Rick Cattell, Peter Coffee, Dana Florescu, Jim Gray, Jim Kleewein, Jim Melton discuss XML, services and grid
  144. Date problems between VB and SQL
  145. OneClickRevelation: JDX Provides Instant and Interactive Insight Into Your Data
  146. Help ! Dangerous user with SA permissions
  147. sql dinamic
  148. sql server tools
  149. Allowing a user access to only a few tables
  150. how data file and log file grow?
  151. creating / changing owner problem
  152. modifying user security
  153. use column names and not positions when inserting from one table into another
  154. select parameter order
  155. Event driven log backup?
  156. searching for encrypted fields in data columns
  157. System Schema & Documentation
  158. SQL Profiler Hanging
  159. REPLIKACJA SQL2000 BEZ DOMEN
  160. DB Questions
  161. CountrySelector control
  162. Problem selecting count, comparing 2 fields in same table
  163. Make two query in too one
  164. Reference SQL Parser
  165. Restore databases into a new installation of SQL Server
  166. How to write a function that will return true if user is in a certain role?
  167. create an incremental counter in the stored procedure
  168. Set operations (EXCEPT/EXCEPT ALL)
  169. Holidays in SQL Server
  170. linked tables
  171. Creating a Table
  172. auto recompile in sql server
  173. Calling an Oracle Procedure via a DTS
  174. stored procedure to create new database
  175. TempDB tran log growing slowly - yet we are in simple mode!
  176. Image datatype problem?
  177. SQL Agent question
  178. cluster sql server 2000
  179. Is installation secure ?
  180. Haversine SQL trouble - Distance between zip codes
  181. setting the query time out....
  182. Data disappear - SQL server 2000 / ASP interface
  183. Array in Store procedure
  184. Access File/Get Data can't attach to a SQL table.
  185. search the primary key given the table name
  186. MSDE & SQL 2000
  187. Two tables and count
  188. Deleting records in the logfile
  189. Getting Database Stats
  190. Converting Rows into Columns MS SQL 2K
  191. world atlas database
  192. How to fix SQL Server 2000 after machine name & domain change ?
  193. Combining data from differnet Excel sheets
  194. MS SQL Server XML Query Help
  195. SELECT problem...
  196. Tables in Linked Server
  197. Group dates by month
  198. Question : How SQL chooses an index for a process
  199. Correlated Subquery Efficiency
  200. recursive call in stored proc
  201. Filter data in sql reporting services
  202. database logic report
  203. OT: SQL Server Baseball Cap
  204. Alter Column Type.
  205. sp_spaceused reports over 40 GB unused for a table
  206. back everything up in a single file?
  207. Extra parameters being added onto SP call with ADO?
  208. LAN SQL set up question
  209. Cristal Reports for OLAP CUBE
  210. test
  211. aba_lockinfo - new version available
  212. wmi access to sql server
  213. SQL Server Import Problem (UInt64 to Int32)
  214. using contains clause
  215. changing object owner syntax
  216. Dynamic Cross-Tab Query too long?
  217. Composite primary key on a table variable?
  218. Using OPENXML
  219. Server failure
  220. SQL Server Interview Questions
  221. ASP, SQL Server and double insert...
  222. Exporting MS SQL Server or Oracle Databases to MySQL
  223. how do I query this?
  224. BCP call to stored procedure - broke during upgrade from SQL 7.0 to 2000
  225. Problem with SQL Statement
  226. How to do an update on existing records?
  227. SQL error
  228. Multithreading?
  229. Parent Child Tables
  230. Slow query execution, SQL Server 2000
  231. Error 208, Missing Stats
  232. 1 row retrned for 3 rows of data
  233. Setting up a Real-Time Data warehouse
  234. concatenate two column.
  235. How to make full-text search accent-insensitive?
  236. test
  237. Problem convert varbinary to float
  238. Sorting via script
  239. Select Distinct - Incorrect result
  240. Stored procedure - user defined function.
  241. Column Formulas
  242. SQL-2000 with Analysis Services - $ 20k server budget advice
  243. t e s t
  244. test
  245. test
  246. SQLAgent can't up
  247. Return Values from a Crosstab Stored Procedure
  248. Can't import an Access table due to null values.
  249. I/O Congestion Troubleshooting: Memory and Swap File Usage Question
  250. scope_identity()