Viewing 15 posts - 661 through 675 (of 1,409 total)
Are all values in the Excel sheet compatible with the corresponding datatypes of the columns in wich they are to be loaded?
September 6, 2013 at 3:42 am
Feeg (9/6/2013)
My bad ...
The storage engineer stopped the SQL service ...
created the new LUN ...
he physically...
September 6, 2013 at 2:22 am
You'll be learning much more if you try to create it yourself. If you run into problems we are glad to help.
SSMS has quite good scripting technology inside. So open...
September 6, 2013 at 2:00 am
The RAISERROR command in your trigger raises an error with a user defined number. This error is not a standard SQL error, but RAISERROR can still be done in SQL2012.
The...
September 5, 2013 at 11:57 pm
You need to look for a sort of data-analyzing tool. I know ERWIN (http://erwin.com/products/data-modeler/standard-edition) has the ability but this is a rather expensive application. Maybe you can download a trial...
September 5, 2013 at 2:49 pm
You need to change the HAVING clause to get your desired results. With the code below you can check if both 'Walker' and 'Cane' exists at least once.
HAVING sum(case when...
September 5, 2013 at 5:45 am
I suggest you start with the SQL Server 2008 R2 Best Practices Analyzer (BPA). You can also use the SP_BLITZ from Brent Ozar.
The results will give you a starting point...
September 5, 2013 at 3:06 am
If you apply the change I suggested, you won't be sending an e-mail when DIFF = 0. In the query you check if the DIFF is smaller then -3 or...
September 5, 2013 at 1:52 am
You need to change the IF NOT EXISTS to IF EXISTS.
In the above query you check if results does not exists. If this is true (no results) you want to...
September 5, 2013 at 1:35 am
Please take a step back and take a good look at your requirements.
Why do you want to insert the data using seperate insert statements? The performance will be a lot...
September 5, 2013 at 1:28 am
All backups have LSN, there is just a bit difference in the relation between these LSN's. A differential backup is depending on the previous FULL backup. You can find the...
September 5, 2013 at 1:12 am
If you have the space available, keep the LOG at 30GB. Don't shrink the file.
This space is needed by the load, so daily shrinking is a waist of resources and...
September 4, 2013 at 7:36 am
kapil_kk (9/4/2013)
what if the value if out of range of INT?
Then you have the BIGINT datatype 😛
But if this method is correct or not, depends on the data in the...
September 4, 2013 at 6:20 am
thava (9/4/2013)
...but is it not hard coded, is there a way we can do it dynamically,
What part is not hard coded? Are you talking about the definition/lay-out of the XML?...
September 4, 2013 at 6:02 am
The error is due to the implicit conversion of the datatypes within the CASE BETWEEN statement.
The INT datatype (from field [finmonth]) must be compared to the string value. Therefor the...
September 4, 2013 at 4:49 am
Viewing 15 posts - 661 through 675 (of 1,409 total)