Explore SQL Server 2008 on Experts Exchange

Expert Solutions for Your Tech Problems

SQL Server 2008Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.C...

Read more
  • 50K Content
  • 7.1K Contributors

Expert Spotlight
IT Specialist

I am an accomplished Software Engineer specializing in Software Programming and Analysis.

Troubleshooting Question

SQL database refresh between 2016 SQL (source server/ db) and 2014 SQL ( destination server/ db)

9
i have couple 2016 SQL database that i need to migrate over to 2014 SQL.

is it possible to backup …
Research Question

how to find out any execution plan with index hints from whoisactive query log

5
hi,

right now we are using  whoisactive query log to find out missing index from query plan column of …
Troubleshooting Question

how to measure the response time of a query using whoisactive

4
Hi,

I am now given a task to calculate the mean value of the total execution time of a query in SQL …
Troubleshooting Question

sp_MSforeachtable Results

2
Hi , I have run following command
exec sp_MSforeachtable @command1='dbcc dbreindex ("?"," …
Troubleshooting Question

sp_updatestats

1
Hi Expert,
I ran wrong database with following command
is it ok to stop

exec sp_updatestats

Database is …
Troubleshooting Question

SQl server warning Message

4
Hi Experts,
When i'm looking at everytime in the SQL server 2008R2 Logs file view i'm getting …
Troubleshooting Question

SQL database single user mode

bylitmic
5
Running microsoft sql server 2017. I find a database showing (Single user) when trying to restore db …
Troubleshooting Question

Voucher Number Generation logic

7
Hi,
We are in the business of generating digital evouchers. Currently we are generating the voucher …
Troubleshooting Question

MSSQL dynamic queries and indexing

11
I want to write a query that is dynamic, sometimes the query will search 1 column, 2 columns or even …
Troubleshooting Question

backup issue

6
Hi , I have following issue after backup

An Error occured in the Microsoft .Net Framework while …
Troubleshooting Question

Updated RAM but still issue

13
Hi Experts,
I have upgraded the RAM from 20GB to 32GB, but the server takes all the memory. (see …
Troubleshooting Question

SSRS Deployment

7
We are using Microsoft SQL Server 2008 Standard Edition (64-bit) Service Pack 1.  

While installing, …
Research Question

MS SQL jobs with email alert

1
hi,

I'd like to build SQL jobs alert , as long as a SQL jobs failed it will email me, without …
Troubleshooting Question

Maximum number of row you can extract from SSAS Cube into Excel

Hi Experts

Is there a limit on the maximum number of rows, data you can pull into excel in from SSAS …
Troubleshooting Question

How so I write a Select SQL Query with  and OR Clause that will return multiple  Like'%' variables

byarmgon
3
Hey there hope you can assist me with this SQL Query.

I need to be able to return all records that …
Troubleshooting Question

SQL Error value inconsistent with data type or column length

9
I have a customer who has been using our software product for years.  its a Microsoft Access front …
Troubleshooting Question

Create a formula field on Table to accommodate scheduled task

bybfuchs
5
Hi Experts,
I have a table in Caspio that contains a field Last_Updated and have a scheduled task …
Troubleshooting Question

High Processor Usage in Virtual Machine

2
I am having issues with a VMware Virtual Machine.  The server is  Microsoft 2008 R2 Enterprise …
Troubleshooting Question

Index Maintenance Job hung during Server Restart - Sql 2008R2

5
Hello,
We have Sql 2008R2 and we are running Index Maintenance job (Index optimization) part of Ola's …
Troubleshooting Question

How to select data from a text file using SQL syntax.

bybfuchs
10
Hi Experts,

How can I use SSMS or similar to directly select records from a local text file (.txt, …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more