Viewing 15 posts - 661 through 675 (of 1,478 total)
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 10, 2010 at 7:49 am
Yes you can, as long as it is used for development purpose only
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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. ...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 10:17 pm
Eduard (2/8/2010)
- with a clustered index: correct for the data level of the pages.
however the intermediate lvl is controlled by pad index. if it's off it will...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 8, 2010 at 8:36 am
Viewing 15 posts - 661 through 675 (of 1,478 total)