Is there a Banwidth Monitor that keeps logs in MSSQL DB?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23387893.html
I have a SQL Server 2005 database. The tempdb.mdf is grown upto 10 GB now and I have very less space left in my C drive of the database server.
I have set the recover mode as "FULL". I have set ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2309...
Hi there,
I get two issues after migrating few databases, I see that certain INFORMATION_SCHEMAs doesn't work properly either it returns empty columns or shows an error as below:
Msg 208, Level...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2317...
I need to update one field of a table at particular time everyday.. is there any schedule option in sql server through which I can update this field
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23220334.html
Zones:
MS SQL ServerDate Answered: 03/06/2008 Rating: 9.5 Views: 0
How can I format sql getdate fuction?..eg. format date from 2008-03-06 00:01:00 to 06-03-08 00:001:00
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23220822.html
Zones:
MS SQL ServerDate Answered: 03/06/2008 Rating: 8.6 Views: 4
Hello,
Below is an SQL statement where I am pulling sales history for multiple weeks and placing them in columns. I would like to subtotal each column. Attached is the code...
The COMPUTE sta...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2328...
Dear Experts
I am have a SQL Server 2005 Database in which I have some tables contain Arabic Text, the datatype for those fields is NVARCHAR(n), now the arabic text inside database is appearing ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2355...
It seems like I should be able to do something like this:
SELECT * FROM users where 3 = 'SomeGuy'
instead of needing to use the field name like this:
SELECT * FROM users where username = 'So...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23603096.html
I am an Basic programmer just learning SQL. I am using a Universe relational database. IBM touts this as a relational database and they have their own version of Basic which is what I currently u...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2362...
I have a record of dated occurrences. For example:
On 01/01/08 John Doe was discharged from the hospital
On 01/05/08 John was assessed
On 02/06/08 John was discharged from the hospital and ass...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2362...
