Viewing 15 posts - 43,201 through 43,215 (of 49,571 total)
By default the only max for connections is the maximum allowed by SQL which is 32767. If you're reaching that many concurrent connections on a dev system, I think you...
November 12, 2008 at 7:07 am
You can have a look at the sys.dm_exec_query_stats DMV. That contains execution counts and CPU, read, write and duration stats.
Unfortunately the info's only there while the plan for that...
November 12, 2008 at 6:52 am
That's security through obscurity and it doesn't work. It makes it harder to find the sensitive data, not impossible.
Plus that now requires file backups synced with DB backups, careful security...
November 12, 2008 at 6:41 am
Amit Gupta (11/12/2008)
yes i have other plan in a feature suggest me solution.
Sorry, I don't understand.
November 12, 2008 at 6:36 am
Henk Schreij (11/12/2008)
The data are now in the correct order in the ID (the clustered PK).Thank you 😎
Excellent.
Just be aware that doesn't mean that the data will be returned in...
November 12, 2008 at 6:35 am
Anu (11/12/2008)
there is ... there have to be..
Yes. Restore a backup.
If you don't have a backup you don't get your data back. That's the point of a backup. SQL...
November 12, 2008 at 6:32 am
krayknot (11/12/2008)
he wants to hide the table and he can hide the xml.
Where? In another table? In the file system? Some other place?
November 12, 2008 at 1:27 am
Backup restore isn't a good option here. Two things you can consider.
Database mirroring with a database snapshot on the mirror. The snapshot is readonly and is an image of the...
November 12, 2008 at 1:24 am
kokila (11/12/2008)
Is there any other way so that we can only analyze and find out the problem.
You can download a debugger (http://www.microsoft.com/whdc/devtools/debugging/default.mspx), point it's symbols path at MS's public symbols...
November 12, 2008 at 1:11 am
Anu (11/12/2008)
any way sql server have the facility to get back the older state like restore . if any tiger know that plzz enclose the information.
Yup! Restore a backup that...
November 12, 2008 at 12:50 am
Just be careful with SP3. What's available right now is RC0 - a release candidate. It's still in testing and there may still be bugs. It should not be applied...
November 12, 2008 at 12:46 am
rbarryyoung (11/11/2008)
November 12, 2008 at 12:37 am
That's easy enough. Restore the full with no recovery and each day copy the diff over and restore that with norecovery.
What do you want to do with the second server?...
November 12, 2008 at 12:36 am
krayknot (11/12/2008)
yesstore the pricing in xml and at the tiime of requirement, call the xml data in table variable (if the size is upto medium) and use temp table temprarily.
How...
November 12, 2008 at 12:35 am
Chirag (11/11/2008)
You will have to re-create all your jobs, maintenance plans etc.
And DTS packages and SSIS packages. You've also lost the backup history.
Now, go and set up a backup schedule...
November 12, 2008 at 12:33 am
Viewing 15 posts - 43,201 through 43,215 (of 49,571 total)