Microsoft SQL Server 2008

49K

Solutions

24

Articles & Videos

15K

Contributors

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2005
  3. Query Syntax
  4. SSRS
  5. Databases
  6. Windows Server 2008
  7. ASP.NET
  8. .NET Programming
  9. C#
  10. Microsoft Development
Refine results

Hello,

I'm trying to restore a SQL Server 2008 R2 Database and I'm getting this error, saying it's in use.
I have just re-booted my server and still get this error. Please see attached.

Can …

19 views
Complete VMware vSphere® ESX(i) & Hyper-V Backup
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

I found a sample code online to get the last part of a string.

This is SQL 2016. I need to get the digits (4576893 for example)

This works. You see there is no forward slash after 4576893  

1412 views

Its has been years since I wrote a curser and was hoping for some guidence.


Lets say I have a select statement that returns me a unique list of Customers

So here is the select

Select  …

210 views

I am migrating my 2008 databases to 2012 and only want to migrate Database that are used the most frequent by determining the Last Used / Updated Date. Not the create date or modified date.

My SQL…

1112 views

I inherited a SQL server and the performance is not the best.  I noticed that the front end app that uses the database moves data between several tables when it starts each morning and then runs a …

417 views

I have this example, but as I don't have the database AdventureWorks2012, I'd like to know what does that OPTION serve for?

(CODE)

Thanks
alex

422 views

out of 10GB table, 8GB is going to be removed.
after that instead of SHRINKFILE, how can this made to release space unused.

this is a heap table.

213 views

if 7 developers are in a lab room, and all workstations are running on sql server with service account of Local System, what can be the security breach possible situations/scenarios? can you give …

1314 views

I have a stored proc..and due to the structure of this proc...the wizard in Reporting Services cannot detect this as a dataset.

Does anyone know how I might rewrite this so SSRS will read it and …

2511 views

I am running a web application on a Win2012 server. The server has TLS1.0 enabled, which I want to disable.
The problem is that if I disable it the connection to MS SQL 2008 R2 which is installed on…

725 views
Free Tool: Postgres Monitoring System
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have a table of dates here are my column names

sample
(CODE)

My second Table OnCallSupport here is a sample
(CODE)

I need 1 person from each team to be on call. How could you join these …

1314 views

I am looking for a script to automate index reorganize/rebuild and also update stats on 3 specific tables
table_A, table_B, table_C in  Customer Database.  I want to rebuild only if index level is …

822 views

in general, have you and do you recommend all default tools in 'Data Tools' for 2016 version to be installed?

if you are not using AS,RS (analysis and reporting) have you seen any value in …

113 views

in
http://www.sqlcoffee.com/SQLServer2016_0001.htm
"
On the following screen you need to provide the service accounts that SQL Server services will use. As you can notice, SQL Server setup …

5128 views

pl see chart.{it includes data+index together} (SQL 2008R2)

after 10 years, db nearing 600GB.. what are best standards to break this for performance (perhaps by years of data, since all records …

825 views

If I have a column like this:

[  "abcd", "xyz", "123" ]

How can I parse it? I want to parse it and insert them in a table (3 rows in this case)

This is sql 2014

625 views

I have the following Store proc.

I would like to rewrite this so its not stuff the select statement into a variable.

I would like this to be just a select statement with the where clause logic …

4258 views

Hello there I am trying to create a recusion that creates an entry for a weekly  start and end Friday to Friday


(CODE)

Getting this error
(CODE)

617 views

this is WIn10 workstation
when you go to Programs and Features in Control Panel,

for SQL 2008R2, you see very few entries
for SQL 2012, it seems like little more
for 2016, there seems to a …

116 views
Ransomware: The New Cyber Threat & How to Stop It
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/

under "Creating a new project"

The second picture, under the line starting …

168 views

Hello guys

I need to get all tables, views, store procedures, functions etc from my Database to run it in another database placed into another machine.

How can I do that?

thanks
Alexandre

712 views

Asked a question  (https://www.experts-exchange.com/questions/29007151/Create-SQL-Server-Job-to-perform-backups-of-all-the-databases-in-a-server-instance.html)yesterday about creating a backup job to …

618 views

I'm working on a procedure to determine whether a file exists on the path referenced in a field of my database.

In some instances, I will need to be able to copy this file to another location on my…

429 views

I'm parsing a JSON file and the datetime field looks like below and I get an error.

What data type I need to declare for it to get the datetime? This SQL 2014

(CODE)

119 views

In SQL Server I call the following sproc, referenced by an SSRS report:

(CODE)

and get back a response of:

Command(s) completed successfully.

I don't get an returned rows.

Suggestions?

819 views
Show more content
201506-LO-Top-001

Microsoft SQL Server 2008

49K

Solutions

24

Articles & Videos

15K

Contributors

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Related Topics

  1. Microsoft SQL Server
  2. Microsoft SQL Server 2005
  3. Query Syntax
  4. SSRS
  5. Databases
  6. Windows Server 2008