SQL-DBA-01 (4/30/2015)

---

HI Experts,

Whenever I'm runing query against the below database alone, it throws me the error. Any suggest why this happens?

use [AdventureWorks_2005]

SELECT * FROM dbo.sysFILES

OR

SELECT ...

Quick thought, it might be helpful to look at the sys.dm_db_index_usage_stats view.

😎

SELECT

*

FROM sys.dm_db_index_usage_stats IUS

WHERE IUS.object_id = OBJECT_ID(N'[SCHEMA_NAME.TABLE_NAME]');

ramana3327 (4/30/2015)

---

Hi,

I have a table in Server A and it has 5 columns. One is Address & ID, CreateDatetime,..

I need to transfer data from this table from Server A to...

jellybean (4/30/2015)

---

Hi,

Hope I'm in the right forum. Apologies if this is off-mark. I'm a little new to SSIS and need a little help.

I'm reverse engineering...

aprathour.89 (4/30/2015)

---

Hi Everyone,

I have a shared Sql instance having multiple databases of different Departments.

I have created a login LoginDept1 and given db_owner permission on database Dept1Db

The development team wants...

You are...

Quick thought, first of all, I think there is an error in the code as purchase registryid does not match the item id.

😎

SELECT (SELECT SUM(amount) from giftregistrypurchases gps where registryid=gi.registryid...

Few points

😎

polkadot (5/2/2015)

---

The...

Here is a partial solution, it matches the city/state but does not remove them from the address.

😎

Sample data

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_ADDRESS_WORKTABLE') IS NOT NULL DROP TABLE dbo.TBL_ADDRESS_WORKTABLE;

CREATE TABLE dbo.TBL_ADDRESS_WORKTABLE

(

...

Talib123 (5/2/2015)

---

All

How long should the latest TLOG backups be kept on tape before the media is recycled. Some suggest 2 weeks. This seems very short to me.

Corruption issues could be...

Quick question, are you using Full Text Search?

😎

Jeff Moden (5/2/2015)

---

My problem with Try/Catch in such situations is that such situations should not occur at all. Either the data is bad or the query is bad. ...

Such reliance on defaults never ceases to amaze me. First thought is ignorance and competence, finding databases on the OS drive when the server has 15K spinners for the data...

Quick suggestion, use cross tab aggregation, here is an example

😎

-- if temp table exists...drop it

if object_id('TempDB..#exams','U') is not null

drop table #exams

-- create...

jerald.wilks (5/1/2015)

---

Hi,

I am using SSIS 2008 to attempt to send data to a web service. The web service contains complex types which are not supported within Web Service Tasks. I...