Monday, July 8, 2013

[SQL Server 2008 issues] Tempdb issue

[SQL Server 2008 issues] Tempdb issue

Tempdb issue

Posted: 07 Jul 2013 04:42 PM PDT

we are facing issue in tempdb file size , initial size we allocate 2 GB , but after restart sql server , size would be 1 MB , its gone 2 GB, plz anyone help , How size will keeping on 2 GB after restart sql server ..Any settings ? ThanksJerry

Difference between Full backup and Copy-only full backup

Posted: 07 Jul 2013 06:13 PM PDT

I saw in this [url=http://www.sqlservercentral.com/Forums/Topic567010-357-1.aspx#bm1311005]link[/url] that full backup does not truncate the log.So what is the difference between full backup and copy-only full backup?For the log backup there is copy-only backup which prevent the log chain from breaking without truncating the log. So what is copy-only full backup?

Maxium rownum groupwise

Posted: 07 Jul 2013 06:37 PM PDT

create table #Abc(ID int,Name varchar(20),SAl int,Rownum int)insert #Abc values(1,'Anees',1000,1)insert #Abc values(2,'Rick',1200,1)insert #Abc values(3,'John',1100,1)insert #Abc values(3,'John',1500,2)insert #Abc values(3,'John',1200,3)insert #Abc values(4,'stephen',1300,1)insert #Abc values(5,'Maria',1400,1)insert #Abc values(6,'MariaN',1400,1)insert #Abc values(6,'MariaN',60000,2)O/p:ID Name Sal Rownum1 Anees 1000.00 12 Rick 1200.00 13 John 1100.00 13 John 1500.00 23 John 1200.00 34 Stephen 1300.00 15 Maria 1400.00 16 MariaN 1400.00 16 MariaN 60000.00 2so i need the table like the given belowID Name Sal Rownum1 Anees 1000.00 12 Rick 1200.00 13 John 1200.00 34 Stephen 1300.00 15 Maria 1400.00 16 MariaN 60000.00 2so plz help me

Unknown error messages during generate script from SQL2008 database

Posted: 23 Mar 2009 12:11 PM PDT

I have a SQL2008 database, running Standard Edition 64-bit, database owns by sa, connected to Management Studio using Windows Authentication mode. When I tried to generate scripts from a database, I got the following error messages:-[Operation is not valid due to the current state of the object. (SqlManagerUI)]which happened at one particular table. I have reviewed this table definitions are normal, and I could select data from it. I couldn't find any information anywhere relating to this error messages, except that someone got it when they were trying to change the authentication mode or sa password. Anybody got this similar scenario ? any idea would be appreciated....Wai

Regular Mirroring Timeout Error Messages

Posted: 07 Jul 2013 11:22 AM PDT

We are running SQL Server 2008R2 RTM (10.50.1617)We get time out messages that read like "the mirroring connection for database has timed out after 90 seconds" too often. Now I have only been a DBA for 6 months of my life, but these messages pop up at least once a week, and if we had not increased the threshold fail overs would be happening regularly as well.I would like to know if a more seasoned DBA's opinion on this. I talked with the systems/networking guys and they see nothing unusual in terms of the computers performance and network traffic and have looked at the ip traffic logs on the switches.I am trying to push them to update to service pack 3 hoping that will smooth things out. I also read that upping the cpu priority could help. I would love to hear your opinions, and if i should pressure them to do this. Thanks

Auditing - no machine name? Really?

Posted: 07 Jul 2013 11:48 AM PDT

I'm going through trialing out Auditing using this example:http://blogs.msdn.com/b/sql_shep/archive/2012/06/27/sql-2012-security-audit.aspxWhat I can't understand though is that it doesn't store the source machine name or ip address. Am I missing something?

syntax for using /SET for SSIS config file in SQL 2008?

Posted: 07 Jul 2013 03:06 AM PDT

I used to use /CONF to represent an XML config file running SSIS packages via DTExec with SQL 2005. With the behavior change of SQL 2008 (some variables are no longer getting the CONFIG file value) I am attempting to use the /SET option to pull in the XML config file. Has anyone else done this? With the following code:set job=Run_DepartmentJobset dtsxName="DepartmentJob"set dtexecLocation="d:\DTExec.exe"set dtsxPath="X:\SIS\DepartmentJob.dtsx"set dtsxConfigPath="X:\SSIS\Config_files\DepartmentJob.dtsConfig"call %dtexecLocation% /F %dtsxPath% /SET "\Package.Configurations[Config].Properties[ConfigurationString]";%dtsxConfigPath% /CHECKPOINTING OFF >> %pathout%%job%.OUTI am getting the following error:DTExec: Could not set \Package.Configurations[Config].Properties[ConfigurationString] value to X:\SSIS\Config_files\DepartmentJob.dtsConfig.Is the syntax off?I LIKED the ability to use a CONFIG file in SQL 2005 to set environment specific values for my SSIS packages. That option made deploying to different environments very easy. I don't understand why Microsoft would change the behavior of this option. Are there any other alternatives that people are now using to access XML Config files when running SQL 2008 SSIS packages with DTExec?Thanks!
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog