Viewing 15 posts - 14,716 through 14,730 (of 49,552 total)
winmansoft (1/21/2013)
If i create a file group with read only then how can i insert the values to the table?
You can't. That's what read only means.
What is the use of...
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
January 21, 2013 at 6:40 am
MyDoggieJessie (1/18/2013)
This should work right? I mean, SQL shouldnt' know the difference as long as everything is still pointing to the proper drive letter it was installed on?
As long...
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
January 21, 2013 at 5:41 am
Of course.
A tail log backup is one that's taken either with the notruncate option (if the database is damaged) or the norecovery option (if you want to switch the DB...
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
January 21, 2013 at 5:13 am
OTF (1/21/2013)
I can only imagine a writer using the term "secondary indexes" to refer to any indexes other than one on a Primary Key?
That would be an incorrect term...
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
January 21, 2013 at 5:10 am
sumith1andonly1 (1/20/2013)
any query to Check the log for database corruption.?
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Run on a regular basis.
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
January 21, 2013 at 2:50 am
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
January 21, 2013 at 2:47 am
If it was read only at the time of backup, then when you restore it, you won't need to roll the logs forward, as it was read only and hence...
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
January 21, 2013 at 2:46 am
shreekanth.kavali (1/20/2013)
pls give what are the regular issues often comes in sql server security,mean to say trouble shooting issues in sql server interms of security point of view
The only one...
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
January 21, 2013 at 2:45 am
Could you be more specific as to your problem?
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
January 20, 2013 at 11:28 am
shreekanth.kavali (1/20/2013)
can any body answer this question ? In what cases developer use cluster and non cluster index .
That's a little too vague to be answerable. Most likely a clustered...
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
January 20, 2013 at 11:26 am
Duplicate post. no replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1409286-146-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
January 20, 2013 at 11:21 am
I'll only use it if I have TempDB contention and splitting the files doesn't help. Haven't needed it since SQL 2000.
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
January 20, 2013 at 11:17 am
purushottam2 (1/19/2013)
I am supposing to set recover mode as SIMPLE and will check transaction log backup job is working or not.
One or the other. In simple recovery you can't take...
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
January 20, 2013 at 2:25 am
A function cannot call a stored procedure
A stored procedure can call a function
A view can call a function, not a stored procedure.
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
January 19, 2013 at 9:55 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1409171-391-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
January 19, 2013 at 9:54 am
Viewing 15 posts - 14,716 through 14,730 (of 49,552 total)