PDA

View Full Version : Microsoft 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 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119

  1. do you have a dba checklist?
  2. Is it possible to dynamically add duplicate rows to a set of data?
  3. Point in Polygon function using parameter values not a table
  4. SSIS problem:Package connection error to DB2 host
  5. Login falied for user(null)
  6. Displaying previous monthly totals
  7. Maximum Length of a SQL Query
  8. what is the alternative of exec in function
  9. SQL auditing
  10. Cancelling purchase orders
  11. What is the most efficient and professional model?
  12. new line
  13. Query doubt
  14. monitoring user activity
  15. looking for VLDB resources (books / sites)
  16. Query Analyzer; transactions and temp tables
  17. School Work(regarding Case)
  18. Data Segregation in SQL Server
  19. Is using master.dbo.spt_values dangerous?
  20. DisplayTop2RowsPerType
  21. Join in SQL
  22. Non clustered index performance
  23. Select shop sales which intersect
  24. Update or insert of view or function 'V1' failed because it contains a derived or con
  25. Query Problem Need help
  26. usage of MERGE
  27. Top2rowsInGroup
  28. copyfiles from remote systems using xp_cmdshell
  29. time intervals - set operation
  30. Convert VarChar to DateTime
  31. getdate function
  32. Update Efficiency / Method Question
  33. Identify record in period
  34. sql view
  35. sql storedprocedure problem
  36. Calculating active periods
  37. 1st year IT student - HELP with concept
  38. changing structure of the table
  39. How to reset lost sql sa password?
  40. Add a total to a query
  41. Query with date
  42. Cannot create a row of size 8069 which is greater than the allowable maximum of 8060.
  43. Tempdb
  44. composite constraint
  45. Something error
  46. Security for sql server 2008 ..on public server
  47. Foreign key error
  48. generate AccNo in SQL(select min AccNo from table where AccNo>300000000
  49. Subquesy or Inner Join?
  50. Sql server 2008 failover cluster installation
  51. getting max(date) in a view
  52. cannot restore database
  53. Unique Sequential Numbers
  54. Converting ole objects and packages to native format
  55. Help, SQL Multiple Pivot
  56. SQL Server DeadLock problem
  57. Data manipulation in SQL or c-sharp ?
  58. MS support vs. security updates
  59. Change the DSV of a dimension
  60. Convert correlated subqery to join?
  61. install sql server 2005 express
  62. EXEC statement not returning data when select xml nodes function is used
  63. solve for error
  64. Should ERP databases be stored on clouds?
  65. DBNETlib preloginhandshake error
  66. "Subquery returned more than one result" when it's desired
  67. error in SQL
  68. CROSS APPLY a FREETEXTTABLE
  69. Adding Check for Existence of File
  70. Converting a comma-separated list to new rows...
  71. need help with a query
  72. Stored procedure using vba and ado command object or access pass through
  73. upgrade to new version
  74. Need Help in Databse design for "Bus Route System"
  75. Can a SQL Server 2008 stored procedure import a Sharepoint list as input parameters?
  76. Inserting dynamic rows, calendar table?
  77. Table and filegroup question / confirmation
  78. Summed Daily totals giving different amounts from Monthly totals
  79. Can I select multi recs from single recs without cursor?
  80. Query question
  81. [help] INNER JOIN QUESTION
  82. BI Dev as a Job
  83. Combining two queries?
  84. Regularizing time intervals
  85. Schema Name is changing automatically
  86. VLDB, Merge Replication, is it ok to use GUID as PK?
  87. Data conversion error
  88. Getting started with MS SQL 2k8
  89. can a sql deadlock cause db connection problems?
  90. More elegant way to write this w/ CTE's?
  91. Replace Double Space with Single Space in data
  92. Changing Database collation
  93. calculating the size required for backup of database
  94. Consume Corticon Web Service
  95. why sql server don't have same problem,even same version
  96. Needs totals from two unrelated tables
  97. Search
  98. SQL Triggers for Multi-Row Operations
  99. [SQL2008] User Defined DB Roles and Stored Procedure Permissions
  100. Cannot upgrade SQL 2005 SP2 to SP3
  101. Aggregate Incorrect with INNER JOIN
  102. SQL Function slow improvement
  103. sqlcmd fine, but bcp can't connect
  104. Subtracting records from the same column
  105. Instead of Delete
  106. Copying NTEXT data from one record to another
  107. Error accessing the site
  108. SSAS Calendar Week commencing with split at month
  109. backup database from server pc to client pc
  110. Error Using CASE statment in SQL Server 2008
  111. Question on Efficiency of Subquery
  112. Writing values back to a database
  113. unable to run stored procedure using data from linked server via VBA
  114. Reterive timestamp data
  115. Identity
  116. Database migration
  117. MSSQL Database Security issue
  118. oracle query required
  119. table Script with Data
  120. Change Carrier
  121. display order when table is viewed?
  122. Performance and the size of tables
  123. How to show more verbose information when running a ddl sql script in "Microsoft SQL
  124. Merging Databases
  125. SQL Query and SSRS Help
  126. Problem with database copy
  127. Updated View from Stored Procedure
  128. Restoring DB from MSSQL 2008 to 2005
  129. sqlserver , restore , Backup
  130. Cannot initialize MSDAORA error
  131. Inserting a field from one DB to another.
  132. How to get SQL logshipped databases concurrent?
  133. Who's starting the DTS Package (SQL 2005)
  134. how to add column values?
  135. Need help in creating a BankERP database
  136. Slow SQL Server
  137. how can I make fulltext search
  138. XML - IIS SQL Server 2008 support ?
  139. About Exam
  140. Replication: problem of connecting interruption
  141. User Mapping
  142. INSERT INTO and UNION
  143. Replication Set up
  144. IF EXISTS syntax quick question / Agent Job
  145. Msg 213 Column name or number of supplied values does not match table definition
  146. How to Get Time Portion From DateTime Field
  147. export database as .mdb
  148. Date in tsql
  149. how to code TSQL?
  150. Replication switching integer PK to UniqueID
  151. Duplicate record Count
  152. Replace Characters
  153. How to connect SQL2000 to Oracle 11g
  154. dynamic mapping in SSIS
  155. Do I actually need Microsoft SQL server 2005 installed on my PC?
  156. Data base corruption
  157. Named Pipes Provider: Could not open a connection to SQL Server
  158. Server 2000 Automatic Number issue
  159. Help with Database Design
  160. Reusing calculated vales in Analysis Server 2000
  161. Access to Database Objects
  162. SQL Server 2K8 backward incompatibities
  163. Cant see SQL Server with Client ODBC
  164. invalid query runs anyway
  165. SQl peformance issue--High disk queues at fault??
  166. SQL server error 18452
  167. SSRS 2008-How to autosave the pdf file at server
  168. Select one column in table 1, if it meets all conditions...
  169. Index
  170. Test: Server performance
  171. Absolutely mystifying bug
  172. Question regarding T-shirt Database design.
  173. Help in using joins
  174. SQL Express Express 2008 Storage Limit
  175. installing ss2005 standard
  176. SQL Server 2005 max size/record limit
  177. Use TABLOCKX to control data export consistency?
  178. Uniquely identifying who logged-in to the MSSQL Server via Citrix
  179. finding records within set number of days
  180. Using SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF option in SQL Server 2000
  181. How to restor in Ms-Server?
  182. SQL Server Time out Error
  183. Getting An Error Message
  184. SqlWb.exe : The directory name is invalid.
  185. TSQL for regular expression
  186. Operand type clash on trigger
  187. Discrepency's between MDX query and Excel Pivot
  188. Help with UNION
  189. Trigger Problem
  190. Select help - multiple conditions
  191. Insert code from loop into SQL insert into statement
  192. data transfer from old sql server databse
  193. How to get SS2005 to use all cores
  194. Transaction log backup fails....
  195. Looking for front end that lets client search existing database and view pdf files
  196. Efficient subtotalling
  197. SQL Server - SQLServerCE / Merge Replication Hosting / Licensing / Expected Costs
  198. Joining complex SQL tables
  199. Trying to add data
  200. Query doubt
  201. How to alert if table grows more than 10000 records
  202. update the column default (relation)
  203. DB Mirroring and LogShipping
  204. Sp_rename or any
  205. When will the key/value madness end?
  206. SQL error in Application accessing SQL database
  207. ODBC Daisy chain
  208. Use of Temporary Tables Vs Cursors
  209. Time Dimension: From Months to Days
  210. Calculated Column not display correctly in SSAS Dimension
  211. Tracing SQL statements and number of records affected
  212. latest date using join
  213. Is my db read or write intensive?
  214. SSIS (SQL SERVER 2008 R2) parse SQL Query result with delimiter
  215. SQl Server Reporting Services Aggragrate Function
  216. Perfmon Memory Performance with Multiple SQL Instances
  217. dbo.table prefix
  218. Merge replication-SQL Server 2K - Duplicate rows in MSmerge_XX system table
  219. Extract a certain sentence / group of words from a string
  220. Project Server 2007 Database
  221. Multi-part identifier <alias.column> could not be bound in UPDATE
  222. More Efficient Inserting of Bulk Data
  223. logon audit
  224. Remove Unallocated space & Server level audit
  225. Connect Using Different Windows account to SQl Server DB
  226. sql server 2005 suspect database
  227. Diff b/w select & declare
  228. New to SQL Server
  229. help with the SP
  230. SQL Server status
  231. What does this indicate ???
  232. Combining date fields from two tables for complete range of dates
  233. Faulting application SqlWb.exe
  234. Need help with SQL Select statement
  235. Multiple where clause
  236. Stored Procedure based on user input parameters
  237. How to become SQL DBA
  238. DeadLock - analysis, please help
  239. sql syntax for select duplicate data in same table
  240. Insert into - combine select and coded field
  241. Backup database taking unrealistic time
  242. retrieve ID, possible for script to be too fast?
  243. How to check MSSQL trace settings
  244. Sql Server Certificate and symmetric key
  245. Difference between top with ties and percentage with ties
  246. Create login via SSMS, defaults to db_owner
  247. Stored Procedure based on user input
  248. Load csv data into table
  249. Help with my first Stored Procedure
  250. Help with Backup Procedure Step