Would help to see what you need done, not just a description. I know I am visual person when it comes to problem solving.

sturner (5/29/2013)

---

I actually wrote my own CopySQLTable utility. It is a command line utility and works (syntax-wise) very much like the good ol' windows copy command. You can...

Something seems amiss to me here. Is there other things going on in the stored procedure besides this one query?

Eugene Elutin (5/29/2013)

---

...

Took a quick look at it, don't like it as it uses the INFORMATION_SCHEMA views. The MS SQL system views provide much more information that is valuable...

CheeseheadDBA (5/29/2013)

---

I created the index, however unfortunately it won't help me in the long run. The reality is, is that most of the time the query does returns data -...

Lowell (5/29/2013)

---

well if you want to do it via TSQL, look at my script contribution from a while ago;

a couple of procedure sp_GetDDL and sp_getDDLa which scripts any...

Eugene Elutin (5/29/2013)

---

There is one I know.

Develop your own utility to do so.

Here is the link...

CheeseheadDBA (5/29/2013)

---

Thanks Lynn. I like that idea - however one question I have is wouldn't the use of 'like' in the query prevent the new nonclustered index from being...

CheeseheadDBA (5/29/2013)

---

Hi all,

I have a question I hope the community can help me with. I have a query that is running against a legacy system. I think I...

May I suggest reading this article: http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

How about this:

IF OBJECT_ID('tempdb..#tmp') IS NOT NULL

DROP TABLE #tmp;

CREATE TABLE #tmp (val varchar(10) primary key)

GO

INSERT INTO #tmp

SELECT '5'UNION ALL

SELECT '6DN'UNION ALL

SELECT '7'UNION ALL

SELECT '10'UNION ALL

SELECT '11DN'UNION ALL

SELECT '12'UNION ALL

SELECT '13'UNION...

Define slow.

arooj300 (5/29/2013)

---

Hi,

My database is working fine, but application is getting slow. According to the client,If they login with one or two user application is fast. If all the user login...

Can you post the requirements of what you are trying to accomplish? I sort of understand that you want to make a copy of the table and all of...

durai nagarajan (5/28/2013)

---

Possible i faced one with same scenario as my account locked that time.

I changed it to a service account it is fine now but you have to run...