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...
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...
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...
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...
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.
January 21, 2013 at 2:50 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...
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...
January 21, 2013 at 2:45 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...
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
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.
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...
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.
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
January 19, 2013 at 9:54 am
Viewing 15 posts - 14,716 through 14,730 (of 49,552 total)