We need to make a 30 GB SQL database that is going to be tested on our
fibre drives. Please point us in the right direction. Is there anyway
to generated SQL databases of any size? Thanks for your helpYou mean anyway besides the CREATE DATABASE command, which is
documented in Books Online? Create any database you like, any size,
with various options for automatic growth.
naijababy wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help|||Hi
You can create an empty database of 30GB using the TSQL create datebase
command and specifying the size as being 30GB. What you are probably going t
o
need is data that you can use in a benchmark. This will probably depend on
what tool you are going to use to perform the benchmark such as LoadRunner
http://www.mercury.com/us/products/...ter/loadrunner/
or IBM Rational performance tester
http://www-306.ibm.com/software/awd...ance/index.html or
Benchmark factory from Quest
http://www.quest.com/benchmark_factory/default.aspx. You may also want to
look at the free SQLIOStress tool if you just want to test the disc
subsystem http://support.microsoft.com/kb/231619
John
"naijababy" wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help
>
Showing posts with label point. Show all posts
Showing posts with label point. Show all posts
Friday, March 30, 2012
HOw do I make a SQL database --30GB ?
We need to make a 30 GB SQL database that is going to be tested on our
fibre drives. Please point us in the right direction. Is there anyway
to generated SQL databases of any size? Thanks for your helpYou mean anyway besides the CREATE DATABASE command, which is
documented in Books Online? Create any database you like, any size,
with various options for automatic growth.
naijababy wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help|||Hi
You can create an empty database of 30GB using the TSQL create datebase
command and specifying the size as being 30GB. What you are probably going to
need is data that you can use in a benchmark. This will probably depend on
what tool you are going to use to perform the benchmark such as LoadRunner
http://www.mercury.com/us/products/performance-center/loadrunner/
or IBM Rational performance tester
http://www-306.ibm.com/software/awdtools/tester/performance/index.html or
Benchmark factory from Quest
http://www.quest.com/benchmark_factory/default.aspx. You may also want to
look at the free SQLIOStress tool if you just want to test the disc
subsystem http://support.microsoft.com/kb/231619
John
"naijababy" wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help
>
fibre drives. Please point us in the right direction. Is there anyway
to generated SQL databases of any size? Thanks for your helpYou mean anyway besides the CREATE DATABASE command, which is
documented in Books Online? Create any database you like, any size,
with various options for automatic growth.
naijababy wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help|||Hi
You can create an empty database of 30GB using the TSQL create datebase
command and specifying the size as being 30GB. What you are probably going to
need is data that you can use in a benchmark. This will probably depend on
what tool you are going to use to perform the benchmark such as LoadRunner
http://www.mercury.com/us/products/performance-center/loadrunner/
or IBM Rational performance tester
http://www-306.ibm.com/software/awdtools/tester/performance/index.html or
Benchmark factory from Quest
http://www.quest.com/benchmark_factory/default.aspx. You may also want to
look at the free SQLIOStress tool if you just want to test the disc
subsystem http://support.microsoft.com/kb/231619
John
"naijababy" wrote:
> We need to make a 30 GB SQL database that is going to be tested on our
> fibre drives. Please point us in the right direction. Is there anyway
> to generated SQL databases of any size? Thanks for your help
>
Wednesday, March 21, 2012
How do I handle time-zones?
I need to be able to consider time-zones, including daylight savings, within
stored procedures. Can anyone point me to a resource/code base which will
either allow me to procure or build my own code? I need to do things like
determine local time based on a customer's state, zip code, city, or whateve
r
is required to truly determine the customer's local time.
Thanks,
Michael"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:20421547-C406-4AA1-8E4A-FEF5012FCE5E@.microsoft.com...
>I need to be able to consider time-zones, including daylight savings,
>within
> stored procedures. Can anyone point me to a resource/code base which will
> either allow me to procure or build my own code? I need to do things like
> determine local time based on a customer's state, zip code, city, or
> whatever
> is required to truly determine the customer's local time.
> Thanks,
> Michael
You are in for a heap of work. Especially if you need to go international.
Just a couple of notes. Daylight savings time is done differently in
different countries. IIRC, the US currently switches on the last Sunday in
October and the first Sunday in April. England switches on the last Sunday
in October and the last Sunday in March.
Some countries require a minium of 150 days of daylight savings time, so
they have different schedules every year.
If you only need to do the US, then you will need to create a stack of
lookup tables for state, zip codes and cities. You will need logic to
default if the zip code or city doesn't exist. You will need to keep in
mind also that some states like Tennesse and Texas have multiple time zones.
You will need to keep in mind that Arizona and Hawaii don't do daylight
savings time and part of Indiana doesn't either.
Google for daylight savings time and you will find a number of articles
regarding this issue.
Good luck!
Rick Sawtell|||> Just a couple of notes. Daylight savings time is done differently in
> different countries. IIRC, the US currently switches on the last Sunday
> in October and the first Sunday in April.
And to add to the fun, that changes next year!
A|||I just posted this the other day for similar question here:
http://channel9.msdn.com/ShowPost.aspx?PostID=142586
Client would still need to pass it's standard time zone name to the proc or
you could have that data stored in a table by user.
William Stacey [MVP]
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:20421547-C406-4AA1-8E4A-FEF5012FCE5E@.microsoft.com...
>I need to be able to consider time-zones, including daylight savings,
>within
> stored procedures. Can anyone point me to a resource/code base which will
> either allow me to procure or build my own code? I need to do things like
> determine local time based on a customer's state, zip code, city, or
> whatever
> is required to truly determine the customer's local time.
> Thanks,
> Michael
stored procedures. Can anyone point me to a resource/code base which will
either allow me to procure or build my own code? I need to do things like
determine local time based on a customer's state, zip code, city, or whateve
r
is required to truly determine the customer's local time.
Thanks,
Michael"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:20421547-C406-4AA1-8E4A-FEF5012FCE5E@.microsoft.com...
>I need to be able to consider time-zones, including daylight savings,
>within
> stored procedures. Can anyone point me to a resource/code base which will
> either allow me to procure or build my own code? I need to do things like
> determine local time based on a customer's state, zip code, city, or
> whatever
> is required to truly determine the customer's local time.
> Thanks,
> Michael
You are in for a heap of work. Especially if you need to go international.
Just a couple of notes. Daylight savings time is done differently in
different countries. IIRC, the US currently switches on the last Sunday in
October and the first Sunday in April. England switches on the last Sunday
in October and the last Sunday in March.
Some countries require a minium of 150 days of daylight savings time, so
they have different schedules every year.
If you only need to do the US, then you will need to create a stack of
lookup tables for state, zip codes and cities. You will need logic to
default if the zip code or city doesn't exist. You will need to keep in
mind also that some states like Tennesse and Texas have multiple time zones.
You will need to keep in mind that Arizona and Hawaii don't do daylight
savings time and part of Indiana doesn't either.
Google for daylight savings time and you will find a number of articles
regarding this issue.
Good luck!
Rick Sawtell|||> Just a couple of notes. Daylight savings time is done differently in
> different countries. IIRC, the US currently switches on the last Sunday
> in October and the first Sunday in April.
And to add to the fun, that changes next year!
A|||I just posted this the other day for similar question here:
http://channel9.msdn.com/ShowPost.aspx?PostID=142586
Client would still need to pass it's standard time zone name to the proc or
you could have that data stored in a table by user.
William Stacey [MVP]
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:20421547-C406-4AA1-8E4A-FEF5012FCE5E@.microsoft.com...
>I need to be able to consider time-zones, including daylight savings,
>within
> stored procedures. Can anyone point me to a resource/code base which will
> either allow me to procure or build my own code? I need to do things like
> determine local time based on a customer's state, zip code, city, or
> whatever
> is required to truly determine the customer's local time.
> Thanks,
> Michael
Sunday, February 19, 2012
How do I display lables outside Chart area of a Pie Chart
How do I display the labels outside of the chart area of a pie chart? The
Point Labels properties tab of the Chart Value does not show a setting to
display labels outside of the chart area. Am I missing something?
PPNote: you will need SP1 installed for this to work. The SP1 readme contains
a section about outside labels in pie charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:D2C14B13-3314-4553-AF82-41039BFE60F2@.microsoft.com...
> On the Point Labels tab uncheck the Auto checkbox n the Position secition.
> "msnews.microsoft.com" wrote:
> > How do I display the labels outside of the chart area of a pie chart?
The
> > Point Labels properties tab of the Chart Value does not show a setting
to
> > display labels outside of the chart area. Am I missing something?
> >
> > PP
> >
> >
> >
Point Labels properties tab of the Chart Value does not show a setting to
display labels outside of the chart area. Am I missing something?
PPNote: you will need SP1 installed for this to work. The SP1 readme contains
a section about outside labels in pie charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:D2C14B13-3314-4553-AF82-41039BFE60F2@.microsoft.com...
> On the Point Labels tab uncheck the Auto checkbox n the Position secition.
> "msnews.microsoft.com" wrote:
> > How do I display the labels outside of the chart area of a pie chart?
The
> > Point Labels properties tab of the Chart Value does not show a setting
to
> > display labels outside of the chart area. Am I missing something?
> >
> > PP
> >
> >
> >
Subscribe to:
Posts (Atom)