Lynn Pettis (12/14/2016)

---

junk.mail291276 (12/14/2016)

---

Hello,

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...

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

The pages in memory are not hardened to the physical data file immediately. But the log...

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...

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...

If your statistics are up to date the plan generated by SQL is most of...

Create and excel with source and target values

Import...

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...

Robin35 (12/12/2016)

---

Hello,

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...

SQL Learner - VKG (12/7/2016)

---

Hello Guys,

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...

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.

And hope you are happy with the result.

You are welcome. Glad you got it worked....

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...

By default concatenating with null, the entire text will become null.

Try @text='null'