Viewing 15 posts - 1,756 through 1,770 (of 2,008 total)
It's pretty bad table design. Do you have control on DB Design? Are you open for redesigning the table? It will solve many problems else query would be complex (and...
November 9, 2011 at 4:59 am
We would be able to help you better if you provide following.
•DDL for the table.
•Sample Data
•Expected report output and report parameters
•Existing scripts, if any
November 9, 2011 at 4:22 am
It may be too much for you but I would recommend you to go through the article.
Reorganizing and Rebuilding Indexes
November 9, 2011 at 3:40 am
UPDATE dbo.EMPSEQUENCE SET Sequence = ( Sequence + 1 )
You don't have any specific logic to generate EMPSEQUENCE (just +1). If the function is to generate IDs please use...
November 9, 2011 at 2:33 am
Snippet from your post... Errors & respective suggestions by SQL Server itself.
The transaction log for database 'msdb' is full. To find out why space in the log cannot be reused,...
November 9, 2011 at 2:24 am
1. Need a Cluster Environment with ACTIVE-ACTIVE mode
SQL Server Clusters supports this.
2. Need a load balancing environment for the software used in the application
a. Sql Server 2008 R2...
November 9, 2011 at 1:37 am
I have no issue doing this but now I need to check within 60 minutes on the 1/2 hour - so for example between 1030->1130.
Create a computed (or actual) column...
November 9, 2011 at 1:26 am
what would be a good percentage to have of memory to database size ?
There is no straight formula for it (I wish to have it). It mostly depends on Data...
November 9, 2011 at 1:19 am
now i want to create another one package to run this 2 sub package(main1,main2)how to do this in ssis
I am very sure it's doable but I can't give exact steps...
November 9, 2011 at 1:14 am
The debate is over the below statement:
Should you match the amount of sql memory to the total size of databases you are storing on the server?
-So if you have 150gb...
November 9, 2011 at 1:11 am
Easy & Safe Solution: Validate mobile number before inserting into the table. This validation can be done at application (preferred) or in stored procedure in SQL Server. Don't validate it...
November 9, 2011 at 1:03 am
Item cannot be found in the collection corresponding to the requested name or ordinal.
It usually appears when your resultset (SQL) doesn't match with Recordset (VB). Some columns or column order...
November 9, 2011 at 12:55 am
Joy Smith San (11/8/2011)
You could also log into the server, open task manager, and go to the services tab...Jared
Windows task manager you mean. ? I am not able to...
November 9, 2011 at 12:38 am
Viewing 15 posts - 1,756 through 1,770 (of 2,008 total)