|
|
|
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 August 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 Partitioning the table Posted by myrights99 NO[at]SPAM gmail.com at 1/28/2007 10:56:07 PM I would like to know if Table Partition can be done on more than 2-3
columns & if any limitation is there. for e.g. i want to partition by
column DATE & TIMEZONE (for e.g. EST,CST,PST etc)
Any help is highly appreciated & thanking in advance.
...more >>
select rows as columns Posted by Ramesh Subramaniyan at 1/28/2007 9:40:00 PM
Table 1:
col1 col2 col3 col4 col 5
1 a b c d
result should be like
1 a
1 b
1 c
1 d
qyuery pls ...more >>
How to configure SQL Server 2005 such that it can handle FALSE/TRUE, # character in existing MS Access queries? Posted by Oscar at 1/28/2007 9:28:35 PM I am trying to convert a VB-MS Access application to VB-SQL Server 2005.
While the database was converted without any problem, the SQL queries need
to be changed. I need to do this for each query for the following cases :
convert a '#' character within a date value to a ' character.
convert '...more >>
cyclic bitwise shift? Posted by Sergei Shelukhin at 1/28/2007 9:03:03 PM Hi. I need to implement cyclic bitwise shift over 24-bit values in
transact sql.
Here's what I came up with:
alter function bitwiseShiftCycle24(@N int, @s smallint) returns int
as
begin
if @s = 0 return @N
declare @M bigint, @P bigint, @R bigint
select @s = case when @s < 0 then -@s el...more >>
Date format Posted by qjlee at 1/28/2007 7:56:00 PM Hi, when I select from a column OrderDate, the result comes out as something
like 2006-10-01 00:00:00.000, how can I change the result to 10/01/2006 or
2006-10-01.
Thanks,
...more >>
OVER clause and ordered calculations - feature enhancement requests Posted by Itzik Ben-Gan at 1/28/2007 7:06:43 PM SQL Server 2005 introduced only partial support for the OVER clause.
It is our strong belief that a more complete implementation of the OVER
clause should be prioritized highly in consideration for future enhancements
in SQL Server.
A more complete implementation of the OVER clause can help in...more >>
Newbie-how to combine sums from two queries Posted by Coop at 1/28/2007 7:03:01 PM Hi. I have two queries that sum records from some journals. I need to
combine the sums of the two queries and put the result in the EXPENSEYTD
field in the following table:
GOAL char 255 1
GOAL_ID char 53 1
FUND char 255 1
FUND_ID char 53 1
EXPENSESYTD decimal 9 1
/**************...more >>
shrinking database Posted by Roy Goldhammer at 1/28/2007 2:39:49 PM Hello there
I have huge log file which grouth in 1 gb more.
On the detail there is 700MB free on the log file
and when i'm shrinking it it stays 1GB with 700MB free space.
The The recovery model is FULL and the log file is being growing in 10
percent.
the only way i could shrink it ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
the DISTINCT command Posted by childofthe1980s at 1/28/2007 10:47:02 AM Hello:
I need to use the DISTINCT command in order to eliminate duplicate rows of
data for a SQL query that my Crystal report is using.
I have rarely, if ever, used this command. Is it just a matter of having
the word "DISTINCT" appear after the word "SELECT" as in "SELECT DISTINCT
FROM...more >>
Installing SQL Server 2005 Posted by Anna at 1/28/2007 9:43:43 AM Hi: I try to install SQL Server 2005 but it gives warning message. My
computer configuration is Pentium III 900 HZ, 512 RAM with operating
system windows 2000 Pro and service pack 4 and 10 GB free space. It
gives warning on operating system. Also Visual Studio. Net 2005 is
already installed ...more >>
Nested Transactions Posted by Shehab Kamal at 1/28/2007 7:19:00 AM What is the database behaviour in case of nested transactions?
Assume that we have a transaction that starts from the code which in turn
calls a stored procedure that starts and commits a transaction, the code then
rolls back the transaction. Are all the changes rolled back?
Whatever the actio...more >>
TempDB Posted by Shyam at 1/28/2007 3:37:01 AM Hi,
I experiencing this situation very frequently in the recent past.
The TempDb is increasing everyday and one fine day we are put in a space
constraint issue due to this and i'm forced to shrink the tempDB. I used
profiler,DBCC cmd,etc,etc..and nothing worked. Last time when i faced this,i...more >>
Concurrecny vs Transaction Posted by Shehab Kamal at 1/28/2007 2:50:00 AM Do concurrency and tranasaction have anything in common? In other words, can
I solve concurreny issues by simply putting everything in a start
transaction/commit pairs? From the following webcast
"http://support.microsoft.com/default.aspx?scid=kb;EN-US;817281", I learnt
that the where clause...more >>
SQL Server 2000 - ADD FILE .... TO FILEGROUP PRIMARY produces syntax error Posted by SabirBarkaat NO[at]SPAM gmail.com at 1/28/2007 1:59:20 AM Hello everyone
I'm a beginner learning SQL Server 2000, and can't figure out the
problem with the DDL code below. Apparently, I see no problem with the
code, however SQL Server produces a syntax error in Query Analyser
when I execute this code.
Can anyone help, please...!!!
ALTER DATA...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |