Viewing 15 posts - 661 through 675 (of 1,479 total)
I don’t think that you can do it in a different day, but the question is what are you trying to do that you need to get random records from...
February 11, 2010 at 4:14 am
NewID() function produces a new value each time you run it, so the first and second query shouldn’t produce the same records. If you need to produce the...
February 11, 2010 at 3:39 am
The problem is that you have a none valid date. The Hijri calendar has 12 months. Each month has 30 or 29 days. Most of the years...
February 11, 2010 at 1:55 am
I’m not expert on the subject, but it seems to me that you got a none valid date. I think that this is just like getting the date Feb...
February 11, 2010 at 12:03 am
Acutely Hijri calendar has the structure of dd/mm/yyyy (you can check it in BOL at the explanation about convert function), but I think that the 12th month doesn’t have 30...
February 10, 2010 at 11:35 pm
You can rename the originals database’s files. Then create a new database with the exact same name and files (name and location) as the original database. Stop the...
February 10, 2010 at 7:49 am
Yes you can, as long as it is used for development purpose only
Adi
February 10, 2010 at 7:16 am
Lynn Pettis (2/10/2010)
I ran the following: select convert(datetime, '8/12/1430' , 131) and it returned 2009-11-25 00:00:00.000. Is that correct?
Unfortunately I have to admit that I was wrong. ...
February 10, 2010 at 7:03 am
As far as I know the server doesn’t care where you are running the query from. A query should have the exact same query plan regardless of the client...
February 10, 2010 at 5:40 am
This means that the server had a query and that query could have benefited from an index that is based on the columns Status_ind, , Formated_City and State_ID. ...
February 10, 2010 at 5:26 am
wschampheleer (2/10/2010)
Don't have access to SQL2K anymore 🙂 but try the view sys.triggers and look for the column modify_date.
SQL Server 2000 did not have the sys schema, so there is...
February 10, 2010 at 5:04 am
Unfortunately you can’t. The year 1430 can not be used in datetime data type. If you’ll try to use it, you’ll get an out of range error.
Adi
February 10, 2010 at 5:00 am
subbarayudu.net 37258 (2/9/2010)
Next record is kept on 5th partition, it means the fifth partition how many record are kept. its upto next 25000 or remaining...
February 9, 2010 at 11:52 am
My guess is that you created this partitioning function:
CREATE PARTITION FUNCTION WhatEverNameYouSelected (int)
AS RANGE LEFT FOR VALUES (25000, 50000, 75000, 100000)
This function doesn’t create 4 partitions. It creates...
February 8, 2010 at 11:30 pm
As I already wrote before – it depends on the partitioning function and the value that you inserted into the column that the partitioning is based on. Without knowing...
February 8, 2010 at 10:17 pm
Viewing 15 posts - 661 through 675 (of 1,479 total)