I've been reading articles about tempdb optimizations and I already understand a lot better the different ways to archive it. I read (for example)...
I would like to known who did start the sql server agent service. From the application log I can see an event indicating that the service started...
Hello everybody: I have a linked server from SQL Server 2000 and SQL Server 2005 to Oracle 10g. Both installations are Win2K3 R2 x64, SQL Server...
How can one remove idle connections that are just sitting/sleeping. Most of the time the developers are hitting the database through some front end...
Hello everybody, I need add a watermark to my word or excel exported files. Does somebody know how can I do it?. Does the watermark exits in RS2008??...
Hello, Can I modify/overwrite System Stored Produres in SQL Server 2000?? What are the implications of running an Alter Procedure statement over a...
Hi everybody Does order in SQL Server 2005 matter in a JOIN clause? How can the performance be affected by the order of the tables in the JOIN...
please take a look to http://msdn2.microsoft.com/en-us/library/ms189871.aspx what I mean is which are the minimum recommended DDL triggers I should...
Hello everybody I found the problem. The time out is originated from SSMS not from SQL Server engine. To correct the problem:...
Thank you for your answer. I set the execution time out.
Hello everybody: I have a SQL Server intance with SP2. I want to modify the colum's order of one of my tables, which has 600.000 records. the time...
Hello everyone, Currently I’m familiarized with DDL and I’m hardening my SQl Server, however I have a question which are the minimum o...
Hello everybody: The following query finds all products that have a price greater than the average for products of its subcategory: SELECT...
Hello Create a storeprocedure with parameters and call it from each table trigger. Hernan
what languages are supported by full text search service? I mean, can I use full text search queries over text fields wrote in spanish or french??
Hi guys, I appreciate your answers, but I think this isn't the response I was expecting. In my example, both the principal and the mirror server are...
Hello everybody, In high performance mode, the principal and mirror servers work asynchronously. The principal server does not wait for...
Hello everybody, How can I get scripts definitions for all objects (tables, views, procedures....) from a database in a single procedure? thanks in...
Helo Satya, I would like to known what the properly name for that "expression language" is? My post are not the same, I want to know if the...
Hello all, Which is the expression language that I should use in SSRS?? I mean, is it VBScript or...?? Thank you in advance. Hernán.
Separate names with a comma.
