Forum Replies Created
Viewing 15 posts - 3,526 through 3,540 (of 19,560 total)
-
RE: Cannot drop orphan data file
As much fun as it sounds, you could migrate the data into a new database with the appropriate filegroups etc.
Editing sysaltfiles directly is protected and shouldn't be done.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Problem inserting Japanese Text
Shadab Shah (2/20/2014)
Hello Experts ,I notice one more thing, That if i used N in the SP and not while calling , ???? gets inserted.
CREATE TABLE #TBL1 (Property nvarchar(255))
ALTER...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Today's Random Word!
Ed Wagner (2/21/2014)
Daniel Bowlin (2/21/2014)
crookj (2/21/2014)
WotD - Minutiaeatom
Bomb
Manure
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Property IsLocked is not available for Login
I can see memory issues causing (memory dumps) blocking logins. I haven't seen it actually change a login to be expired. I guess it's not much of a...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: The SQLCLR Impact
I have 5 clients using the same piece of software from a 3rd party vendor. This vendor has rolled out CLR procedures to each of the clients. In...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Cannot drop orphan data file
Do you have a backup of the database from before those files were deleted from disk?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Hi any one help me
Kind of necessary to share :hehe:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Backup/Restore
Igor Micev (2/21/2014)
The question is trivial.To ensure myself, I read this reference http://technet.microsoft.com/en-us/library/ms186388.aspx and I didn't see any correlation of the model's read_only property to the same for the restoring...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Max server memory
Woohoo - that's a win then. 😎
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Are the posted questions getting worse?
ChrisM@Work (2/21/2014)
rodjkidd (2/21/2014)
ChrisM@Work (2/21/2014)
SQLRNNR (2/20/2014)
ChrisM@Work (2/20/2014)
SQLRNNR (2/20/2014)
Sean Lange (2/20/2014)
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?What topic is that???
SQUIRREL
NUTS! WHOLE HAZELNUTS!! Careful, this could go downhill very quickly...
You...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: 15 minutes Interval from Hours - Please Help
dwain.c (2/20/2014)
SQLRNNR (2/20/2014)
dwain.c (2/20/2014)
SQLRNNR (2/20/2014)
Well done Dwain!!What do you think of the new thought question in my signature links?
Yes, I have been told that many times. They always want...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: 15 minutes Interval from Hours - Please Help
dwain.c (2/20/2014)
SQLRNNR (2/20/2014)
Well done Dwain!!What do you think of the new thought question in my signature links?
Yes, I have been told that many times. They always want things to...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Hi any one help me
The most likely for that is Label3.Text has a value that is not a DateTime value.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: 15 minutes Interval from Hours - Please Help
Well done Dwain!!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
RE: Help query
pietlinden (2/20/2014)
Good thing, because I was just starting to think about it and try to figure out a solution (Good learning exercise, but if you have actual work to do,...Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 3,526 through 3,540 (of 19,560 total)