Viewing 15 posts - 16 through 30 (of 405 total)
Lynn Pettis (12/14/2016)
junk.mail291276 (12/14/2016)
I have a stored procedure that takes a project ID as a parameter and returns a list of results on that project. Now what I'd like to...
December 15, 2016 at 3:48 am
Use Powershell
Its a good idea to return result to a variable.
You can also use xp_cmdshell and make a single sp to do both
December 14, 2016 at 9:31 am
coolchaitu (12/12/2016)
Hi Gail,The mdf file is available. So there shouldnt be any data loss, correct?
The pages in memory are not hardened to the physical data file immediately. But the log...
December 14, 2016 at 8:39 am
If there is a max size set on the file remove it, and if there is no more space left in the drive adding a new file to a...
December 14, 2016 at 4:18 am
Forcing plan in my opinion is a temporary workaround. Since a change in data growth pattern may give you a less optimal performance after some time. If you know what...
December 13, 2016 at 10:59 am
tcronin 95651 (12/13/2016)
yes scan was quicker I guess the engine is smarter than the average bear
If your statistics are up to date the plan generated by SQL is most of...
December 13, 2016 at 9:07 am
pankaj 43245 (12/13/2016)
i can replace them with update but to do this for 1892 user on 5 different table is time consuming task.
Create and excel with source and target values
Import...
December 13, 2016 at 3:17 am
I am not aware of any known issues with Reportservertempdb. I do not think any changes to it is supported.
However you can use general monitoring counters for memory CPU and...
December 12, 2016 at 10:00 am
Robin35 (12/12/2016)
Our ReportServerTmpdb log file is full and our reports are receiving this error. i'm trying to understand, what causes this log file to grow and how can we prevent...
December 12, 2016 at 9:00 am
SQL Learner - VKG (12/7/2016)
I a table of around 10 GB size. Recovery model of database (SQL Server 2005) is simple. For some requirement, I added a clustered index...
December 12, 2016 at 7:56 am
It depends on how and from where you get values for your parameters. Probably you are alright here, but it is good practice to use parameterized whenever possible.
December 12, 2016 at 5:26 am
pinky_sam05 (12/12/2016)
Thanks @joeroshan for ur help.I have done like this.Here I just printed msg but in reality I will do insert...
You are welcome. Glad you got it worked. I was...
December 12, 2016 at 5:00 am
Probably this will clear your doubt.
declare @Inserttbl nvarchar(4000)
declare @TableName varchar(50)
declare @Text varchar(50)=null
declare @count int
set @TableName ='sample'
set @Text = null
set @Inserttbl = ' Insert into Test.dbo.' +@TableName +' values (3,'+@Text+',1)'
select @Inserttbl
set...
December 12, 2016 at 3:54 am
By default concatenating with null, the entire text will become null.
Try @text='null'
December 12, 2016 at 3:40 am
Viewing 15 posts - 16 through 30 (of 405 total)