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
SQL Server DBA & Architect, EE Solution Guide

I'm a SQL Server Architect experienced in Design, Development, Administration, Performance Tuning.. Exploring BI, SSIS & Data Science Arena!

Research Question

MS SQL capacity planning.

4

Hi,


Try to create a capacity planning guide, any good URL and doc you can refer me to have a look ?


Troubleshooting Question

Displaying results in a SSRS Tooltip of the records in a row and or column from a matrix or tablix?

Trying to get a tooltip to display a value from records returned.

 


RR UR XR Total R
Location Count % Count %
Troubleshooting Question

Database return timeout message how to solve

6

Hi All,

I 'm using MS SQL 2008. Recently one of my module in my application slow to output data or

Troubleshooting Question

SSIS passing parameter values from a file

byiBinc
8
using an SSIS package that has two parameters passed via package variables, how can I pass values to…
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

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

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

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