Viewing 15 posts - 44,881 through 44,895 (of 49,552 total)
If you have the mdf and the ldf, and the files aren't in use (ie already part of an existing database), you may be able to attach them to SQL....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 4:59 am
pakaw_man (8/25/2008)
i had change exec with print but the error is same, can u give another solve???? thx
Very strange. The error comes from executing the dymanic SQL. If you're not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 4:47 am
arjun.tewari (8/25/2008)
As per the database design percepective, I would like to implement such a situation using a Trigger instead of a foriegn key percpective.(Inviting others to intervene).
I'd much prefer the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 1:00 am
I'm not sure I understand your question.
Setting a variable to null is as simple as SET @VariableName = NULL
select @col1 = isnull(col1,NULL),@col2 = isnull(col2,null) from table
What are you trying...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:54 am
Hierachies is the classic example, when you have a parent-child relationship within a single table.
create table Employees (
EmployeeID int identity primary key,
EmployeeName varchar(50),
ManagerID int
)
ALTER TABLE Employees...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:49 am
Something like this should work, provided the column in question is varchar or nvarchar. If it doesn't do what you want, could you give us more details, including some sample...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:43 am
Repair should be an absolute last resort, not the first thing to try. It should also never be done without ascertaining if there is corruption and if so, how bad.
Sri:...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:40 am
Can you print out the dynamic SQL instead of an execute and post the string?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:15 am
Duplicate post.
http://www.sqlservercentral.com/Forums/Topic557937-149-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:13 am
Can you reattach the database?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2008 at 12:03 am
Could you perhaps post the query? It's hard to say how to improve something without some code to refer to.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 24, 2008 at 1:49 am
There are a couple different reasons for having multiple files in TempDB. I don't have specific numbers because they will be different for every system, depending how heavily it uses...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 24, 2008 at 1:48 am
Jack Corbett (8/22/2008)
What build level are you at? I believe this is an issue related to procedure cache and that SP2 fixed it.
The proc cache pre SP2 could grow...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2008 at 5:03 am
Functions aren't allowed to have side-effects, i.e. they aren't allowed to change the state of the database in any way.
It's so that when they are included in querues, it doesn't...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2008 at 5:01 am
I believe that you need to restart the instance before the max memory takes effect. It certainly does work (and needs to be set) on 64 bit.
100 MB's a little...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 23, 2008 at 4:50 am
Viewing 15 posts - 44,881 through 44,895 (of 49,552 total)