Viewing 15 posts - 46,651 through 46,665 (of 49,571 total)
Not with any SQL backup tool. They allow you to backup the entre database or a file of the database.
You could export the table to CSV. You could make a...
May 9, 2008 at 12:32 am
The user on the database that your published site uses does not have select permissions on the tables. It's probably just got exec on the procs.
Inline SQL (especially if concatenated...
May 9, 2008 at 12:20 am
Seconded. Shrink = really bad idea.
It also appears you don't have an index rebuild happening anywhere. Is that the case?
May 9, 2008 at 12:17 am
To prevent SQL injection completely:
- Use only stored procedures or properly parameterised queries from your web app
- Do not concatenate SQL statements and execute them. either in the web page...
May 9, 2008 at 12:05 am
Depends what the column says. It gives you the reason the log is not been reused.
Typical things I've seen - Replication, backup, active transaction, mirroring.
Each needs to be treated differently.
May 9, 2008 at 12:00 am
I've also seen it bring the system to an absolute halt during an auto grow.
You're right on the dropped obejcts. While I've seen Ghost cleanup tidying up after a drop,...
May 8, 2008 at 11:55 pm
Marios Philippopoulos (5/8/2008)
Gail, thanks for the info, I've wondering about this for quite some time...
Don't take it as authoritative, since I can't remember the source.
May 8, 2008 at 11:35 am
I seem to recall reading somewhere that MAXDOP limited the number of running threads, not the total number of threads overall that a query could spawn.
If that's correct, then with...
May 8, 2008 at 11:08 am
Do you not have a backup?
There is a way, but it will cause data loss. No idea how much, or from which table.
Please run the following...
DBCC CHECKDB('msdb') WITH NO_INFOMSGS
May 8, 2008 at 10:41 am
TheSQLGuru (5/8/2008)
2. Functions can result in poor performance.3. Functions can result in REALLY REALLY BAD performance. 🙂
6. Did I mention that functions are often bad for performance?? 😀
Especially...
May 8, 2008 at 10:02 am
Probably early-mid June for the full session list. Probably spotlights earlier.
End of May is the date they gave for feedback on submitted abstracts.
May 8, 2008 at 9:33 am
What are the blocks/waits on? What wait type? What resource?
May 8, 2008 at 8:45 am
Viewing 15 posts - 46,651 through 46,665 (of 49,571 total)