Database Best Practices for index values
Listen to the ‘database side of you’. That approach has many benefits, including normalization and data integrity. —————– Tables are very useful for parsing, particularly where the values are static. Another benefit – Parsing text down to keys or ‘tokens’ and referencing via the table can greatly reduce overhead.
View Answer
| February 18, 2010 10:38 PM
ASP.NET, SQL Server, SQL Server 2008
Listen to the ‘database side of you’. That approach has many benefits, including normalization and data integrity. —————– Tables are very useful for parsing, particularly where the values are static. Another benefit – Parsing text down to keys or ‘tokens’ and referencing via the table can greatly reduce overhead.
View Answer
| February 18, 2010 10:38 PM
ASP.NET, SQL Server, SQL Server 2008
mssql login script
This is possible. I have a script that does something similiar but I am using integrated security. Check out this link as I think it will help you out. http://www.sqlmusings.com/2009/04/29/sql-server-powershell-basics-connecting-to-sql-server/ You can check out some of mine here. http://itknowledgeexchange.techtarget.com/dba/powershell-ping/ http://itknowledgeexchange.techtarget.com/dba/sql-ping-servers-improved/ http://itknowledgeexchange.techtarget.com/dba/powershell-ping-cont/ Feel free to use my code or take out parts you need and do [...]
View Answer
| February 18, 2010 9:10 PM
MSSQL, PowerShell Scripts, SQL 2005, SQL scripts, Windows Server 2008
This is possible. I have a script that does something similiar but I am using integrated security. Check out this link as I think it will help you out. http://www.sqlmusings.com/2009/04/29/sql-server-powershell-basics-connecting-to-sql-server/ You can check out some of mine here. http://itknowledgeexchange.techtarget.com/dba/powershell-ping/ http://itknowledgeexchange.techtarget.com/dba/sql-ping-servers-improved/ http://itknowledgeexchange.techtarget.com/dba/powershell-ping-cont/ Feel free to use my code or take out parts you need and do [...]
View Answer
| February 18, 2010 9:10 PM
MSSQL, PowerShell Scripts, SQL 2005, SQL scripts, Windows Server 2008
SQL server STD 05 between Sites
With SQL Server 2005 you can use Database Mirroring if that is what you are looking for. You do not have the ability for Snapshotting and Parallel Redo but the basic features are available to you. Check out this link for more information. http://technet.microsoft.com/en-us/library/cc917680.aspx
View Answer
| February 18, 2010 8:44 PM
sql link sycn, SQL Server 2005, SQL Server 2005 Standard Edition, SQL Server connectivity
With SQL Server 2005 you can use Database Mirroring if that is what you are looking for. You do not have the ability for Snapshotting and Parallel Redo but the basic features are available to you. Check out this link for more information. http://technet.microsoft.com/en-us/library/cc917680.aspx
View Answer
| February 18, 2010 8:44 PM
sql link sycn, SQL Server 2005, SQL Server 2005 Standard Edition, SQL Server connectivity
Intel’s Open Port IT Scavenger Hunt has launched: Win a laptop and other great prizes.
The scavanger hunt was fun, thanks! I had not heard of this technology, looks very useful indeed. Good opportunity to learn about something new. Great idea!
View Answer
| February 18, 2010 5:55 PM
AS/400, Contests, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Point Challenge, Microsoft Windows, Mobile, Networking, Security, SQL Server
The scavanger hunt was fun, thanks! I had not heard of this technology, looks very useful indeed. Good opportunity to learn about something new. Great idea!
View Answer
| February 18, 2010 5:55 PM
AS/400, Contests, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Point Challenge, Microsoft Windows, Mobile, Networking, Security, SQL Server
ISA Server 2000 error 12202
Are you trying to access a web site while using the Browser on the ISA Server, ou need to create a static packet filter that allows outbound port 80 to all computer, or configure the Browser as a Web Proxy client, configuring it with the IP address of the internal interface of the ISA Server.
View Answer
| February 17, 2010 9:23 PM
ISA Server, ISA Server 2000, ISA server error, ISA Server Error 122202
Are you trying to access a web site while using the Browser on the ISA Server, ou need to create a static packet filter that allows outbound port 80 to all computer, or configure the Browser as a Web Proxy client, configuring it with the IP address of the internal interface of the ISA Server.
View Answer
| February 17, 2010 9:23 PM
ISA Server, ISA Server 2000, ISA server error, ISA Server Error 122202
where clause condtion as a variable (SSIS 2005)
try using dynamic sql in a stored procedure. Something like this: declare @sql varchar(1000) declare @tablename varchar(100) set @sql = ‘SELECT * FROM ‘ set @tablename = ‘database.schema.tablename’ set @sql = @sql + @tablename exec ( @sql )
View Answer
| February 17, 2010 5:27 PM
SSIS, SSIS 2005, WHERE condition
try using dynamic sql in a stored procedure. Something like this: declare @sql varchar(1000) declare @tablename varchar(100) set @sql = ‘SELECT * FROM ‘ set @tablename = ‘database.schema.tablename’ set @sql = @sql + @tablename exec ( @sql )
View Answer
| February 17, 2010 5:27 PM
SSIS, SSIS 2005, WHERE condition
Auditing users of STRSQL
Consider setting an exit program for the STRSQL command against the QIBM_QCA_RTV_COMMAND exit point. (Or possibly the QIBM_QCA_CHG_COMMAND exit point.) When your exit program is called, run STRDBMON for the job. The DB monitor will end when the job ends. You might want to mark the fact that the DB monitor had already been started [...]
View Answer
| February 17, 2010 3:14 AM
SQL, SQL audit, STRSQL
Consider setting an exit program for the STRSQL command against the QIBM_QCA_RTV_COMMAND exit point. (Or possibly the QIBM_QCA_CHG_COMMAND exit point.) When your exit program is called, run STRDBMON for the job. The DB monitor will end when the job ends. You might want to mark the fact that the DB monitor had already been started [...]
View Answer
| February 17, 2010 3:14 AM
SQL, SQL audit, STRSQL
SQL Access Query
I spelled the work update incorrectly in the question but in the statement it is spelled correctly.
View Answer
| February 16, 2010 11:02 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
I spelled the work update incorrectly in the question but in the statement it is spelled correctly.
View Answer
| February 16, 2010 11:02 AM
Access Datasheet, Access query, Microsoft Access, SQL, SQL Access, SQL Query
a question about IMPORT/EXPORT from the SQL 2005 Migration
Not really, that’s pretty much your option. For importing data use the BULK INSERT command from a login which is a member of the bulkadmin fixed server role. As for exporting data that’ll need to be done via SSIS which will require that you break apart the stored procedures. The easiest solution isn’t always the [...]
View Answer
| February 15, 2010 5:47 PM
SQL 2005, sql 2005 Migration
Not really, that’s pretty much your option. For importing data use the BULK INSERT command from a login which is a member of the bulkadmin fixed server role. As for exporting data that’ll need to be done via SSIS which will require that you break apart the stored procedures. The easiest solution isn’t always the [...]
View Answer
| February 15, 2010 5:47 PM
SQL 2005, sql 2005 Migration
Multiple databases on a server – SQL
There shouldn’t be any problem having them on the same physical server as long as you don’t have them both trying to listen on the same TCP port.
View Answer
| February 15, 2010 5:34 PM
PostgreSQL, SQL, SQL Database, SQL Server databases
There shouldn’t be any problem having them on the same physical server as long as you don’t have them both trying to listen on the same TCP port.
View Answer
| February 15, 2010 5:34 PM
PostgreSQL, SQL, SQL Database, SQL Server databases
SQL 2008 stored procedures and execution plans
Buy having lots of extra parameters you may cause the SQL Server to use the wrong index because of the cached execution plan. Because of this it can be better to break them out. Each system is different, and SQL can sometimes deal with this just fine. If you break out the options into a [...]
View Answer
| February 15, 2010 5:32 PM
SQL Server 2008, SQL Server 2008 extended stored procedures, SQL Server stored procedures
Buy having lots of extra parameters you may cause the SQL Server to use the wrong index because of the cached execution plan. Because of this it can be better to break them out. Each system is different, and SQL can sometimes deal with this just fine. If you break out the options into a [...]
View Answer
| February 15, 2010 5:32 PM
SQL Server 2008, SQL Server 2008 extended stored procedures, SQL Server stored procedures
about oracle with Java
“<b>The steward of Java software</b> <i>Java is one of the computer industry’s best known brands and most widely deployed technologies. Oracle Fusion Middleware is built on Java technology in support of applications and services written in the Java language. With the acquisition of Sun, Oracle will drive continued innovation and investment in Java technology for [...]
View Answer
| February 15, 2010 1:20 PM
Java, Oracle Careers, Oracle developers, Oracle with Java, SQL, SQL Plus
“<b>The steward of Java software</b> <i>Java is one of the computer industry’s best known brands and most widely deployed technologies. Oracle Fusion Middleware is built on Java technology in support of applications and services written in the Java language. With the acquisition of Sun, Oracle will drive continued innovation and investment in Java technology for [...]
View Answer
| February 15, 2010 1:20 PM
Java, Oracle Careers, Oracle developers, Oracle with Java, SQL, SQL Plus
sql server 2005 service will not start
What is written to the ERRORLOG file when it doesn’t start up correctly?
View Answer
| February 12, 2010 11:32 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity
What is written to the ERRORLOG file when it doesn’t start up correctly?
View Answer
| February 12, 2010 11:32 PM
SQL Server 2005, SQL Server 2005 connectivity, SQL Server connectivity
Adding and removing disk space for SQL2000
To do this you’ll need to create a new LUN on the SAN and present it to SQL_SVR_A. Then stop the SQL Server, move the database files to the new smaller drive, keeping all the folder paths the same. Switch the drive letters on the two volumes. Then start the SQL Server Service again. All [...]
View Answer
| February 11, 2010 8:34 PM
SQL Server 2000
To do this you’ll need to create a new LUN on the SAN and present it to SQL_SVR_A. Then stop the SQL Server, move the database files to the new smaller drive, keeping all the folder paths the same. Switch the drive letters on the two volumes. Then start the SQL Server Service again. All [...]
View Answer
| February 11, 2010 8:34 PM
SQL Server 2000
varchar(max) size limit
varchar(max) stores up to 2 Gigs of data per row per column. The SQL Server Management Studio will only show 8k by default. When you look at the value in your application it will show all the data (unless the application is designed to only show 8k characters).
View Answer
| February 11, 2010 8:31 PM
SQL Server, VARCHAR
varchar(max) stores up to 2 Gigs of data per row per column. The SQL Server Management Studio will only show 8k by default. When you look at the value in your application it will show all the data (unless the application is designed to only show 8k characters).
View Answer
| February 11, 2010 8:31 PM
SQL Server, VARCHAR
Procedure cache ratio calculation in SQL Server?
You can get the amount of procedure cache in use, and the procedure cache hit ratio from perfmon or from the sys.dm_os_performance_counters DMV.
View Answer
| February 11, 2010 5:01 PM
SQL Server, SQL Server 2005, SQL Server stored procedures
You can get the amount of procedure cache in use, and the procedure cache hit ratio from perfmon or from the sys.dm_os_performance_counters DMV.
View Answer
| February 11, 2010 5:01 PM
SQL Server, SQL Server 2005, SQL Server stored procedures
Query paging per second in SQL Server
I assume you are looking for memory counters? That data is all available in perfmon or from the sys.dm_os_performance_counters DMV.
View Answer
| February 11, 2010 4:57 PM
SQL Server
I assume you are looking for memory counters? That data is all available in perfmon or from the sys.dm_os_performance_counters DMV.
View Answer
| February 11, 2010 4:57 PM
SQL Server
SQL SERVER 2005 Performance Monitoring
Depends on what “similar” means to you. Performance Monitor comes with the OS and likely can be setup to do most everything you want with a bit of work. You can use the Alerts functionality to perform actions based upon defined thresholds. As a step up from this, you can use Power Shell to pull [...]
View Answer
| February 9, 2010 9:33 PM
SQL Server 2005, SQL Server performance, SQL Server Performance Monitoring, SQL Server performance tuning
Depends on what “similar” means to you. Performance Monitor comes with the OS and likely can be setup to do most everything you want with a bit of work. You can use the Alerts functionality to perform actions based upon defined thresholds. As a step up from this, you can use Power Shell to pull [...]
View Answer
| February 9, 2010 9:33 PM
SQL Server 2005, SQL Server performance, SQL Server Performance Monitoring, SQL Server performance tuning
Linking Visual Basics and SQL database
I’m not too sure about any MySQL libraries written for VB6, but what you can do is use the <a href=”http://dev.mysql.com/doc/refman/5.1/en/connector-odbc.html”>MySQL ODBC driver</a> and use ODBC in your VB6 app. <a href=”http://www.timesheetsmts.com/adotutorial.htm”>Here</a> is a link on how to use ODBC with vb6.
View Answer
| February 9, 2010 8:57 PM
SQL Database, Visual Basic
I’m not too sure about any MySQL libraries written for VB6, but what you can do is use the <a href=”http://dev.mysql.com/doc/refman/5.1/en/connector-odbc.html”>MySQL ODBC driver</a> and use ODBC in your VB6 app. <a href=”http://www.timesheetsmts.com/adotutorial.htm”>Here</a> is a link on how to use ODBC with vb6.
View Answer
| February 9, 2010 8:57 PM
SQL Database, Visual Basic
difference between t- and pl sql lang
There are many things you can do with both pl/sql and t-sql, <b>but the syntax is different</b> in most cases, also, there might be some things you can do with one of them but not with the other. T-SQL is used with MS SQL Server databases (mainly), and PL/SQL is used with Oracle databases. ——————–
View Answer
| February 8, 2010 1:39 PM
PL/SQL, T-SQL
There are many things you can do with both pl/sql and t-sql, <b>but the syntax is different</b> in most cases, also, there might be some things you can do with one of them but not with the other. T-SQL is used with MS SQL Server databases (mainly), and PL/SQL is used with Oracle databases. ——————–
View Answer
| February 8, 2010 1:39 PM
PL/SQL, T-SQL
