TeraByteMe (5/3/2015)

---

I started a new position recently and my Manager says there is a UDF out on a database but I can't find it anywhere not under object explorer in...

OsborneHar (5/3/2015)

---

Restore from the SQL Server backups or use SQL Server Repair Toolbox. The MS SQL repair tool reads *.mdf and *.ndf files and saves data, structure, links, etc. as...

MotivateMan1394 (5/3/2015)

---

Hi again

I have 2 Functions in my Query. (then 2 columns in my query's output)

Function 1 : calculate a value on check a state field. (get values from...

Here is an addition to the previous code, nothing fancy but it should work most of the time

😎

USE tempdb;

GO

SET NOCOUNT ON;

SELECT

AW.Id

,CS.city_state_ID

...

GilaMonster (5/2/2015)

---

With the SOLE exception of read committed snapshot, isolation levels are effective from the SET TRANSACTION ISOLATION LEVEL statement until the end of the batch or until the isolation...

Paul Webb-223029 (5/1/2015)

---

I have a T-SQL query that outputs exactly as I wish when run via Management Studio. I now want to automate this query to run monthly via...

Markus (5/1/2015)

---

We have a SQL Server 2008R2 system that has heavy usage to one specific table. I have tuned basically all I can as far as making sure SQL...

sqlvitoco (4/30/2015)

---

Hello.

I have a flow that includes a Foreach Loop Container that loads many files into a table. Also, the last task in the flow sends an "OK" email, and...

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...