| Groups | Blog | Home |
|
March 2003 April 2003 May 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 |
Filter by week: 1 2 3 4 5 what to do about slow performance using dateDiff Posted by Dica at 5/12/2006 1:17:42 PM my client wants to be able to pull records for contributors based on months
since their last donation. so, i have to select max(contributionDate) and
then determine the number of months since that date until today's date using
dateDiff. this is giving me incredibly slow performance (2.5 mins to p...more >>
Can't connect to Reporting Services after I rename my computer Posted by csoprasanna NO[at]SPAM gmail.com at 5/11/2006 5:51:24 PM Hi,
I have installed SQL 2005 on my Windows 2003 box. After I install SQL
2005, I have configured the Reporting Services and I can connect using
the Management Studio. I had to rename my machine and after I renamed I
can still connect to Database Services from Management Studio. However
I a...more >>
Query DTS Data Posted by Pippen at 5/11/2006 5:29:46 PM I'm trying to write query to find stored procs that may be used in a DTS
package. I have used the following for finding stored procs in jobs. I was
hoping there was something similar for DTS.
-- run in the msdb database.
select
j.Originating_Server,j.Name,j.Enabled,s.Step_Name,s.Command,j....more >>
Deleted half the rows from a table but it's still the same size Posted by pshroads NO[at]SPAM gmail.com at 5/11/2006 11:35:56 AM We have recently started archiving data in our database. With some of
the tables that I've archived I see a reduction in the physical size of
the table when I delete rows. In other words if I delete 50% of the
rows the amount of disk space the table uses also drop by close to 50%
But there are...more >>
Using index question Posted by wildturtle NO[at]SPAM gmail.com at 5/10/2006 6:45:24 AM Hi,
is it worth to use an index on a table that will have about 200 rows
max. I tried to add a clustered index on one of the fields, the query
plan showed improvement, but I still think it is pretty useless to add
a clustered index on a non-selective char(1) field. Although the query
plan showe...more >>
BLOB performance SQL 2005 Do's and Don'ts Posted by km200281 at 5/10/2006 6:33:39 AM Hi,
I have a content based site with over a 1000 downloadable word docs
which are currently stored on a server filesystem.
however these are split in muliple folder paths for different clients
and i am trying to find a more efficient way of doing this. i have
been looking into storing the fi...more >>
Can MSDE and SQL live on the same system? Posted by Clayton Sutton at 5/9/2006 3:52:31 PM Hey everyone,
We are running MSDE on a Windows 200 server and it has data in it. What I
would like to know is can we also install MSSQL 2005 on that server and have
assess to both databases. Is there anything we have to do to install it and
make sure it doesn't overwrite or delete the MSD...more >>
why is dateDiff(m,theDate) so much slower than dateDiff(yyyy,theDate)? Posted by Dica at 5/9/2006 1:57:12 PM i've written two functions that return the dateDiff in months or years. if i
use the dateDiff month function in a where statement, i get incredible slow
response times (2.35 seconds vs calling the dateDiff year function which
returns the results in 1 second). the two functions are almost exactly ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
After installed SQL server 2005, can't work SQL server management studio Posted by Wang Xiaoning at 5/9/2006 11:26:19 AM I have the SQL sever 2005 enterrpise version installed, then after
start from management studio, i am not able to connect to any local
database, even i run create sample database, but seems i can't find it
from local server. did i miss something?
also, do the enterrpise version includes Report...more >>
Question about restore LOG Backup an Transaction Log Posted by Gordowey at 5/9/2006 9:07:11 AM Hi all, I would like to know the best way to schedule the FullBkps and
LOG Bkps, to minimize data loss in case of crash
I have 1 'Backup Device' for DBBackup and one 'Backup device' for my
LOgs.
See below my actual schedule sequence
Time 00:00 LOG BKP (overwrite)
time 01:00 FullBack up...more >>
SQL best practices questions Posted by jtfaulk NO[at]SPAM eudoramail.com at 5/8/2006 3:15:33 PM Hello I'm wondering about a few SQL best practices, and which one is
faster/better:
1. INNER JOIN VS. NOT USING INNER JOIN
SELECT A.VAR1, A.VAR2, B.VAR3
FROM TABLE1 A, TABLE2 B
WHERE A.QID = B.QID
VS.
SELECT A.VAR1, A.VAR2, B.VAR3
FROM TABLE1 A
INNER JOIN TABLE2 B ON A.QID = B.QID...more >>
how to free Log file space after backup? Posted by Gordowey at 5/8/2006 6:24:53 AM Hi all, i have a simple question..
I have a DB with FULL recovery model. My Log file grows too faster, and
I have to backup it regularly (each 8 hours), but I would like to Know
how can i free the space used by the Trans Log after backup
I mean, my xxxx_log.ldf is about 13GB, after backup it...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |