Viewing 15 posts - 42,016 through 42,030 (of 49,562 total)
madhu.arda (1/3/2009)
January 4, 2009 at 2:29 am
It could be that someone's done an adhoc backup to a drive other than Z. Use the following to see the backup history.
select * from msdb..backupmediafamily
January 3, 2009 at 12:11 pm
waykna (1/3/2009)
I omitted the ORDER BY, given that there's an index on the two PK fields being selected.
An index is not a guarantee of the order of the data returned....
January 3, 2009 at 11:17 am
I finally managed to get everything working again, and have a look at your procs. There's a few things I noticed that could be potential problems.
fnGetTerrTree_2:
FROM Users
CROSS APPLY (
SELECT v.TerriId
FROM...
January 3, 2009 at 9:59 am
ColumnName LIKE '%/%' ESCAPE '/'
With a character defined as an escape character, any character that follows that in the LIKE will be treated as a literal value.
January 3, 2009 at 9:51 am
Roy Matthews (1/2/2009)
I'm getting the same problem. What is the solution to this?
All data access via stored procedures, grant only execute permissions on the procs and no rights to...
January 3, 2009 at 7:48 am
RBarryYoung (1/2/2009)
Can you show us the execution plan?
Additionally, the schema of the tables and the index definitions would be of great help.
January 3, 2009 at 7:44 am
thuybui (1/2/2009)
A database is in "It is in the middle of a restore" state. How do I release that state for that database? Thanks.
What did you do to get it...
January 3, 2009 at 7:37 am
Is autoshrink on for that database?
January 3, 2009 at 7:34 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in the...
January 3, 2009 at 7:31 am
What's this function supposed to do?
I'd offer help in getting rid of the cursor, but I have absolutely no idea what it's doing.
January 3, 2009 at 7:26 am
madhu.arda (1/2/2009)
We have data files on D drive and log files on F drive and tempd on G drive and Backups are Z drive
Are those separate physical drives, or partitions...
January 3, 2009 at 7:25 am
branovuk (1/2/2009)
"...A full database backup backs up the whole database. This includes part of the transaction log so that the...
January 3, 2009 at 7:08 am
Mad-Dog (1/2/2009)
SQL 2005.yes i'm seeing that my tempdb database sometimes grow for 40-50GB.
That's not what I asked. I asked if you're seeing large temp tables that stay around for...
January 2, 2009 at 5:31 am
If you create an inline table-valued function (which you have, by specifying just RETURNS TABLE), it must be a single select statement. If you want control flow, then you need...
January 2, 2009 at 5:02 am
Viewing 15 posts - 42,016 through 42,030 (of 49,562 total)