Forum Replies Created

Viewing 15 posts - 1,846 through 1,860 (of 13,460 total)

  • RE: 50000 error executing stored process

    sandeep1553 (4/2/2015)

    Hi Grasshopper,

    Did you get the answer for this question. Because I am facing the same problem .If got the answer, please let me know

    Thank you

    sandy

    look in your code...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 2, 2015 at 7:59 am

    #1788321

  • RE: Script for alter NonClustered Index to Custered across all databases

    since you can only have ONE clustered index on a table, your idea will fail for any table with more than one index.

    performance will not automagically improve due to a...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 2, 2015 at 6:57 am

    #1788284

  • RE: Truncate table failing (intermittently), no errors presenting.

    pretty sure you can't truncate a table if it's referenced by indexed views or foreign keys, or views or functions that were created WITH SCHEMABINDING either.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2015 at 2:57 pm

    #1788143

  • RE: HYPER-V query ?

    so you want to know if your SQL server is contained in a HyperV environment? is that the question?

    i know @@version contains a string when it's in a VM:...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2015 at 2:44 pm

    #1788139

  • RE: 9.3 GB bak won't restore to (10 GB limit) SQL Server Express 2008 R2

    the cost of a developer edition license is in the range of fifty or so dollars on Amazon, and well worth the investment.

    that will get you over your limitations imposed...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 1, 2015 at 6:04 am

    #1787984

  • RE: restore database error

    are you restoring a 2014 database on a 2012 instance? that's the error i'd expect.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 31, 2015 at 9:42 am

    #1787777

  • RE: If Celko was a rock star, which one would he be?

    Rick Astley.

    every time i see a Celko post, i get a bit PO'd like I've been rick rolled.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 30, 2015 at 1:15 pm

    #1787478

  • RE: Get DDL for any SQL 2005 table

    OK for the folks who have bothered to follow this thread, a minor update, with a bunch of changes that i added myself,as well as some that were also contributed...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 30, 2015 at 1:03 pm

    #1787470

  • RE: Unable to pass the values between functions (in Grid, no data is being displayed)

    not an expert on powershell, but i certainly use it a bit.

    i'd be thinking the issue is scope;

    it looks to me like none of your functions accept parameters.(AcceptedFeatures,Process,ShowinOutGrid).

    what specific variables...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 30, 2015 at 9:02 am

    #1787388

  • RE: Report Model download and backup, also best practice

    i've used this project quite a few times:

    https://ssrscatalogqueries.codeplex.com/

    i had to enhance it quite a bit, and it's still not where i want it.

    it downloads all the files into sub folders,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 30, 2015 at 8:48 am

    #1787379

  • RE: sp_who3 does not show any active processes?

    Google, test, repeat until you find one you like, or adapt one that fits your specific needs.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 28, 2015 at 1:25 pm

    #1787115

  • RE: how to get the answer from "count(*) into a textbox

    ExecuteScalar will return a single value....that's what you want.

    untested, but this is roughly what you want:

    Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click

    myconnection.Open()

    'define the command

    Dim cmd As New...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 27, 2015 at 1:58 pm

    #1787029

  • RE: Create Temp Table vs Truncate & Insert - Performance

    my fast proof of concept: drop and recreate is definitely slower

    in a measly 1000 iterations,these were my stats:

    2113 milliseconds for Drop and Recreate

    543 milliseconds for Truncate Existing Table

    and my test...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 26, 2015 at 3:06 pm

    #1786696

  • RE: Whoops deleted a shared data source

    this seems to get me most of the data sources in the current catalogs as a direct query:

    WITH MyCTE

    AS

    (

    select convert(varchar(max),CONVERT(varbinary(max),Content))As StrContent,*

    from reportserver.dbo.Catalog

    )

    SELECT SUBSTRING(StrContent,p1.i,p2.i - p1.i),* FROM MyCTE

    CROSS APPLY(SELECT...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 26, 2015 at 6:31 am

    #1786519

  • RE: Whoops deleted a shared data source

    reports change very rarely...can you simply restore the ReportServer database to the day before you stepped on the data source?

    if not, can you restore the database as a different name,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    March 26, 2015 at 6:23 am

    #1786516

Viewing 15 posts - 1,846 through 1,860 (of 13,460 total)