Hello,
We are an engineering company located in Jessup, Maryland. Â We have a SQL Server 2012 system set up on our network.
We are wondering: Â what is the difference between local and global temp tables? Â Does your company have experience working with these types of tables?
Rich
Hello Will
I am running a MySQL query from the linux command line and I need to output the results in CSV format. I need an efficient way to extract that information with the from MySQL that is properly escapes any quotes that exist in the data.
Thank you
Jim from Washington DC
Hi Will
I would like to add something like “last updated the xx/xx/200x” on my page.
Can you tell me what the best way to do that is? Are there any functions that will retrieve the last updated date?
Kim from Rockville
The following guide helps you to troubleshoot your SQL Server if its running very slow:
First check the processor and memory usage to see that processor is not above 80% utilization and memory not above 40-45% utilization then check the disk utilization using Performance Monitor, Secondly, use SQL Profiler to check for the users and current SQL activities and jobs running which might be a problem. Third would be to run UPDATE_STATISTICS command to update the indexes.
CCD
Hello Will
I have a bottleneck in some part of my .net programming code that I need to measure the time it takes to run as accurately as possible. What is the best way to measure the performance?
Sheri from Gaithersburg
I have a text box in vb.net and I need the result to be converted into ‘int’ to store it in a Sql Server database. How can I do this?
Patrick from Maryland
Although CCD does most of its work using Microsoft products, many people come to us asking about LAMP. The standard reasons for selecting LAMP (Linux, Apache, MySQL, PHP) instead of combination of other software programs, servers and operating systems include:
All of those are open source resource. Security of linux can be much greater than that for windows. Apache can be a better server that IIS both in functionality and security. Mysql is the most popular open source database in the world. PHP is faster than asp or other scripting language.
If your firm is in Gaithersburg, Germantown, Rockville, or anywhere in the Maryland area, and you need some help with computer programming, please contact us!
According to CSS rules visibility:hidden and display:none both result in the element not being visible. How are they different?
From James Bean from Rockville
Hi Corbin Creative Databases,
I want to upsize an access database to sql server database, but I don’t know how to do it. Can you tell me how to upsize an access database to sql server?
Adam BC, LLC
Maryland
