|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 April 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 SQL server capacity planning template Posted by Rashi at 10/7/2007 10:27:01 PM Hi
Any idea from where can I get a SQL server capacity planning template.
Thanks in advance
Rashi...more >>
disable sp_helpindes "no index" message" Posted by Jay at 10/7/2007 8:50:20 PM In using 'sp_helpindex' on 2005 & 2000, I noticed that when a table has no
indexes, I get the error message:
"The object 'tab1' does not have any indexes, or you do not have
permissions."
This is because 'sp_helpindex' is calling 'raiserror(15472,-1,-1,'tab1')'
This thing is, I would li...more >>
Where is filegroup stored in 2000 Posted by Jay at 10/7/2007 6:38:08 PM Where in SQL Server 2000 is the 'ON PRIMARY' for a table recorded?
Examining 2005, the undocumented routine 'sp_objectfilegroup' seems to be
getting it from looking at the NULL row in sys.indexes (data_space_id). I
can't figure out the 2000 equivalent.
...more >>
More INFORMATION_SCHEMA fun Posted by Jay at 10/7/2007 5:21:04 PM SQL 2005 Express
I stumbled across this doing something else (resulting from phat phingers)
and understand it is extremely unlikely someone would do this, but ...
Is this a bug, or expected behavior?
Jay
-- cut --
use tempdb
if exists (select * from sys.objects where object_id = ob...more >>
Func/proc that parses lists Posted by Jay at 10/7/2007 7:08:23 AM I saw a post some time back about a built-in function, or procedure that
cleanly dealt with a comma seperated list in a table column, but I can't
remember it (or find it).
...more >>
Getting all dates, even those with no data Posted by mst101 at 10/7/2007 2:17:56 AM Ref. Why should I consider using an auxiliary calendar table?
http://www.aspfaq.com/show.asp?id=2519
.... if you scroll down the page to "Getting all dates, even those not
represented"
.... supposing I was to add a column to the "Sales" table e.g.
"received" (a flag which shows whether or n...more >>
How to Shift a really large SQL Server Database Posted by Cyril Gupta at 10/7/2007 12:00:00 AM Hello there,
I have to shift servers from my current host, and have to shift a MS SQL
Server 2003 Express edition database from the older server to the newer computer.
I have given the Database publishing wizard a try, but the database SQL file
generated is bigger than 200 MBs in size, and...more >>
Copy Database Fails in SSMS - Invalid Object Name Posted by Charles Law at 10/7/2007 12:00:00 AM This is a carry on from my earlier post about generating scripts to recreate
a database.
Instead of generating a database script, I just tried to copy it, using the
wizard in SSMS. It fails in the same way my generated script did earlier.
I have discovered that if I send the log output to ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |