Cost to upgrade to MS SQL Server 2008
Here’s the link to the breakdown of pricing for SQL 2008 http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx
View Answer
| June 9, 2010 6:52 PM
SQL Server, SQL Server 2008, SQL Server licensing, SQL Server Upgrade
Here’s the link to the breakdown of pricing for SQL 2008 http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx
View Answer
| June 9, 2010 6:52 PM
SQL Server, SQL Server 2008, SQL Server licensing, SQL Server Upgrade
To write a stored procedure
We might need a little more info on this. A stored procedure usually takes some input, applies some logic, and returns a result. If the second table already has Zipcode and Congressional District, why do you need to join them? Simply querying the second table would give the desired result. Making some assumptions… ZipCode table [...]
View Answer
| June 9, 2010 6:38 PM
Relational databases, SQL Server stored procedures, Stored Procedures
We might need a little more info on this. A stored procedure usually takes some input, applies some logic, and returns a result. If the second table already has Zipcode and Congressional District, why do you need to join them? Simply querying the second table would give the desired result. Making some assumptions… ZipCode table [...]
View Answer
| June 9, 2010 6:38 PM
Relational databases, SQL Server stored procedures, Stored Procedures
ACCESS ERROR CHARACTERS FOUND AT THE END OF SQL STATEMENT
If you are running that as a query, you can run just one SQL statement at a time (anything after the first semicolon will generate an error).
View Answer
| June 8, 2010 6:08 PM
Access errors, Microsoft Access, SQL, SQL Access
If you are running that as a query, you can run just one SQL statement at a time (anything after the first semicolon will generate an error).
View Answer
| June 8, 2010 6:08 PM
Access errors, Microsoft Access, SQL, SQL Access
SQL server query to search for table and column data in database
depending on the version of sql server there are a number of ways of finding this. Try looking at the systables view in your database to track down the table. You can then look at the columns in the table Alternatively use the sql server management tools to view the database structure
View Answer
| June 8, 2010 5:47 PM
SQL Database, SQL Developer, SQL development, SQL Server Query
depending on the version of sql server there are a number of ways of finding this. Try looking at the systables view in your database to track down the table. You can then look at the columns in the table Alternatively use the sql server management tools to view the database structure
View Answer
| June 8, 2010 5:47 PM
SQL Database, SQL Developer, SQL development, SQL Server Query
SP Dynamic SQL with LIKE Operator
One problem is the parameter definition – you need to specify the maximum dimension of the VARCHAR parameter in, otherwise it will only use the first character. I would suggest you dynamically create the comparison string, as follows: <pre>CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR(255) as declare @Variable2 varchar(255); set @Variable2 = ‘%’ + coalesce(@Variable1,”) + ‘%’; [...]
View Answer
| June 8, 2010 5:12 PM
Dynamic SQL, SQL Server 2005, SQL stored procedures, Stored Procedure variables
One problem is the parameter definition – you need to specify the maximum dimension of the VARCHAR parameter in, otherwise it will only use the first character. I would suggest you dynamically create the comparison string, as follows: <pre>CREATE PROCEDURE SPFIND @VARIABLE1 VARCHAR(255) as declare @Variable2 varchar(255); set @Variable2 = ‘%’ + coalesce(@Variable1,”) + ‘%’; [...]
View Answer
| June 8, 2010 5:12 PM
Dynamic SQL, SQL Server 2005, SQL stored procedures, Stored Procedure variables
SQL View performance vs. SELECT
A view is not compiled. Its a virtual table made up of other tables. When you create it doesn’t reside somewhere on your server. The underlying queries that make up the view are subject to the same performance gains or dings of the query optimizer. I’ve never tested performance on a view VS its underlying [...]
View Answer
| June 8, 2010 1:39 PM
SELECT statement, SQL Server performance, SQL Server views
A view is not compiled. Its a virtual table made up of other tables. When you create it doesn’t reside somewhere on your server. The underlying queries that make up the view are subject to the same performance gains or dings of the query optimizer. I’ve never tested performance on a view VS its underlying [...]
View Answer
| June 8, 2010 1:39 PM
SELECT statement, SQL Server performance, SQL Server views
SQL indexes
Not quite sure what you are talking about here. Indexes don’t have results, they are sorted copies of the data in the table. You can’t query an index to get the data from is specifically, you query the table, and if using an index to find the data is a more efficient process, then the [...]
View Answer
| June 4, 2010 6:58 PM
sql indexes, SQL Server, T-SQL
Not quite sure what you are talking about here. Indexes don’t have results, they are sorted copies of the data in the table. You can’t query an index to get the data from is specifically, you query the table, and if using an index to find the data is a more efficient process, then the [...]
View Answer
| June 4, 2010 6:58 PM
sql indexes, SQL Server, T-SQL
Event Viewer
When you close the Event Viewer console, any filter you have set is lost. The next time you open the Event Viewer, you see all default events. However, you can create your own Event Viewer console to retain a filter from session to session. Follow these steps to create the console: Go to Start | [...]
View Answer
| June 1, 2010 8:34 PM
DataCenter, Desktops, DHCP, DNS, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Networking, Networking services, OS, Performance management, Remote management, Security, Servers, SQL Server, TCP, Tech support
When you close the Event Viewer console, any filter you have set is lost. The next time you open the Event Viewer, you see all default events. However, you can create your own Event Viewer console to retain a filter from session to session. Follow these steps to create the console: Go to Start | [...]
View Answer
| June 1, 2010 8:34 PM
DataCenter, Desktops, DHCP, DNS, Management, Microsoft Office, Microsoft Windows, Network management software, Network monitoring, Networking, Networking services, OS, Performance management, Remote management, Security, Servers, SQL Server, TCP, Tech support
Spatial query optimizing
I found the solution, but I’m not sure I understand why. Apparently the SQL server on my development machine uses the spacial index by default, but the production machine does not. I added “WITH (INDEX (geog_sidx))” to the query and now it runs just as fast on the production machine and the execution plan looks [...]
View Answer
| June 1, 2010 1:10 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data
I found the solution, but I’m not sure I understand why. Apparently the SQL server on my development machine uses the spacial index by default, but the production machine does not. I added “WITH (INDEX (geog_sidx))” to the query and now it runs just as fast on the production machine and the execution plan looks [...]
View Answer
| June 1, 2010 1:10 PM
SQL Server, SQL Server Express, SQL Server query optimization, SQL Server Spatial Data
How to restore MDF file as backup database
An MDF file isn’t a backup file isn’t the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks [...]
View Answer
| April 18, 2013 10:44 AM
Backup, Database, MDF, Restore
An MDF file isn’t a backup file isn’t the main data file (or master data file depending on who you ask) hence the file extension MDF. You can attach the MDF to the database by right clicking on the databases folder in Enterprise Manager (SQL 2000) or Management Studio (SQL 2005) then selecting all tasks [...]
View Answer
| April 18, 2013 10:44 AM
Backup, Database, MDF, Restore
Passing parameters to report viewer
Hi, If, all you want is to hide the report viewer’s parameters pane, you can do it by writing code- MyReportViewer.ShowParameterPrompts = false; If you want to hide a single parameter, write the code - reportParameterCollection[0].Visible = false; Since you told your are new even to c#, here are the sample codes for you to [...]
View Answer
| April 19, 2013 4:27 AM
C, C# .NET, Parameters, SSRS
Hi, If, all you want is to hide the report viewer’s parameters pane, you can do it by writing code- MyReportViewer.ShowParameterPrompts = false; If you want to hide a single parameter, write the code - reportParameterCollection[0].Visible = false; Since you told your are new even to c#, here are the sample codes for you to [...]
View Answer
| April 19, 2013 4:27 AM
C, C# .NET, Parameters, SSRS
Virtualizing SQL
I don’t see why it wouldn’t work as designed. The only thing that one should consider is that workstation had better have ample resources to run not only its own OS but the SQL Server too. —– Yes you can do that. The virtual machine will need to have a server OS on it and [...]
View Answer
| May 29, 2010 1:52 AM
SQL Server 2000, Virtualization, Virtualization in 2010, VM Workstation
I don’t see why it wouldn’t work as designed. The only thing that one should consider is that workstation had better have ample resources to run not only its own OS but the SQL Server too. —– Yes you can do that. The virtual machine will need to have a server OS on it and [...]
View Answer
| May 29, 2010 1:52 AM
SQL Server 2000, Virtualization, Virtualization in 2010, VM Workstation
Sql Server CAL
CALs aren’t per connected user, but per named users. If you already have the SQL Server CPU license then there is no additional cost. If you change the license there’s a cost and no savings.
View Answer
| May 27, 2010 9:16 PM
SQL, SQL Server, SQL Server CAL licensing, SQL Server Enterprise Edition
CALs aren’t per connected user, but per named users. If you already have the SQL Server CPU license then there is no additional cost. If you change the license there’s a cost and no savings.
View Answer
| May 27, 2010 9:16 PM
SQL, SQL Server, SQL Server CAL licensing, SQL Server Enterprise Edition
SQL 2005 Database Compare
<a href=”http://www.redgate.com”>Redgate </a>has a product called Schema Compare which does exactly this.
View Answer
| May 27, 2010 8:58 PM
SQL 2005, SQL 2005 Database, SQL Database, Stored Procedures
<a href=”http://www.redgate.com”>Redgate </a>has a product called Schema Compare which does exactly this.
View Answer
| May 27, 2010 8:58 PM
SQL 2005, SQL 2005 Database, SQL Database, Stored Procedures
Sponsor Post: Live Expert Chat 6/1: Drive Your Business Forward with SharePoint 2010
Ahh, it works something like Notes/Domino.
View Answer
| May 27, 2010 7:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
Ahh, it works something like Notes/Domino.
View Answer
| May 27, 2010 7:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, ITKE, ITKE Community, Linux, Lotus, Microsoft Live Chat, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP
How to find who called a stored procedure
select ORIGINAL_LOGIN() - this will return the user account login, usually like databaseusername select SYSTEM_USER - generally the same result, but if the context was changed, this will reflect the current user context instead of the original login above I don’t know of a way to get the name of the procedure that actually called [...]
View Answer
| May 27, 2010 6:36 PM
SQL Server, SQL Server 2005, SQL Server 2005 SP3, Stored Procedures
select ORIGINAL_LOGIN() - this will return the user account login, usually like databaseusername select SYSTEM_USER - generally the same result, but if the context was changed, this will reflect the current user context instead of the original login above I don’t know of a way to get the name of the procedure that actually called [...]
View Answer
| May 27, 2010 6:36 PM
SQL Server, SQL Server 2005, SQL Server 2005 SP3, Stored Procedures
Subquery only returns column names
“<i>I can only get column names to return</i>” This means that there are no records matching your WHERE clause. Then only query that includes a WHERE clause is this: <pre>select distinct SubjectID, clinicdate, Marker, MaxSpd from dbo.BBP_JerkCost_STATS051810 where Marker IN (‘JR_RBHo’,'LL_JRo’,'LL_RBHo’,'RC_LCo’,'UL_RBHo’,'UL_LLo’,'UL_RC_LL_LCo’) and MaxSpd is not NULL AND SubjectID = ’0069′ </pre> And it is not [...]
View Answer
| May 27, 2010 1:52 PM
SQL Query, SQL Server Query, Subquery
“<i>I can only get column names to return</i>” This means that there are no records matching your WHERE clause. Then only query that includes a WHERE clause is this: <pre>select distinct SubjectID, clinicdate, Marker, MaxSpd from dbo.BBP_JerkCost_STATS051810 where Marker IN (‘JR_RBHo’,'LL_JRo’,'LL_RBHo’,'RC_LCo’,'UL_RBHo’,'UL_LLo’,'UL_RC_LL_LCo’) and MaxSpd is not NULL AND SubjectID = ’0069′ </pre> And it is not [...]
View Answer
| May 27, 2010 1:52 PM
SQL Query, SQL Server Query, Subquery
Java Code to Copy AS400 file to SQL Server database/table
Start here : http://www.scottklement.com/presentations/#EXTERNALDB ******************************************************************************
View Answer
| May 26, 2010 2:07 AM
AS/400, Java, Java code, SQL Server, SQL Server database
Start here : http://www.scottklement.com/presentations/#EXTERNALDB ******************************************************************************
View Answer
| May 26, 2010 2:07 AM
AS/400, Java, Java code, SQL Server, SQL Server database
SQL Syntax Error SQL0104
A right parenthesis is missing in line 3: <pre>3 cast(max(ifnull(ext.cost,0)) as decimal(11,2)<b>)</b> as stdcost</pre> Commas <b>could be</b> missing at the end of lines 3-7 ———– As noted above, commas do seem to be missing between many of the column definitions. It <i>appears</i> as if commas should be at the ends of lines 2 through 7. [...]
View Answer
| May 26, 2010 1:02 AM
SQL, SQL error messages, SQL Statement Syntax Errors, Syntax errors
A right parenthesis is missing in line 3: <pre>3 cast(max(ifnull(ext.cost,0)) as decimal(11,2)<b>)</b> as stdcost</pre> Commas <b>could be</b> missing at the end of lines 3-7 ———– As noted above, commas do seem to be missing between many of the column definitions. It <i>appears</i> as if commas should be at the ends of lines 2 through 7. [...]
View Answer
| May 26, 2010 1:02 AM
SQL, SQL error messages, SQL Statement Syntax Errors, Syntax errors
File access restriction for users in Logmein
In this case the SQL Server files can’t be copied (via LogMeIn or any other method) unless the SQL Server service is stopped. To answer your question directly no there are no specific settings in LogMeIn to block the user from downloading specific files other than the person on your side would need to approve [...]
View Answer
| May 25, 2010 5:43 AM
LogMeIn, Remote access, Restricted User Group, SQL Database
In this case the SQL Server files can’t be copied (via LogMeIn or any other method) unless the SQL Server service is stopped. To answer your question directly no there are no specific settings in LogMeIn to block the user from downloading specific files other than the person on your side would need to approve [...]
View Answer
| May 25, 2010 5:43 AM
LogMeIn, Remote access, Restricted User Group, SQL Database
