SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Upgrading SQL Server 2008 R2 to 2017

  Do you guys recommend upgrading SQL Server 2008 R2 to 2017 by just running the disc and uprading? O…

  stinger27

  6 replies

  3 weeks, 4 days ago

  By: Johan Bijnens

• SSRS - Column headings don't display on subsequent pages

  What property value do I need to set so that the header row I created displays on subsequent pages?

  nano2nd

  17 replies

  1 month, 1 week ago

  By: yoyodynedata

• Insert sp_spaceused output into temp table

  Hi All, I need to insert sp_spaceused output of DATABASE into temp table. How can I do this? Pls su…

  mssqlsrv

  13 replies

  1 month, 2 weeks ago

  By: WHug

• How to get the Parameters of a Parameterized Query from dm_exec_sql_text

  SELECT sqltext.TEXT FROM sys.dm_exec_query_stats AS CP CROSS APPLY sys.dm_exec_sql_text(sql_handle)…

  892717952

  3 replies

  2 months, 4 weeks ago

  By: Erland Sommarskog

• SQL Files open in a new SSMS instance

  When I double click on a .sql file, it starts up SSMS and loads my file. When I click on a second …

  Chad Crawford

  16 replies

  4 months, 1 week ago

  By: Jeff Moden

• I need to delete 20 million rows from a table...

  I have a table with @ 20 Million rows of data I want to truncate or delete. I don't need any of th…

  Stephen Rybacki

  47 replies

  4 months, 2 weeks ago

  By: MMartin1

• how to implement a Multirow insert trigger?

  I have the following trigger: Create trigger [dbo].[new_Location] on [dbo].[TBL_LOCATIONS] for inse…

  tpcolson

  9 replies

  5 months ago

  By: Jeff Moden

• Copying from SQLSMS grid, pasting in Excel, the word "NULL" is pasted!

  When I copy/paste grid results from SQL Server Management Studio --> an Excel file, the WORD "NU…

  iglinka

  48 replies

  5 months ago

  By: kaj

• Change Invalid date to 1900-01-01 in sql CASE query

  Hi, I have a requirement to change the date to 1900-01-01 if its an invalid date like 2009-13-31 (I…

  pwalter83

  12 replies

  5 months, 2 weeks ago

  By: Adi

• Warning: The join order has been enforced because a local join hint is used. ( two views )

  Hi Experts ! I have two select statements, in between select statement taking UNION ALL . I need to…

  smer

  14 replies

  5 months, 4 weeks ago

  By: Orlando Colamatteo

• How do I write a record for each day in a date range???

  HiTo make it simpleI  have a @StartDate and @EndDateI choose students with an admit date in th…

  jbalbo

  59 replies

  6 months, 2 weeks ago

  By: Jeff Moden

• Table Date field format

  I created a date field [Datte] in SQL v2008. I then link with MS Access. No problem. Done this many…

  shank-130731

  8 replies

  7 months ago

  By: ratbak

• SQL 2008 replication

  Hi, anyone know if SQL replication snapshot uses OS memory rather than the SQL allocated memory? Al…

  chanchan126

  2 replies

  7 months, 2 weeks ago

  By: DNA_DBA

• Sql 2008 export table csv with headers and data ...

  Hi guys, I'm really a newbie in SQL, I hope you can help me with this. I need to export a table in …

  penny1mx

  2 replies

  7 months, 2 weeks ago

  By: penny1mx

• Data type for encrypted data input

  Hi, I have a client C/C++ app, which encrypts data using AES encryption algorithm and stores them i…

  itlk

  1 replies

  7 months, 3 weeks ago

  By: Erland Sommarskog