Viewing 15 posts - 3,796 through 3,810 (of 8,761 total)
Simple suggestion
😎
DECLARE
@cols AS NVARCHAR(MAX),
@selcols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX),
@startdate datetime,
...
March 20, 2016 at 9:09 am
mburbea (3/20/2016)
I decided to try to change the number...
March 20, 2016 at 8:39 am
Once had a DBA that every one liked, he was busy taking care of all the users and in general highly regarded. After a little while I started to notice...
March 20, 2016 at 8:34 am
March 20, 2016 at 8:16 am
coolchaitu (3/20/2016)
There is no space on other drive to add file.Please advise
Quick questions:
1. What is the disk setup on the server (Volumes,Sizes etc.)?
2. What are the recovery models on the...
March 20, 2016 at 8:15 am
If I understand the requirements correctly you want all the instances with blank Phone where the same FirstName,LastName,BranchFk exists with a non-blank phone.
😎
Quick suggestion
USE tempdb;
SET NOCOUNT ON;
GO
CREATE TABLE
#Employee
(
EmployeePk INT,
FirstName...
March 20, 2016 at 5:39 am
coolchaitu (3/19/2016)
It is not tempdb. It is an user database
Not sure how I got tempdb mixed up in this, guess I just blame my bad eyesight reading off the mobile:-)
Did...
March 20, 2016 at 5:23 am
Thanks for this, now just one more thing, do you have some sample data as an insert statement for the two tables, safes me having to speculate what could/should be...
March 20, 2016 at 5:15 am
The main difference between those two queries is that the first (#1) uses a Stream Aggregation Operator to sum the values while the second (#2) uses an Arithmetic Addition and...
March 20, 2016 at 5:00 am
Can you post the DDL for the AdeccoView table and some sample data as an insert statement, makes answering the question much easier.
😎
March 20, 2016 at 4:49 am
mburbea (3/19/2016)
March 20, 2016 at 3:58 am
Tempdb is always in simple recovery so backup is futile, find out what is filling the log or even better, add the new file and see if what ever operation...
March 19, 2016 at 6:37 am
coolchaitu (3/19/2016)
Good morning Experts,Transaction log file is full. I cannot even issue backup log command as there is no space at all. Please advise the best solution
Temporarily add a file...
March 19, 2016 at 6:00 am
Quick suggestions: don't use table variables for any kind of serious testing and include covering indices to eliminate sorts and key lookups.
😎
IF OBJECT_ID(N'dbo.OrderDetails') IS NOT NULL DROP TABLE dbo.OrderDetails;
CREATE TABLE...
March 18, 2016 at 4:09 pm
mburbea (3/18/2016)
March 18, 2016 at 3:53 pm
Viewing 15 posts - 3,796 through 3,810 (of 8,761 total)