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 56
  1. 'NETWORKDAYS(start_date,end_date,holidays)' in SQL ?
  2. Database design question
  3. A Query-Transpose of Data
  4. Some Queries
  5. Delete data, but file size increase
  6. Log all commands executed in QA
  7. Make easy money!! NO SCAM!! Please Read!
  8. Profiler not reporting reads accurately
  9. SQLServer Redirector Port 1434
  10. Get list of files in directory using a SP
  11. Format result of sp_helpdb
  12. SQL Monitoring
  13. backing up read-only database
  14. Conversion between Date Formats
  15. Conditional JOIN
  16. Timeout expired
  17. execution plans
  18. list of databases in Analysis Services
  19. Full Text Indexes do not fully populate
  20. About SQL field Type
  21. New Question Regarding LOG SHIPPING & MASTERDB
  22. Looking for MCDBA certified individual with a TS/SCI Clearance
  23. using DTS question
  24. Help needed to improve the performance of the query
  25. Slow SQL Query - Case in Where Stmnt
  26. SQL Server reports
  27. Can I EXPORT tables to a backup DB and delete them from my production server?
  28. How to remove WITH FILLFACTOR = 100 when Generate Sql Script ?
  29. How do I get uppercase values returned only.
  30. BCP Beginner - Please Help
  31. Failing replication requiring restart of SQL Agent
  32. aggregate sql question
  33. DataSet Update Problem
  34. Pivot table not showing blank value column ...
  35. Problem with Excel Pivot Table
  36. Security and access rights using local and global groups
  37. Best practices for field sizes
  38. sp_executesql vs. stored proc.
  39. sp_executesql vs. stored proc.
  40. Tricky group by order by query
  41. Tempdb gets out of control when inserting records
  42. How to create a new serverinstance but with old datafiles?
  43. [DBNETLIB]ConnectionCheckForData (CheckforData())
  44. forcing dbsqlexec to exit cleanly
  45. Stored Procedure and multiple keys which could be NULL
  46. Efficiently joining same table twice
  47. Problem Installing SQL 7 or SQL SERVER 2000 on Laptop
  48. Converting Decimal to String W/O Decimal Point
  49. OT:Check it out AllAdvanatage is back
  50. Help with update query please!
  51. BCP Format File
  52. BCP Utility - Skip rows..
  53. Importing CSV files
  54. MS SQL 6.5 Unable to connect.
  55. How to check when a stored procedure was last called/executed
  56. error 7965 not a valid recordset property
  57. Date query question!
  58. Simple select question!
  59. SQL-problem
  60. data transform and compare with in a query
  61. Parameterized order by clause: doesn't work
  62. 2 Questions: license Installation and Speed
  63. Backing Up the Database (Newbie Question)
  64. Spinning Image
  65. Need help / suggestion
  66. 2005 Express - Concurrent Connections
  67. passing a field name into a parameter
  68. Machine Name In Trigger
  69. Assigning column types in select into
  70. Delete rows in Excel From DTS package
  71. Key Lock Hashed Resource Text Value not unique?
  72. Importing Access DB
  73. [mssql][ant] Failed to execute: GO
  74. Syntax problem
  75. Syntax error in update?
  76. Update using an Inner Join
  77. Error with the trigger
  78. Sql Server Developers Licence
  79. Query to tranform rows to column
  80. Need help in log shipping
  81. Using SELECT LIKE with ADO Parameter in ASP Page
  82. access data in remote SQL server with trusted authority
  83. open query help
  84. orphan recods
  85. user defined functions & default parameters
  86. SQL DATEADD function
  87. What's a significant LockTimeout measurment in PERFMON?
  88. What's a significant LockTimeout measurment in PERFMON?
  89. Date Compare in SQL Server Stored Procedure
  90. Date Compare in SQL Server Stored Procedure
  91. Cannot DTS connect to SQL Server 2005
  92. Seek method, table-direct, and sql server2005
  93. Datatype
  94. pass hash (#) table with different structure to stored procedure
  95. Date Compare in SQL Server Stored Procedure
  96. Group by Problems
  97. list schema's of a sql server
  98. Question about SUM and Nulls
  99. SQL Query Help
  100. Auto-increment PK - Use MS or Grow your own ?
  101. Query Analyzer does not see Enterprise manager database and vise versa
  102. Find Missing data from table
  103. INTO FREE COMPUTER GEAR? FREE SAMSUNG 17" LCD Monitor NO TRICKS-NO SCAM-NO PURCHASE!
  104. Newbie....Import a DTS Package (.DTS file)
  105. SP To create table
  106. T-SQL Cursor Variable..
  107. IF (SQL server)
  108. checking the existance of fields and types
  109. I need help with SELECT statement
  110. tab character
  111. Books on Data Warehouse Performance Tuning for MS-SQL 2000
  112. (newbie) copying rows between tables via notepad
  113. Backup - Solution Needed
  114. Newbie needs help
  115. Email on insert in a table
  116. Question: Upper row limit of 6080 characters
  117. Bizarre case behavior.
  118. SELECT-how to get only the last 20 records?
  119. Will OSQL Produce SQL Backup?
  120. Can't Export Fields w/ over 255 characters
  121. Large binary writes slower than expected
  122. "Hill Climbing" -- a More General Question on Systematic SQL Skill Upgrade
  123. Import MS-Excel to SQL-Server
  124. Semistructured data
  125. looking for a tool/ middleware tool which...
  126. Win xp sp2
  127. Help needed
  128. Anyway to recover delete stored proc?
  129. Query help with 2 tables plus one more - easy I think
  130. Query help with 2 tables plus one more - easy I think
  131. SQL JOIN help
  132. SQL 2 tables ask
  133. IF statement in DML
  134. Creditwrench
  135. sql LEFT JOIN and IN question
  136. restore db stuck loading
  137. Multiple Table Joins Makes Query Go To Sleep
  138. SQL ask 2 tables
  139. Writing your own aggregate functions
  140. Using the same View repeatedly
  141. A story of incorrect syntax
  142. ASP.NET/IIS/SQL help !
  143. SQL Debugger Problem
  144. SQL Transaction Processing - Learning Resources
  145. Execute same statement for each value in result set
  146. Export
  147. Question:Killing sessions before nightly CHECKDB
  148. Question:Killing sessions before nightly CHECKDB
  149. SQLMail does not start
  150. stored procedures/security
  151. simple problem, it's friday...
  152. Return most recent membership based on year stored in joined table
  153. DB design thoughts??
  154. execute proc on stopping mssql server
  155. Having Clause won't run on Linked Server
  156. importing DB from another SQL server
  157. SOX Solutions?
  158. incompatiable data sync
  159. Sending file contents in the body of the email with xp_sendmail
  160. Cool File Encryption Software Released.
  161. VB and SQL Reporting Services
  162. ms sqlserver chat room
  163. Impossible to use a scalar UDF to pass a parameter to another UDF?
  164. How to build Gui or forms to wrap SQL queries that are normally run in query analyzer
  165. What's wrong with this View? Duplicate columns?
  166. VB6 connection problem to MS SQL Server 7 table
  167. Planning for SQL Server 2005: 64-bit, OS, processor, memory
  168. SQL Server Agent Job History
  169. Obtaining timezone offset in T-SQL.
  170. T-SQL script for tran log with - in database name
  171. Agregar una tabla a un filegroup existente
  172. Select * from something where field1 = N'literal'
  173. Select * from something where field1 = N'literal'
  174. language-font problem
  175. osql feedback
  176. Error converting data type varchar to float
  177. MS SQL connection could not be established
  178. Between Question
  179. SQL 2000 whitepaper?
  180. Merging Duplicate Rows
  181. comparing data between two tables...
  182. DLookup equivalent in SQL Server
  183. How to get the last occurence of rows containing disticnt value in one column
  184. Alternatives to SQL *Plus
  185. strtdb80.exe has encountered a problem
  186. searching for any data string in database
  187. SQL Server Backup
  188. Help optimising SQL Query
  189. Is user logged-on?
  190. accessing the database remotely from non-microsoft platform
  191. Select for Cursor Returns 0 Same Select Highlighted Returns 2,000+
  192. Quick SQL Server 7.0 index question
  193. How do I format an integer
  194. why does this deadlock?
  195. Capture Records That Failed Insertion From XML
  196. How can I avoid table lock in SQL2000?
  197. SQL Server 2005 Datetime data type
  198. @@servername returns NULL
  199. Odbc - binding sql server binary field to a wide char field only returns 1/2 the daat
  200. Help - Corrupted SQL Server 2K Log. Is this serious
  201. Access Data Projects Uniqueidentifier problem
  202. Find Table Size
  203. LogPI performance
  204. Moving log files
  205. Conditonal SUM function, or similar conditional aggregates
  206. [Off Topic] Thought I would mention...
  207. As a Beginner's I'm having trouble finding a sample DB on which to learn to model my own.
  208. SQL Server Table Backup
  209. SQL 2000 Linked Server Hangs Due To Trigger
  210. How pass column to udf in join
  211. Validating and updating colums
  212. Managing DB updates to client DB servers
  213. Select data from table an return all all months
  214. Accelerating MS SQL Client
  215. Output an SQL Query to a text file
  216. SQL SERVER REPORTS ANALYST - Dallas
  217. Which Sql Server error number is used when a table has a deadlock?
  218. HOWTO: Installing SQL 6.5 on Windows 2000 Server
  219. Very strange behavior of SQLServer with connection from CGI
  220. Conditional summaring
  221. Finding out all the User Tables being used by an application
  222. Performance decrease after OS upgrade
  223. Need help speedig up query
  224. CRecordset + char + stored procedures inoutParam
  225. Shrinking database files
  226. www.it-ebook.com - 25 ebooks on sql server
  227. Updating a text field in SQL Server
  228. Sequence no group wise
  229. best practices for writing SQL server stored procedures
  230. avoid using cursors
  231. High Performance SQL Server (article)
  232. SBS 2003 Monitoring Database
  233. Beginning SQL Server Book?
  234. sql 2 tables ask
  235. problems trying to import data from excel file
  236. Procedures v. Functions
  237. Build ID w/Incrementing Digit
  238. Problems when trying to rebuild indexex
  239. Unable to connec to SQLSERVER server from client
  240. Detecting (local) sql-server
  241. don't understand the following locking behavior
  242. A REAL money maker. IT WORKS!!!!
  243. How to recover SQL database from a removed laptop hard drive?
  244. Create User Function w/Case
  245. Connecting to Webservice from DTS
  246. Changing lost SA password
  247. cannot edit text cell
  248. Create variables with same format in one single step?
  249. Loading db & Read-Only db
  250. Partnership Opportunity