I have a data file that is set to automatically grow 10%. 11858 MB was allo
cated to the database, whose max growth was set to 15000 MB. There was 0 MB
space free for about an hour. I had to go into Enterprise Manager and chan
ge the space allocated from
11858 MB to 13000 MB and the data file grew fine.
I don't understand why it didn't automatically grow. All of our databases a
re set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
Has anyone seen this issue before?
Thank you very much for your time.
MelanieSometimes autogrow doesn't catch up, quite simply. We see this from time to
time, and I've seen at least one technical description for a scenario where
this can happen (but I don't recall details). There might be KB articles
about specific scenarios, but fact still stand...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Melanie" <anonymous@.discussions.microsoft.com> wrote in message
news:C6D5E793-85CB-4345-93BB-5FBAC9AD028D@.microsoft.com...
> I have a data file that is set to automatically grow 10%. 11858 MB was
allocated to the database, whose max growth was set to 15000 MB. There was
0 MB space free for about an hour. I had to go into Enterprise Manager and
change the space allocated from 11858 MB to 13000 MB and the data file grew
fine.
> I don't understand why it didn't automatically grow. All of our databases
are set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
> Has anyone seen this issue before?
> Thank you very much for your time.
> Melanie
Showing posts with label automatically. Show all posts
Showing posts with label automatically. Show all posts
Tuesday, March 27, 2012
Data File Did Not Automatically Grow
I have a data file that is set to automatically grow 10%. 11858 MB was allocated to the database, whose max growth was set to 15000 MB. There was 0 MB space free for about an hour. I had to go into Enterprise Manager and change the space allocated from 11858 MB to 13000 MB and the data file grew fine
I don't understand why it didn't automatically grow. All of our databases are set to auto grow and we have never had this problem. There is 8 GB free on the drive that the data file resides
Has anyone seen this issue before
Thank you very much for your time
MelanieSometimes autogrow doesn't catch up, quite simply. We see this from time to
time, and I've seen at least one technical description for a scenario where
this can happen (but I don't recall details). There might be KB articles
about specific scenarios, but fact still stand...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Melanie" <anonymous@.discussions.microsoft.com> wrote in message
news:C6D5E793-85CB-4345-93BB-5FBAC9AD028D@.microsoft.com...
> I have a data file that is set to automatically grow 10%. 11858 MB was
allocated to the database, whose max growth was set to 15000 MB. There was
0 MB space free for about an hour. I had to go into Enterprise Manager and
change the space allocated from 11858 MB to 13000 MB and the data file grew
fine.
> I don't understand why it didn't automatically grow. All of our databases
are set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
> Has anyone seen this issue before?
> Thank you very much for your time.
> Melanie
I don't understand why it didn't automatically grow. All of our databases are set to auto grow and we have never had this problem. There is 8 GB free on the drive that the data file resides
Has anyone seen this issue before
Thank you very much for your time
MelanieSometimes autogrow doesn't catch up, quite simply. We see this from time to
time, and I've seen at least one technical description for a scenario where
this can happen (but I don't recall details). There might be KB articles
about specific scenarios, but fact still stand...
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Melanie" <anonymous@.discussions.microsoft.com> wrote in message
news:C6D5E793-85CB-4345-93BB-5FBAC9AD028D@.microsoft.com...
> I have a data file that is set to automatically grow 10%. 11858 MB was
allocated to the database, whose max growth was set to 15000 MB. There was
0 MB space free for about an hour. I had to go into Enterprise Manager and
change the space allocated from 11858 MB to 13000 MB and the data file grew
fine.
> I don't understand why it didn't automatically grow. All of our databases
are set to auto grow and we have never had this problem. There is 8 GB free
on the drive that the data file resides.
> Has anyone seen this issue before?
> Thank you very much for your time.
> Melanie
Data extension question?
Hi,
when you use sql server data extension and set the query to a stored
proceduere, Reporting services automatically creates report parameters based
on the stored proc parameters. I'm creating a custom data processing
extension and i would like to create parameters based on a config file. How
do i do this?
thanks
shankarIn your custom data processing extension, you should implement
IDbCommandAnalysis. In GetParameters, you can access your config file.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"shankar" <sramasubramanian@.ozcap.com> wrote in message
news:uk7P%23hXdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> Hi,
> when you use sql server data extension and set the query to a stored
> proceduere, Reporting services automatically creates report parameters
based
> on the stored proc parameters. I'm creating a custom data processing
> extension and i would like to create parameters based on a config file.
How
> do i do this?
> thanks
> shankar
>|||Thanks, Chris. I have one more question. I implemented IDbCommandAnalysis
interface and i got all the parameters from my config file. In the config
file , i also stored designer default values for all the parameter. I would
like the Reportdesigner to use the designer value when it executes the query
command. You could view the designer value as dummy value. For Example, if
you are using sql server stored proc, you would pass all the required
parameter as a part of command text.
When i implemented, IDbCommandAnalysis interface, i passed this
parameter,designer value pair. I think reporting services uses this
interface only to get the list of parameters and it simply ignores default
value.Is there any way to do this.
thanks
shankar
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:ueGeyMadEHA.2384@.TK2MSFTNGP09.phx.gbl...
> In your custom data processing extension, you should implement
> IDbCommandAnalysis. In GetParameters, you can access your config file.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "shankar" <sramasubramanian@.ozcap.com> wrote in message
> news:uk7P%23hXdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > when you use sql server data extension and set the query to a stored
> > proceduere, Reporting services automatically creates report parameters
> based
> > on the stored proc parameters. I'm creating a custom data processing
> > extension and i would like to create parameters based on a config file.
> How
> > do i do this?
> >
> > thanks
> >
> > shankar
> >
> >
>|||That is correct. The design tool uses the interface only to obtain the
parameter names, not to retrieve default values.
Using it for default values as well is a good idea. I'll forward it on to
the designer team. Thanks.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"shankar" <sramasubramanian@.ozcap.com> wrote in message
news:OjXL2YLeEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Thanks, Chris. I have one more question. I implemented IDbCommandAnalysis
> interface and i got all the parameters from my config file. In the config
> file , i also stored designer default values for all the parameter. I
would
> like the Reportdesigner to use the designer value when it executes the
query
> command. You could view the designer value as dummy value. For Example, if
> you are using sql server stored proc, you would pass all the required
> parameter as a part of command text.
> When i implemented, IDbCommandAnalysis interface, i passed this
> parameter,designer value pair. I think reporting services uses this
> interface only to get the list of parameters and it simply ignores default
> value.Is there any way to do this.
> thanks
> shankar
> "Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
> news:ueGeyMadEHA.2384@.TK2MSFTNGP09.phx.gbl...
> > In your custom data processing extension, you should implement
> > IDbCommandAnalysis. In GetParameters, you can access your config file.
> >
> > --
> > This post is provided 'AS IS' with no warranties, and confers no rights.
> All
> > rights reserved. Some assembly required. Batteries not included. Your
> > mileage may vary. Objects in mirror may be closer than they appear. No
> user
> > serviceable parts inside. Opening cover voids warranty. Keep out of
reach
> of
> > children under 3.
> > "shankar" <sramasubramanian@.ozcap.com> wrote in message
> > news:uk7P%23hXdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > when you use sql server data extension and set the query to a
stored
> > > proceduere, Reporting services automatically creates report parameters
> > based
> > > on the stored proc parameters. I'm creating a custom data processing
> > > extension and i would like to create parameters based on a config
file.
> > How
> > > do i do this?
> > >
> > > thanks
> > >
> > > shankar
> > >
> > >
> >
> >
>
when you use sql server data extension and set the query to a stored
proceduere, Reporting services automatically creates report parameters based
on the stored proc parameters. I'm creating a custom data processing
extension and i would like to create parameters based on a config file. How
do i do this?
thanks
shankarIn your custom data processing extension, you should implement
IDbCommandAnalysis. In GetParameters, you can access your config file.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"shankar" <sramasubramanian@.ozcap.com> wrote in message
news:uk7P%23hXdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> Hi,
> when you use sql server data extension and set the query to a stored
> proceduere, Reporting services automatically creates report parameters
based
> on the stored proc parameters. I'm creating a custom data processing
> extension and i would like to create parameters based on a config file.
How
> do i do this?
> thanks
> shankar
>|||Thanks, Chris. I have one more question. I implemented IDbCommandAnalysis
interface and i got all the parameters from my config file. In the config
file , i also stored designer default values for all the parameter. I would
like the Reportdesigner to use the designer value when it executes the query
command. You could view the designer value as dummy value. For Example, if
you are using sql server stored proc, you would pass all the required
parameter as a part of command text.
When i implemented, IDbCommandAnalysis interface, i passed this
parameter,designer value pair. I think reporting services uses this
interface only to get the list of parameters and it simply ignores default
value.Is there any way to do this.
thanks
shankar
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:ueGeyMadEHA.2384@.TK2MSFTNGP09.phx.gbl...
> In your custom data processing extension, you should implement
> IDbCommandAnalysis. In GetParameters, you can access your config file.
> --
> This post is provided 'AS IS' with no warranties, and confers no rights.
All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No
user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach
of
> children under 3.
> "shankar" <sramasubramanian@.ozcap.com> wrote in message
> news:uk7P%23hXdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> > when you use sql server data extension and set the query to a stored
> > proceduere, Reporting services automatically creates report parameters
> based
> > on the stored proc parameters. I'm creating a custom data processing
> > extension and i would like to create parameters based on a config file.
> How
> > do i do this?
> >
> > thanks
> >
> > shankar
> >
> >
>|||That is correct. The design tool uses the interface only to obtain the
parameter names, not to retrieve default values.
Using it for default values as well is a good idea. I'll forward it on to
the designer team. Thanks.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"shankar" <sramasubramanian@.ozcap.com> wrote in message
news:OjXL2YLeEHA.3864@.TK2MSFTNGP10.phx.gbl...
> Thanks, Chris. I have one more question. I implemented IDbCommandAnalysis
> interface and i got all the parameters from my config file. In the config
> file , i also stored designer default values for all the parameter. I
would
> like the Reportdesigner to use the designer value when it executes the
query
> command. You could view the designer value as dummy value. For Example, if
> you are using sql server stored proc, you would pass all the required
> parameter as a part of command text.
> When i implemented, IDbCommandAnalysis interface, i passed this
> parameter,designer value pair. I think reporting services uses this
> interface only to get the list of parameters and it simply ignores default
> value.Is there any way to do this.
> thanks
> shankar
> "Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
> news:ueGeyMadEHA.2384@.TK2MSFTNGP09.phx.gbl...
> > In your custom data processing extension, you should implement
> > IDbCommandAnalysis. In GetParameters, you can access your config file.
> >
> > --
> > This post is provided 'AS IS' with no warranties, and confers no rights.
> All
> > rights reserved. Some assembly required. Batteries not included. Your
> > mileage may vary. Objects in mirror may be closer than they appear. No
> user
> > serviceable parts inside. Opening cover voids warranty. Keep out of
reach
> of
> > children under 3.
> > "shankar" <sramasubramanian@.ozcap.com> wrote in message
> > news:uk7P%23hXdEHA.3132@.TK2MSFTNGP11.phx.gbl...
> > > Hi,
> > > when you use sql server data extension and set the query to a
stored
> > > proceduere, Reporting services automatically creates report parameters
> > based
> > > on the stored proc parameters. I'm creating a custom data processing
> > > extension and i would like to create parameters based on a config
file.
> > How
> > > do i do this?
> > >
> > > thanks
> > >
> > > shankar
> > >
> > >
> >
> >
>
Thursday, March 8, 2012
Data Change
Can anybody suggest the best way I can achieve the following.
To select anybody whose surname has change in the last week, and to automatically flag a code field with "C". :cool:Hi,
Does your table have date field which is updated everytime a user updates the table?|||Yes I have found that it has a Modifcation Date field.|||Is there anyway to tell whether it is the surname that has been updated? Or could it be another field?|||Are you looking for a general solution, or is this a one-time issue?
For a general solution, you should use a trigger to stamp a datefield anytime a surname is modified.
For a one-time solution, restore a backup of your table from a week ago under a different name, and then join them on their primary keys to compare surnames.
....you do have weekly backups, right?|||if you have no record of this information,(the prior updating of the surname) you will need to create a audit column or and audit table then you can create a trigger that will indicate as such from here on out.
here are some {books online} articles you might want to look at.
Create Trigger
Alter Trigger
Programming Triggers
To select anybody whose surname has change in the last week, and to automatically flag a code field with "C". :cool:Hi,
Does your table have date field which is updated everytime a user updates the table?|||Yes I have found that it has a Modifcation Date field.|||Is there anyway to tell whether it is the surname that has been updated? Or could it be another field?|||Are you looking for a general solution, or is this a one-time issue?
For a general solution, you should use a trigger to stamp a datefield anytime a surname is modified.
For a one-time solution, restore a backup of your table from a week ago under a different name, and then join them on their primary keys to compare surnames.
....you do have weekly backups, right?|||if you have no record of this information,(the prior updating of the surname) you will need to create a audit column or and audit table then you can create a trigger that will indicate as such from here on out.
here are some {books online} articles you might want to look at.
Create Trigger
Alter Trigger
Programming Triggers
Sunday, February 19, 2012
Daily build - trying to deploy from the command line
Hi
I'm trying to automate the build of a SSIS VisualStudio solution (ie I want to generate the deploy package automatically), but I get a weird error:
Error: Could not get a list of SSIS packages from the project.
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========
I get this error when launching devenv with the following command-line:
devenv.exe MySolution.sln /Deploy development /Out build.log
Did anyone already meet this error ? How can I avoid that ?
regards
Thibaut
I should add that this error only appears when I set the CreateDeploymentUtility variable to true under the Deployment Utility section of the properties...|||Hi
Is there actually a anyone launching devenv.exe to generate the deployment packages ?
If no, is there any other known alternative ? (the idea is to automate the deployment package creation on a build server).
any hint will be most welcome.
regards
Thibaut|||
This link might help.
http://mgarner.wordpress.com/2006/08/31/automating-ssis-deployment/
Daily build - trying to deploy from the command line
Hi
I'm trying to automate the build of a SSIS VisualStudio solution (ie I want to generate the deploy package automatically), but I get a weird error:
Error: Could not get a list of SSIS packages from the project.
========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========
I get this error when launching devenv with the following command-line:
devenv.exe MySolution.sln /Deploy development /Out build.log
Did anyone already meet this error ? How can I avoid that ?
regards
Thibaut
I should add that this error only appears when I set the CreateDeploymentUtility variable to true under the Deployment Utility section of the properties...|||Hi
Is there actually a anyone launching devenv.exe to generate the deployment packages ?
If no, is there any other known alternative ? (the idea is to automate the deployment package creation on a build server).
any hint will be most welcome.
regards
Thibaut|||
This link might help.
http://mgarner.wordpress.com/2006/08/31/automating-ssis-deployment/
Subscribe to:
Posts (Atom)