Archive for April, 2008

Sql Server Order By Datetime

Wednesday, April 30th, 2008

Tecnologías de Microsoft en los Servidores IX

hopfeed_template=”";
hopfeed_align=”LEFT”;
hopfeed_type=”IFRAME”;
hopfeed_affiliate_tid=”sql”;
hopfeed_affiliate=”ghebrillic”;
hopfeed_fill_slots=”false”;
hopfeed_height=280;
hopfeed_width=336;
hopfeed_cellpadding=5;
hopfeed_rows=3;
hopfeed_cols=1;
hopfeed_font=”Verdana, Arial, Helvetica, Sans Serif”;
hopfeed_font_size=”9pt”;
hopfeed_font_color=”#000000″;
hopfeed_border_color=”#FFFFFF”;
hopfeed_link_font_color=”#3300FF”;
hopfeed_link_font_hover_color=”#3300FF”;
hopfeed_background_color=”#FFFFFF”;
hopfeed_keywords=”Sql+Server+Order+By+Datetime”;
hopfeed_path=”http://ghebrillic.hopfeed.com”;
hopfeed_link_target=”_blank”;

Sql Server Case Statements

Wednesday, April 30th, 2008

Stories of SQL Server is full of episodes in which the user is faced with many software and hardware problems that are responsible for the corruption of bases SQL data. Errors indicate l 'deviation from the ideal job, SQL Server must perform. That error is:

"Error 823

I / O error detected [...]

Sql Server Add Column

Wednesday, April 30th, 2008

What is the command in SQL Server 2000 to add the column in existing table created?.
Column can be placed anywhere. I expect an answer SQL Server 2000 only
This is an example … Table: MyTable New Field Name: Data Type ADDDATE: Restrictions smalldatetime: ALTER smalldatetime null TABLE MyTable Add ADDDATE NULL
Did you [...]

Sql Server Query Optimization Techniques

Tuesday, April 29th, 2008

If you read the Internet and all the websites dedicated to Asp.Net inevitably read the wonders of the DataGrid, DataList, and Repeater. If each has its place, if only data that shows there is much more rapid and efficient means to do so.
Say you have a page that displays items based on [...]

Sql Server Backup Strategy

Monday, April 28th, 2008

ERP Microsoft Dynamics GP, formerly Great Plains Dynamics and eEnterprise, is a client-server, which means that if you are a small business and not in house IT department, hardware support Dynamics GP and parts of the network could be a problem. Consider the needs of the first to select the server hardware, to often [...]

Sql Server Performance Monitor Counters

Sunday, April 27th, 2008

How to save perf counters to a file & create counter a log

hopfeed_template=”";
hopfeed_align=”LEFT”;
hopfeed_type=”IFRAME”;
hopfeed_affiliate_tid=”sql”;
hopfeed_affiliate=”ghebrillic”;
hopfeed_fill_slots=”false”;
hopfeed_height=280;
hopfeed_width=336;
hopfeed_cellpadding=5;
hopfeed_rows=3;
hopfeed_cols=1;
hopfeed_font=”Verdana, Arial, Helvetica, Sans Serif”;
hopfeed_font_size=”9pt”;
hopfeed_font_color=”#000000″;
hopfeed_border_color=”#FFFFFF”;
hopfeed_link_font_color=”#3300FF”;
hopfeed_link_font_hover_color=”#3300FF”;
hopfeed_background_color=”#FFFFFF”;
hopfeed_keywords=”Sql+Server+Performance+Monitor+Counters”;
hopfeed_path=”http://ghebrillic.hopfeed.com”;
hopfeed_link_target=”_blank”;

Sql Server Web Edition Limitations

Sunday, April 27th, 2008

It is very common for people who are currently working on a limited budget, what else, not the global economic crisis we face today can not spend some extra money for unnecessary things that no exception to this even people who work online are frugal with their spending too. Fortunately, the field of [...]

Sql Server Queries For Interview

Friday, April 25th, 2008

Procedure of the store is a SQL query that is stored in SQL Server. One thing is there is no need to write the questions on the front end code. Use procedure Store performance improvement now raises the question of improving their performance. Suppose we put a little select query (SELECT * FROM dotnetquestion [...]

Sql Server Left Outer Join

Friday, April 25th, 2008

MS SQL Server outsourcing and the WHERE clause?
Hello, I have two tables: – tblTimeSlots: This table has 48 entries (1 .. 48). Campi: timeslot_id (integer) time slot (varchar) – tblAppointments: This table stores timeslot, date and client name Sector: timeslot_id (whole), agent (full), date (date and time), varchar (client) So far I have written [...]

Sql Server Agent Proxy Account

Friday, April 25th, 2008

Active X can not create object – permits SQL Server 2005, why?
I have problems with an instance of an object. I know this reduced to the permissions, but I'm not sure what the next steps for the solution. Basically, I have an asp.net application that calls a stored by SQL Server 2005. This I [...]