Viewing 15 posts - 6,376 through 6,390 (of 7,185 total)
Davor
I can't think of any way of doing that server-side. You'd need to configure your application to do that.
John
June 4, 2007 at 12:56 am
Anders
That'll probably be it, then. A quick fumble in Books Online and I found this: "Scalar-valued functions must be invoked by using at least the two-part name of the function". ...
June 1, 2007 at 8:08 am
Davor
If you change the default schema of the calling user to dbo then you shouldn't need to qualify the name of the function. Bear in mind that if the user...
June 1, 2007 at 4:29 am
One more thing in favour of separate instances is collation. Although you can have different collations for each database (indeed you can specify collation down to the column level), if...
June 1, 2007 at 4:08 am
Carl
I'm not sure about using -c -m. I've only tried it with -f. See if that works for you.
John
May 31, 2007 at 8:53 am
Yes, or back up msdb2 and restore as msdb. This has the advantage of avoiding stopping SQL Server (I think you can restore msdb without starting SQL Server with special...
May 31, 2007 at 8:39 am
Carl
The mssqlsystemresource database has to be moved to the same location as master, but it doesn't automatically get moved with it. Start the server with the parameters /f /T3608, then...
May 31, 2007 at 8:34 am
Jan
Yes, but only the data in the indexed columns. Going back to my example, if you wanted SELECT d, e, f FROM MyTable WHERE a = 10, the index would...
May 31, 2007 at 6:04 am
Jan
A covering index is a covering index with respect to a particular query. So if your table contains columns a, b, c, d and f, and you have a non-clustered index...
May 31, 2007 at 4:15 am
Ganesh
Not sure how well this would perform, but one way of doing it would be to create a temp table with an identity column, say tempID. Create an index on...
May 31, 2007 at 4:07 am
I think the DENSE_RANK function is what you're looking for.
John
May 31, 2007 at 3:54 am
Backup
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/89a4658a-62f1-4289-8982-f072229720a1.htm
Restore
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/877ecd57-3f2e-4237-890a-08f16e944ef1.htm
May 30, 2007 at 7:57 am
Andrew
This is tedious if you've pasted a lot of lines in, but it works. At the end of each line, delete the carriage return and then hold down Shift and...
May 30, 2007 at 3:13 am
Are you saying you think SP2 has broken it, or that you think it might be fixed by SP2? I couldn't find SQL Server Agent mentioned in the SP2 bug fix...
May 30, 2007 at 1:32 am
Andrew
Your first reference should always be Books Online. You get a much quicker answer than you do here!
DROP INDEX 'tablename.indexname'
John
May 29, 2007 at 8:57 am
Viewing 15 posts - 6,376 through 6,390 (of 7,185 total)