Viewing 15 posts - 3,271 through 3,285 (of 5,394 total)
josephsheppard (4/4/2011)
Would a [nolock] help?
No, unless you understand that NOLOCK means reading inconsistent data and can live with it.
josephsheppard (4/4/2011)
The problem is...
April 4, 2011 at 7:20 am
Take a look at the article linked in my signature line and you will find out what is needed to post a question properly.
We don't have enough information to answer...
April 4, 2011 at 7:16 am
Ninja's_RGR'us (4/4/2011)
I've simply pasted working code so that he gets the idea of sum(case when period).
That requires...
April 4, 2011 at 6:42 am
Ninja's_RGR'us (4/4/2011)
-- ... some code here ...
Are you sure?
April 4, 2011 at 6:32 am
I don't see UNION ALL, I see UNIONs here.
UNION means distinct values and distinct means expensive sorts.
Can you post table scripts and execution plan?
April 4, 2011 at 6:25 am
Looks like it is trying to upgrade an existing installation, instead of performing a fresh install.
Maybe some dirty registry keys?
April 4, 2011 at 5:58 am
balaji.ganga 68339 (4/4/2011)
i used the dbcc shrink file un documented command. but its too late to delete the table.
Is...
April 4, 2011 at 5:51 am
balaji.ganga 68339 (4/4/2011)
I need to two things:1. To delete the unnecessary data.
2. we don't want the transaction log during delete operation.
No, trust me, you really want it to be...
April 4, 2011 at 4:31 am
Well thats it, from what I find they are both the same database instance.
Does DB1 server have a process named "sqlserver.exe"? If not, no SQL Server instance is running.
Open DB1...
April 4, 2011 at 4:24 am
You will have to issue this statement on each of the target servers:
CREATE LOGIN [YOURDOMAIN\fxb-dss-fsx-sqladmin] FROM WINDOWS
WITH DEFAULT_DATABASE= [tempdb],
...
April 4, 2011 at 4:18 am
OK, let's start from the obvious: if there's a SQL Server you can connect to on DB1, there must be an instance of SQL Server running. I don't know why...
April 4, 2011 at 3:34 am
Add the group to sql server logins on all of your servers.
You're not saying much about the role of the users in this group, can you please specify what will...
April 4, 2011 at 3:14 am
We have two instances on our SQL 2005 setup, DB1 and DB2 to name them. Each instance have the exact same databases / tables. When data is updated...
April 4, 2011 at 3:04 am
No, it's not related to math functions.
You have a correlated subquery when you select data from a subquery using a where clause that refers to fields in the outer query.
Example:
SELECT...
April 1, 2011 at 3:47 pm
Roy Ernest (4/1/2011)
Shaken and hurts. Other wise I am Ok. Thx
Too bad.
Just remember that cars can be fixed, people cannot. The important thing is that you're ok.
April 1, 2011 at 10:26 am
Viewing 15 posts - 3,271 through 3,285 (of 5,394 total)